Conceptual, Logical and Phtsical Database Design, Chapter 11

In most modern relational DBMSs, such as IBM DB2, Microsoft SQL Server, and Oracle, a new database implementation requires the creation of special storage-related constructs to house the end-user tables. These constructs include ____.
1. segments
2. constraints
3. indexes
4. table spaces
____ design is the process of selecting the data storage and data access characteristics of the database.
1. Time
2. Network
3. Logical
4. Physical
In the ________________ stage, data modelling is used to create an abstract database structure that represents real-world objects in the most realistic way possible.
1. physical design
2. ER verification
3. conceptual design
4. logical design
Steps in developing the conceptual model include:
1. identifying the main business rules
2. identifying the main entities
3. identifying all relationships
4. all of the above
The term ____ describes the strength of the relationships found among the module's entities.
1. adhesion
2. cohesivity
3. coupling
4. modularity
____ coupling describes the extent to which modules are independent of one another.
1. Verification
2. Process
3. Module
4. Cohesive
The aim of ________________ is to map the conceptual model into a form which can then be implemented on a relational DBMS.
1. physical design
2. ER verification
3. conceptual design
4. logical design
What is the first step in converting the ER model from the conceptual design phase into a set of relations?
1. Create Relations for Strong Entities
2. Map multivalued attributes
3. Create Relations for Weak Entities
4. Map binary relations
___________________ requires the definition of specific storage or access methods that will be used by the database.
1. logical design
2. conceptual design
3. Translation of logical relations into tables
4. physical design
Selecting the most suitable _________________ is very important to ensure that the data is stored efficiently and data can be retrieved as quickly as possible.
1. DBMS
2. file organization
3. indexes
4. logical relations
A ____________ is often used on multidimensional data held in data warehouses.
1. bitmap index
2. B-tree
3. hashing algorithm
4. primary index
Clustering is not a good idea when_______________________.
1. database tables are frequently joined together
2. data is regular inserted or updated in a table
3. there is no cluster key
4. applications require a full database table to be scanned.
____________________ are usually placed on additional fields which are used regularly in user queries in order to increase the speed of data retrieval.
1. bitmap indexes
2. secondary indexes
3. unique indexes
4. primary indexes
The SQL command _________is used to withdraw privileges on specific user accounts.
1. REMOVE
2. REVOKE
3. ROLE
4. GRANT
Files which follow the_____________ are often referred to as random or direct files.
1. heaped organization
2. sequential organization
3. indexed organization
4. hashed organization
__________________is usually the first stage of physical database design.
1. Analyzing user queries and the size of the database
2. Determine a suitable file organization
3. Translate each relation identifi ed in the logical data model into a table
4. Defining indexes
In logical database design, when mapping binary 1:* relations.
1. create the relations for each of the two entities that are participating in the
  relationship and create the foreign key on the ‘many’ side by including the primary key attribute from the ‘one’ side.
2. check to see if there is mandatory participation on one side of the relationship, then the entity which has the optional participation becomes the parent entity and the entity that has the mandatory relationship becomes the dependent entity. The relation corresponding to the parent entity should contain the foreign key of the dependent entity
3. create the relations for each of the two entities that are participating in the relationship. Then create a third relation to represent the actual relationship. The third relation will contain the foreign keys of the two original entries that participate in the original relationship.
4. check to see if both entities are in a mandatory participation in a relationship and they do not participate in other relationships, it is then most likely that the two entities should be part of the same entity.
In the following relation, what is the primary key ?
RENT_LINE(RENT_NUM*, RENT_LINE_NUM*, RENT_LINE_CHARGE, DATE, COPY_CODE*)
1. RENT_NUM
2. RENT_LINE_NUM
3. RENT_NUM and RENT_LINE_NUM
4. RENT_NUM and RENT_LINE_NUM and COPY_CODE
A(n) _____________________ is a brief and precise narrative description of a policy, procedure or principle within a specific organization’s environment.
1. end-user brief
2. operational description
3. conceptual model
4. business rule
Indexes should not be used when:
1. tables have low sparsity
2. attributes appear often in the WHERE clause
3. using joins
4. tables have high sparsity

Conceptual, Logical and Phtsical Database Design, Chapter 11

Quiz