Match the following terms to the appropriate definitions: _____ well-structured relation _____ anomaly _____ functional dependency _____
Question:
Match the following terms to the appropriate definitions:
_____ well-structured relation
_____ anomaly
_____ functional dependency
_____ determinant
_____ composite key
_____ 1nf
_____ 2nf
_____ 3nf
_____ recursive foreign key
_____ relation
_____ transitive dependency
a. Constraint between two attributes
b. Functional dependency between the primary key and a nonkey attribute via another nonkey attribute
c. References the primary key in the same relation
d. Multivalued attributes removed
e. Inconsistency or error
f. Contains little redundancy
g. Contains two (or more) attributes
h. Contains no partial functional dependencies
i. Transitive dependencies eliminated
j. Attribute on left side of functional dependency
k. Named two-dimensional table of data
Step by Step Answer:
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman