1. Based on the consecrated factsbase we can discover the underneath negotiative dependencies:
- CustName CustPhsingle i.e CustPhsingle is negotiatively trusting on CustName. A CustIndicate can uniquely realize a CustPhone
- ArtistId ArtistIndicate i.e DeceitistIndicate is negotiatively trusting on DeceitistId. No 2 opposed deceitists indicate can possess the selfselfidentical deceitist id.
- 1 DeceitistId can possess multiple DeceitTitle
- 1 Deceitist can verification multiple DeceitMedium
- 1 Customer can suborn multiple Deceit
Based on the over instruction, we can possess underneath boards:
- Customer board with attainments CustIndicate & CustPhone
- Proficient board with attainments DeceitistId , DeceitistName, DeceitTitle & DeceitMedium
- BuysAndSales board with attainments CustName, DeceitistId ,SaleDate & SalePrice
2. We conceive that DeceitTitle and DeceitMedium are multivalued attainments, since an deceitist can result opposed DeceitTitle and with opposed DeceitMedium. So we separate DeceitTitle and DeceitMedium into opposed board since 1NF disallows multivaled attainments. Lets allure this board as DeceitDetail containing DeceitistId as the alien explanation to Deceitist board and DeceitTitle and DeceitMedium the other attainments. We conceive the alliance of DeceitistId,ArtTitle and DeceitMedium identifies the degree uniquely, accordingly they are pdeceit of the explanation.
In SubornsAndSale board, we conceive that SaleDate and SalePrice is not attribuconsideration attribuconsideration attribuconsideration trusting on alliance of CustIndicate and DeceitistId barring is trusting on alliance of CustName,ArtistId, DeceitTilte and DeceitMedium. So by 2NF which doesn’t suffer any disuniteial dependency. We insufficiency to verification the original explanation of DeceitDetail board in SubornsAndSale board.
Final inventory of boards and attainments are:
ArtDetail( ArtistId, DeceitTitle, DeceitMedium ) –
BuysAndSale(ArtistId, DeceitTitle, DeceitMedium ,CustName,SaleDate,SalePrice)