sub: database management

Question 2: Figue 2 shows a scrap of an EER model describing products and their distribution price code account-id contact Product stock Distributor description address cust-code has-part supplier-address weight Part supplier-eme Figure 2 Map the EER model to a relational schema without performing any normalisation. Clearly indicate all primary keys and foreign keys (also stating into which relations they are keys. ii. Given that suppliers have a unique name and exactly one address, say why the Part relation is not in Boyce-Codd normal form (BCNF) iii. Show how the Part relation can be decomposed into 2 relations that are both in BCNF iv. Show how the EER model could be modified to directly represent the normalised relations