1. Match the Following Terms on the Left with the Correct Definitions on the Right:
J. Normalization H. Referential Integrity D. Anomoly G. Functional Dependency A. Transitive Dependency B. Composite Key K. Multi-valued Key E. 1NF C. 2NF I. 3NF F. BCNF |
A. B. C. D. E. F. G. H. I. J. K. |
Functional Dependency Between nonkey attributes An Attribute that can be broken down into component parts Contains no partial Dependencies Inconsistency or errors created in editing Contains no repeating groups Accounts for Editting Anomolies The value of one attribute depends on a primary key Constraint between 2 attributes Transitive Dependencies eliminated The process of determining how attributes should be grouped An attribute that may take on more than one value |