a database question You are familier with the Premiere Products database and its
ID: 654412 • Letter: A
Question
a database question
You are familier with the Premiere Products database and its set of 3NF relations. A fictitious company, named ABC, uses a similar database design. As compared to database uses the exact same structure for the Orders, OrderLine, and Part tables. However, in place of the Rep and Customer tables (in the Premiere Products database), the ABC Company uses the table structures below : ABCRep (RepNum, RepLName, RepFName, RepStreet, RepCity, RepState, RepZip, RepSalary ABCCustomer (CustNum, CustName, CustStreet, CustCity, CustState, CustZip. CustBalance, CustCreditlimit) ABCRepCust (RepNum, CustName, CommissionRate) For Firm ABC, each of the above relations is in 3NF. What 2 differences must exist in the company policies of Firm ABC as compared to Premiere Products? Explain your answer.Explanation / Answer
Following are the two changes that are to made
1. ABCCustomer table should have ReNum column
2. Tere must be a table ABCOrder(OrderDate, CustNum)