Assignment

Question 1. All of the following are questions to ask in the process of identifying entities EXCEPT:
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. All of the following explain index usage EXCEPT
a primary field uses an index.
adding an index to a table might decrease overall database performance slightly.
an index can reduce the amount of time it takes for Access to run queries and reports.
indexes are created using the Index property type.

Question 4. Which of the following is NOT a step in the Database Life Cycle?
Database Design
Maintenance and Redevelopment
Performance
Testing

Question 5. A one-to-many relationship is
a relationship that guarantees that a record is unique.
an association between a record and its fields.
used to describe attributes.
when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.

Question 6. An associative table is
used to identify primary keys between tables.
a child of two parent tables that are in a many-to-many relationship.
an integrity element within a table relationship.
a tool that allows you to locate an excel file.

Question 7. Which of the following does NOT describe data redundancy?
The same data exists in multiple tables.
The data is always in linked tables.
Data updating must be done in multiple table locations.
Data redundancy can result in data anomalies.

Question 8. Entity attributes are represented as
fields.
files.
records.
tables.

Question 9. You can reserve space for a field using the
PNPI regulations.
Sarbanes-Oxley Act.
field size property.
validation rule.

Question 10. Which statement does NOT describe the one-to-one relationship?
Many matching records exist between several tables.
Two different tables use the same primary key.
Exactly one record exists in the first table for each record in the second table.
It may be used for security reasons to protect data availability.