a database question. please help Your are familiar with the premiere products da
ID: 654151 • Letter: A
Question
a database question. please help
Your are familiar with the premiere products database and its set of 3NF relations.A Fictitious company, named ABC, uses a similar database design. As compared to premiere Products, the ABC 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, Rep Salary) 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
The 2 differences that we can find in the company policies of Firm ABC are
1.Commission rate for Representatives are given based on customer and rep details not by PAY_CLASS to which he belongs to.....
2.For firm ABC the Representative's salary is fixed.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.