Question 1
All of the following are questions to ask in the process of identifying entities except the following.
• Can you envision more than one instance of the entity?
• Is there a variation over time?
• Is the item to be modeled a person, place, thing, or an event?
• Is the item to be modeled an attribute?
Question 2
Logical design refers to
• developing a database model that will support company operations.
• developing a thorough understanding of what needs to be done in developing a database.
• translating the conceptual design into the selected model for use in a database system.
• understanding the business and its functional areas or business processes.
Question 3
Conceptual design refers to
• developing a database model that will support company operations.
• focusing on understanding the business and its functional areas or business processes.
• selecting the specific hardware characteristics based on data storage and data access requirements.
• the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
Question 4
Which of the following is NOT a step in the database life cycle?
• Database design
• Maintenance and redevelopment
• Performance
• Testing
Question 5
The term cardinality refers to
• a count of the total records in a table.
• a field which is a candidate for a primary key.
• the number of records in a relationship.
• the most important field in a table.
Question 6
A primary key
• can be computer generated.
• consists of one field only that uniquely identifies each record in a table.
• is a relationship between two or more tables.
• All of the above
Question 7
What does not define a composite key?
• Using two or more fields as a primary key
• Using three fields as a primary key
• Using two fields as a primary key
• Using one field as a primary key
Question 8
Which statement below is NOT true of one-to-many relationships?
• It is the least-used type of relationship.
• The table with the primary key must only have one occurrence of each value for the primary key.
• The foreign key in the related table may have repeating values for the foreign key.
• An example is that one employee may take multiple orders.
Question 9
• Which is NOT true of validation rules?
• They enforce a size limit.
• They check authenticity of data entered in a field.
• An error message will appear if a rule is violated.
• They protect from fraudulent practices.
Question 10
Which statement is true when referential integrity is enforced?
• It is an automatic option in every table design.
• Access checks the accuracy of spelling in the tables.
• It ensures data can be entered into a related table, even if it does not exist in the primary table.
• A record will not be added to the table if an ID that is referenced does not exist.
