Matching
Match the following terms to their description.
Premises:
Surrogate key
Primary key
Artificial key
Composite key
Natural key
Responses:
A field that uniquely identifies a record
Created from routinely occurring data generated outside of a database
Nonnaturally occurring data that is visible to the user
Sometimes referred to as a concatenated key
Nonnaturally occurring data that is not visible to the user
Correct Answer:
Premises:
Responses:
Surrogate key
Primary key
Artificial key
Composite key
Natural key
Premises:
Surrogate key
Primary key
Artificial key
Composite key
Natural key
Responses:
Related Questions
Q11: _ will remove every record with the
Q12: An example of an artificial key is
Q13: The _ normal form dictates that the
Q14: A primary key is a field that
Q15: A surrogate key can increase the file
Q17: By normalizing to _,you are eliminating all
Q18: When multiple fields are used to identify
Q19: A deletion anomaly forces you to delete
Q20: Match the following terms to their description.
Q21: One goal of normalization is to minimize