Originally Posted by
saggy32
Example: Premiere Products database is set as 3NF relations. If 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, SLSRCOMM)
ABCCUSTOMER (CUSTNUMB, CUSTNAME, STREET….etc)
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? ANYONE? Im so lost..Thank you
