a database question You are familier with the Premiere Products database and its

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)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.