(CO 2) Which of the following is an example of an entity in a business?
• Company
• CEO
• Employees
• Business owner

Question 2

(CO 2) Physical design refers to

• selecting the specific hardware characteristics based on data storage and data access requirements.
• developing a database model that will support company operations.
• the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
• purchasing your hardware components.

Question 3

(CO 3) Conceptual design refers to
• the process of converting your ERD into tables and defining your rows and columns based your entities and attributes.
• selecting the specific hardware characteristics based on data storage and data access requirements.
• focusing on understanding the business and its functional areas or business processes.
• developing a database model that will support company operations.

Question 4

(CO 2) A domain is a
• group of data types that describe what kind of information that may be stored in a field.
• model of the database.
• set of values.
• the set of primary and foreign keys in a database.

Question 5

(CO 2) All of the following describe a many-to-many relationship in Access except
• a junction (associative) table is used.
• there must be at least two tables.
• may be used to connect to Oracle and other databases.
• many matching records are found in each direction between tables.

Question 6

(CO 2) A primary key
• is a relationship between two or more tables.
• consists of one field only that uniquely identifies each record in a table.
• All of the above
• can be computer generated.

Question 7

(TCO 3) Referential integrity constraints are
• data errors after they are entered into a table.
• ways to type data accurately into a table.
• a set of rules the database uses.
• a primary key in a table.

Question 8

(CO 4) Which statement below is NOT true of one-to-many relationships?
• The table with the primary key must only have one occurrence of each value for the primary key.
• An example is that one employee may take multiple orders.
• It is the least-used type of relationship.
• The foreign key in the related table may have repeating values for the foreign key.

Question 9

(CO 4) You can reserve space for a field using the
• validation rule.
• field size property.
• Sarbanes-Oxley Act.
• PNPI regulations.

Question 10

(CO 4) All of the following are examples of primary keys except

• last name.
• social security number.
• ISBN number on a textbook.
• employee ID.