Familiar Bits Database Concepts Textbook Set 3nf Relations Fictitious Company Named Abc Us Q37073258

1. You are familiar with the BITS database (from the Conceptstextbook) and its set of 3NF relations. A fictitious company, namedABC, uses a similar database design. As compared to BITS, the ABCdatabase uses the exact same structure for the Tasks, OrderLine,and Workorders tables. However, in place of the Consultant andClient tables (of the BITS database), the ABC Company uses thetable structures 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