Match each of the following terms with its corresponding definition.
-An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.
A)foreign key
B)functional dependency
C)homonym
D)normalization
E)recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation

Question

Quizplus · Accepted Answer

B) functional dependency - A constraint between two attributes in which one attribute determines the value of another attribute.
C) homonym - A situation in which two or more attributes have the same name but different meanings.
D) normalization - The process of organizing a database to minimize redundancy and dependency.
E) recursive foreign key - A foreign key that points back to the same table.
F) referential integrity - A constraint that ensures that a foreign key value always refers to an existing primary key value.
G) relation - A table that contains data about a specific entity or relationship.
H) relational database model - A model that uses relations or tables to organize and store data in a database.
I) second normal form (2NF) - A relation in which all nonkey attributes are functionally dependent on the entire primary key.
J) synonym - A situation in which two or more attributes have the same meaning but different names.
K) third normal form (3NF) - A relation in which all nonkey attributes are functionally dependent on the primary key but not on any other nonkey attributes.
L) well-structured relation - A relation that conforms to the rules of normalization and has no functional dependencies between nonkey attributes.

Answer: 
A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key 
F) referential integrity 
G) relation 
H) relational database model 
I) second normal form (2NF) 
J) synonym 
K) third normal form (3NF)
L) well-structured relation

All the choices are correctly matched with their definitions.

Match Each of the Following Terms with Its Corresponding Definition