You are familiar with premiere products database and its


You are familiar with Premiere Products database and its set of 3NF relations. A similar company, firm ABC, uses the following set of relations in their database in place of the SLSREP and CUSTOMER tables. (The ORDERS, ORDLNE, and PART tables are the same for both firms.)

ABCSLSREP (SLSRNUMB, SLSRLASTNAME, SLSRFIRSTNAME, SLSRSTREET, SLSRCITY, SLSRSTATE, SLSRZIP, SLSRRATE)
ABCCUSTOMER (CUSTNUMB, CUSTNAME, STREE, CITY, STATE, ZIP, BALANCE, CREDITLIMIT)
ABCSLSCUST (SLSRNUMB, CUSTNUMB, COMMRATE)

For Firm ABC, each of the above relations is in 3NF. What 2 differences must exist in the company policies of Firm ABC? Explain your answer.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: You are familiar with premiere products database and its
Reference No:- TGS0143926

Expected delivery within 24 Hours