Question: You have been asked to help maintain a database where you work. The DBA has approached you with a report that shows some mismatches. For
You have been asked to help maintain a database where you work. The DBA has approached you with a report that shows some mismatches. For instance in the PRODUCT table, the ProductID shows up in ORDERITEM but does not show up in PRODUCT. The DBA has fixed this particular error but wants a more permanent solution. What would be your suggestion?
To add a foreign key constraint on the ProductID column in PRODUCT.
To add a unique constraint on the ProductID column in ORDERITEM.
To add a primary key constraint on the ProductD column in ORDERITEM.
To add a foreign key constraint on the ProductID column in ORDERITEM.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
