Familiar Bits Database Chapter 1 Concepts Set 3nf Relations Fictitious Company Named Abc U Q37134326

You are familiar with the BITS database (chapter 1 in Concepts)and its set of 3NF relations. A fictitious company, named ABC, usesa similar database design. As compared to BITS, the ABC databaseuses the exact same structure for the Tasks, OrderLine, andWorkorders tables. However, in place of the Consultant and Clienttables (of the BITS database), the ABC Company uses the tablestructures below:   

ABCConsultant (ConsultNum, ConsultLName,ConsultFName, ConsultStreet, ConsultCity, ConsultState, ConsultZip,ConsultSalary)

ABCClient (CltNum, CltName, CltStreet, CltCity,CltState, CltZip, CltBalance, CltCreditlimit)

ABCConsultantClient (ConsultNum, CltNum,CommissionRate)

For Firm ABC, each of the above relations is in 3NF. What 2differences must exist in the company policies of Firm ABC ascompared to

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.