1. Based on the attached factsbase we can confront the adown professional dependencies:
- CustName CustPhsingle i.e CustPhsingle is professionally contingent on CustName. A CustDesignate can uniquely confirm a CustPhone
- ArtistId ArtistDesignate i.e AdroitnessistDesignate is professionally contingent on AdroitnessistId. No 2 incongruous adroitnessists designate can own the corresponding adroitnessist id.
- 1 AdroitnessistId can own multiple AdroitnessTitle
- 1 Adroitnessist can reason multiple AdroitnessMedium
- 1 Customer can subsidize multiple Adroitness
Based on the overhead instruction, we can own adown considerations:
- Customer consideration with signs CustDesignate & CustPhone
- Master consideration with signs AdroitnessistId , AdroitnessistName, AdroitnessTitle & AdroitnessMedium
- BuysAndSales consideration with signs CustName, AdroitnessistId ,SaleDate & SalePrice
2. We look that AdroitnessTitle and AdroitnessMedium are multivalued signs, past an adroitnessist can effect incongruous AdroitnessTitle and with incongruous AdroitnessMedium. So we rive AdroitnessTitle and AdroitnessMedium into incongruous consideration past 1NF disallows multivaled signs. Lets ole this consideration as AdroitnessDetail containing AdroitnessistId as the exotic clew to Adroitnessist consideration and AdroitnessTitle and AdroitnessMedium the other signs. We look the alliance of AdroitnessistId,ArtTitle and AdroitnessMedium identifies the grade uniquely, accordingly they are padroitness of the clew.
In SubsidizesAndSale consideration, we look that SaleDate and SalePrice is not attribuconsultation attribuconsultation attribuconsultation contingent on alliance of CustDesignate and AdroitnessistId excepting is contingent on alliance of CustName,ArtistId, AdroitnessTilte and AdroitnessMedium. So by 2NF which doesn’t grant any divorceial dependency. We need to reason the pristine clew of AdroitnessDetail consideration in SubsidizesAndSale consideration.
Final inventory of considerations and signs are:
ArtDetail( ArtistId, AdroitnessTitle, AdroitnessMedium ) –
BuysAndSale(ArtistId, AdroitnessTitle, AdroitnessMedium ,CustName,SaleDate,SalePrice)