Banner ID: Name 7.can be considered a process of analyzing the given relation schemas _i based on their FDs and primary keys to achieve the desirable properties of 1) minimizing redundancy and 2) minimizing the insertion, deletion, and update anomalies. A) Logical database design B) Normalization of data C) Conceptual database design D) Physical database design 8. When all multivalued attributes have been removed from a relation, it is saidt be in: A) first normal form. B) second normal form. C) Boyce-Codd normal form. D) third normal form. 9. An attribute (or attributes) that uniquely identifies each row in a relation is called a A) column B) foreign field C) primary key D) duplicate key 10. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a A) link attribute B) link key C) foreign key D) foreign attribute 11. A candidate key must satisfy all of the following conditions EXCEPT A) the key must uniquely identify the row. B) the key must indicate the row's position in the table. C) the key must be nonredundant. D) each nonkey attribute is functionally dependent upon it