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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: