
chemistry content. If so, the missing value from row 3 would have been chemistry.
There is no way of deducing from the table that the missing value was in fact
biology.
Questions
1. The table SupplierPart (supplierNo, partNo) is subject to the enterprise rules:
(a) a supplier may supply many parts;
(b) a part may be supplied by many suppliers;
(c) every supplier must supply parts P1 and P2.
Explain why SupplierPart will contain redundant data. Suggest a table structure which
avoids redundancy. (3 min)
2. The table Supply (supplierNo, partNo, projectNo) shows which suppliers supply
which parts to which projects. State an enterprise rule such that Supply ...