1.Normalization is a process for evaluating and correcting table structures to minimize _____.
A) data redundancy and anomalies
2. Which of the following is false about unnormalized data?
A) Unnormalized data is related data.
3. Which of the following is NOT true?
A) Fourth normal form (4NF): 3NF and no dependent multivalued dependencies
4. Which of the following statements best describes partial dependency?
A) A partial dependency exists when there is a functional dependence in which the determinant is only part of the primary key.
5. Which of the following statements best defines transitive dependency?
A) A condition in which an attribute is dependent on another attribute that is not part of the primary key
6. Repeating group is defined as _____.
A) a characteristic describing a group of multiple entries of the same or multiple types for a single key attribute occurrence
7. Atomicity refers to?
A) An attribute is atomic that cannot be further subdivided.
8. Which of the following is not valid about the ER model?
A) Should contain redundant relationships except as required
9. Which of the following is not valid related to attribute naming convention?
A) Should not use the entity abbreviation as a prefix
10. Which of the following is valid?
A) Each entity should represent a set of distinguishable entity instances.