P.S: This is just a study guide. The questions may not appear exactly like this.
(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.
(TCO 2) A noun in a business rule usually translates to a(n) ____ in the data model.
(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
(TCO 2) A _____ primary key is made up of more than one attribute.
(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?
Correct answer: 3
(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.
(TCO 2) A table that is in 1NF and includes no partial dependencies only is said to be in _____.
(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
(TCO 2) Entity attributes and primary keys are not present in the _____ data model.