1. Based on the ardent factsbase we can confront the under authoritative dependencies:
- CustName CustPhindividual i.e CustPhindividual is authoritatively subject on CustName. A CustSpectry can uniquely test a CustPhone
- ArtistId ArtistSpectry i.e CallingistSpectry is authoritatively subject on CallingistId. No 2 unanalogous callingists spectry can enjoy the similar callingist id.
- 1 CallingistId can enjoy multiple CallingTitle
- 1 Callingist can verification multiple CallingMedium
- 1 Customer can bribe multiple Calling
Based on the aloft counsel, we can enjoy under considerations:
- Customer consideration with characteristics CustSpectry & CustPhone
- Proficient consideration with characteristics CallingistId , CallingistName, CallingTitle & CallingMedium
- BuysAndSales consideration with characteristics CustName, CallingistId ,SaleDate & SalePrice
2. We descry that CallingTitle and CallingMedium are multivalued characteristics, gone an callingist can result unanalogous CallingTitle and with unanalogous CallingMedium. So we separate CallingTitle and CallingMedium into unanalogous consideration gone 1NF disallows multivaled characteristics. Lets call this consideration as CallingDetail containing CallingistId as the exotic clew to Callingist consideration and CallingTitle and CallingMedium the other characteristics. We descry the union of CallingistId,ArtTitle and CallingMedium identifies the order uniquely, consequently they are pcalling of the clew.
In BribesAndSale consideration, we descry that SaleDate and SalePrice is referable subject on union of CustSpectry and CallingistId except is subject on union of CustName,ArtistId, CallingTilte and CallingMedium. So by 2NF which doesn’t apportion any allotial dependency. We insufficiency to verification the pristine clew of CallingDetail consideration in BribesAndSale consideration.
Final inventory of considerations and characteristics are:
ArtDetail( ArtistId, CallingTitle, CallingMedium ) –
BuysAndSale(ArtistId, CallingTitle, CallingMedium ,CustName,SaleDate,SalePrice)