Multiple Choice
ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?
A) creation anomalies
B) deletion anomalies
C) update anomalies
D) record locking
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q19: During which process do you typically create
Q20: Which of the following Access features provides
Q21: How does the Access Relationships window indicate
Q22: Which of the following Access features does
Q23: What shape does an E-R diagram use
Q25: Which of the following is a valid
Q26: A query creates a Cartesian join between
Q27: An E-R diagram uses diamonds to illustrate
Q28: When referential integrity is enforced on a
Q29: Which properties do you set to display