P.S: This is just a study guide. The questions may not appear exactly like this.
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