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

Question

Quizplus · Accepted Answer

Update anomalies occur when an update to a table causes data loss or inconsistency in another table. In this case, if the ProductTypes table is updated, it could cause orders to be lost or become inconsistent. The foreign key constraint prevents this by ensuring that the ProductType field in the Orders table always references a valid entry in the ProductTypes table.

ProductType Is a Foreign Key Field in the Orders Table