Question 2
(TCO 2) _____ integrity insures that the value of a foreign key must match a primary key value in the table to which it is related, or be null.
1. Referential
2. Entity
3. Data
4. Logical

Question 3
(TCO 2) A noun in a business rule usually translates to a(n) ____ in the data model.

1. entity
2. attribute
3. relationship
4. constraint

Question 4
(TCO 4) A(n) ____ provides a detailed description of all attributes in the ERD including their datatypes.
1. entity relationship diagram

2. data dictionary
3. business rule
4. pseudocode

Question 5
(TCO 2) A _____ primary key is made up of more than one attribute.

1. composite
2. foreign
3. bridge
4. linking

Question 6
(TCO 4) In a typical university scenario, which of the following diagrams best represents the relationship between students and classes for which the student is registered?

Question 7

(TCO 2) Normalization works through a series of stages called normal forms. Typically _____ stage(s) must be completed before a table can be considered normalized.
1. one
2. two
3. three
4. four

Question 8
(TCO 2) A table that is in 1NF and includes no partial dependencies only is said to be in _____.
1. 1NF
2. 2NF
3. 3NF
4. BCNF

Question 9
(TCO 2) To be in the third normal form, _____.

1. each nonkey column must depend only on the primary key
2. each nonkey column must not depend on the primary key
3. each nonkey column must contain repeating values
4. All of the above

Question 10
(TCO 2) Entity attributes and primary keys are not present in the _____ data model.
1. logical
2. physical
3. conceptual
4. network