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 2014 shows up in ORDER_ITEM 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 ORDER_ITEM.
To add a primary key constraint on the ProductD column in ORDER_ITEM.
To add a foreign key constraint on the ProductID column in ORDER_ITEM.
You have been asked to help maintain a database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!