|
-
Argg Stuck
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
-
 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
Have you ask your instructor for guidance?
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote