Matching
Match the following terms to their description.
Premises:
3NF
BCNF
NF
ERD
2NF
Responses:
The table has no fields with partial dependencies on a composite or concatenated key and satisfies 1NF.
The table has to be free of transitive dependencies and satisfy all lower levels of NF.
The table must not have repeating groups of values in a single column and it must have a key.
All determinants are candidate keys and satisfy all lower levels of NF.
Common way to visually express the tables and relationships in your database.
Correct Answer:
Premises:
Responses:
3NF
BCNF
NF
ERD
2NF
Premises:
3NF
BCNF
NF
ERD
2NF
Responses:
Related Questions
Q15: A surrogate key can increase the file
Q16: Match the following terms to their description.
Q17: By normalizing to _,you are eliminating all
Q18: When multiple fields are used to identify
Q19: A deletion anomaly forces you to delete
Q21: One goal of normalization is to minimize
Q22: In a small business,a department might be
Q23: A(n)_ is when a field depends on
Q24: When multiple fields are used to identify
Q25: Each employee can only be in the