Data Managment

In a complete relational data table, a foreign key A of table 1 is supposed to use values from a key column in another table (such as key B of table 2, for example). In the Excel-8-Practice file, the Table OrderDetails have 2 foreign keys: (1) OrderID that refers to the ID column of table Order, and (2) ProductID that refers to the ID column of the table Product. In Table OrderDetails, go through all rows from top to bottom. Identify the foreign-key errors with some of the rows in this table, and explain the problem. (up to 5 lines) Answer: Q5. (2.5 pts) This question extends on Q4. One method to resolve the issues with the rows described in OrderDetails is to delete the foreignkey-error rows. In your own words, explain 1 advantage and 1 disadvantage of this method. (us to 5 lines)