Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ARTIST ( ArtistID , LastName, FirstName, Gender, YearofBirth, Address, PhoneNumber, Email, ArtistType ) INSTRUMENT ( InstrumentID , InstrumentName ) ArtistID references ARTIST ( ArtistID )
ARTISTArtistID LastName, FirstName, Gender, YearofBirth, Address, PhoneNumber,
Email, ArtistType
INSTRUMENTInstrumentID InstrumentName
ArtistID references ARTISTArtistID
ARTISTINSTRUMENTArtistID InstrumentID, PerformanceLevel
DEGREEDegreeID DegreeName, University
ARTISTDEGREEArtistID DegreeID, Year
ArtistID references ARTISTArtistID
DegreeID references DEGREEDegereeID
HONORHonorID HonorDescription
ARTISTHONORArtistID HonorID
ArtistID references ARTISTArtistID
HonorID references HONORHonorID
NEWSITEMNewsItemID Source, Content
ARTISTNEWSArtistID NewsItemID, Date
ArtistID references ARTISTArtistID
NewsItemID references NEWSITEMNewsItemID
CONTRACTEDARTISTArtistID AManagerID
ArtistID references ARTISTArtistID
AManagerID references ARTISTMANAGERAManagerID
SAMPLESampleID SampleContent, ArtistID
ArtistID references ARTISTArtistID
PROSPECTIVEARTISTArtistID
ArtistID references ARTISTArtistID
RECOMMENDATIONRecommendationID Summary, QualityEvaluation, Original,
ReceivedDate, CreatedDate, ArtistID, SourceID
ArtistID references PROSPECTIVEARTISTArtistID
SourceID references SOURCESourceID
SOURCESourceID Name, Type, Quality
ARTISTCOMMITMENTACommentmentID StartDate, StartTime, EndDate, EndTime,
ArtistID, CommitmentType
ArtistID references CONTRACTEDARTISTArtistID
PERSONALCACommitmentID Firmness
ACommitmentID references ARTCOMMITMENTACommitmentID
PERFORMANCERELATEDCACommitmentID Category, EventID
ACommitmentID references ARTCOMMITMENTACommitmentID
EventID references EVENTEventID
CONTRACTContractID StartDate, EndDate, RoyaltyPercentage, Terms, ArtistID
ArtistID references CONTRACTEDARTISTArtistID
EXPENSEExpenseID Description, Amount, AccountNbr, ExpenseType
ARTMGREXPENSEExpenseID AManagerID
ExpenseID references EXPENSEExpenseID
AManagerID references ARTISTMANAGERAManagerID
ARTISTEXPENSEExpenseID ArtistID
ExpenseID references EXPENSEExpenseID
ArtistID references CONTRACTEDARTISTArtistID
ARTISTMANAGERAManagerID LastName, FirstName
ADMINAdminID LastName, FirstName, AManagerID
AManagerID references ARTISTMANAGERAManagerID
ARTISTPAYMENTAPaymentID Date, Amount, AdminID, ArtistID
AdminID references ADMINAdminID
ArtistID references CONTRACTEDARTISTArtistID
VENUEVenueID Name, Address, Country
CUSTOMERCustomerID Name, Address
CUSTOMERPAYMENTCPaymentID Date, Amount, CustomerID
CustomerID references CUSTOMERCustomerID
EVENTEventID EventDescription, Date, Time, VenueID, CustomerID
VenueID references VENUEVenueID
CustomerID references CUSTOMERCustomerID
AGREEMENTAgreementNbr Date, GrossAmount, AtSourceTaxWithheld, Terms,
EventID, ContractID
EventID references EVENTEventID
ContractID references CONTRACTContractID
INVOICEInvoiceNbr Date, Total
INVOICEPAYMENTInvoiceNbr PaymentID, Amount
InvoiceNbr references INVOICEInvoiceNbr
PaymentID references CUSTOMERPAYMENTCPaymentIDAnalyze and document the functional dependencies in
Answers will depend on each students solution for
Discuss the use of enterprise keys.
If necessary, modify the EER diagram.
This is quite typical, and it is important for the students to realize that there is nothing
wrong about these types of discoveries, as long as they will be implemented to improve the
quality of the solution.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started