ARTIST$($ArtistID$,$ LastName, FirstName, Gender, YearofBirth, Address, PhoneNumber,

Email, ArtistType$)$

INSTRUMENT$($InstrumentID$,$ InstrumentName$)$

ArtistID references ARTIST$($ArtistID$)$

ARTISTINSTRUMENT$($ArtistID$,$ InstrumentID, PerformanceLevel$)$

DEGREE$($DegreeID$,$ DegreeName, University$)$

ARTISTDEGREE$($ArtistID$,$ DegreeID, Year$)$

ArtistID references ARTIST$($ArtistID$)$

DegreeID references DEGREE$($DegereeID$)$

HONOR$($HonorID$,$ HonorDescription$)$

ARTISTHONOR$($ArtistID$,$ HonorID$)$

ArtistID references ARTIST$($ArtistID$)$

HonorID references HONOR$($HonorID$)$

NEWSITEM$($NewsItemID$,$ Source, Content$)$

ARTISTNEWS$($ArtistID$,$ NewsItemID, Date$)$

ArtistID references ARTIST$($ArtistID$)$

NewsItemID references NEWSITEM$($NewsItemID$)$

CONTRACTEDARTIST$($ArtistID$,$ AManagerID$)$

ArtistID references ARTIST$($ArtistID$)$

AManagerID references ARTISTMANAGER$($AManagerID$)$

SAMPLE$($SampleID$,$ SampleContent, ArtistID$)$

ArtistID references ARTIST$($ArtistID$)$

PROSPECTIVEARTIST$($ArtistID$)$

ArtistID references ARTIST$($ArtistID$)$

RECOMMENDATION$($RecommendationID$,$ Summary, QualityEvaluation, Original,

ReceivedDate, CreatedDate, ArtistID, SourceID$)$

ArtistID references PROSPECTIVEARTIST$($ArtistID$)$

SourceID references SOURCE$($SourceID$)$

SOURCE$($SourceID$,$ Name, Type, Quality$)$

ARTISTCOMMITMENT$($ACommentmentID$,$ StartDate, StartTime, EndDate, EndTime,

ArtistID, CommitmentType$)$

ArtistID references CONTRACTEDARTIST$($ArtistID$)$

PERSONALC$($ACommitmentID$,$ Firmness$)$

ACommitmentID references ARTCOMMITMENT$($ACommitmentID$)$

PERFORMANCERELATEDC$($ACommitmentID$,$ Category, EventID$)$

ACommitmentID references ARTCOMMITMENT$($ACommitmentID$)$

EventID references EVENT$($EventID$)$

CONTRACT$($ContractID$,$ StartDate, EndDate, RoyaltyPercentage, Terms, ArtistID$)$

ArtistID references CONTRACTEDARTIST$($ArtistID$)$

EXPENSE$($ExpenseID$,$ Description, Amount, AccountNbr, ExpenseType$)$

ARTMGREXPENSE$($ExpenseID$,$ AManagerID$)$

ExpenseID references EXPENSE$($ExpenseID$)$

AManagerID references ARTISTMANAGER$($AManagerID$)$

ARTISTEXPENSE$($ExpenseID$,$ ArtistID$)$

ExpenseID references EXPENSE$($ExpenseID$)$

ArtistID references CONTRACTEDARTIST$($ArtistID$)$

ARTISTMANAGER$($AManagerID$,$ LastName, FirstName$)$

ADMIN$($AdminID$,$ LastName, FirstName, AManagerID$)$

AManagerID references ARTISTMANAGER$($AManagerID$)$

ARTISTPAYMENT$($APaymentID$,$ Date, Amount, AdminID, ArtistID$)$

AdminID references ADMIN$($AdminID$)$

ArtistID references CONTRACTEDARTIST$($ArtistID$)$

VENUE$($VenueID$,$ Name, Address, Country$)$

CUSTOMER$($CustomerID$,$ Name, Address$)$

CUSTOMERPAYMENT$($CPaymentID$,$ Date, Amount, CustomerID$)$

CustomerID references CUSTOMER$($CustomerID$)$

EVENT$($EventID$,$ EventDescription, Date, Time, VenueID, CustomerID$)$

VenueID references VENUE$($VenueID$)$

CustomerID references CUSTOMER$($CustomerID$)$

AGREEMENT$($AgreementNbr$,$ Date, GrossAmount, AtSourceTaxWithheld, Terms,

EventID, ContractID$)$

EventID references EVENT$($EventID$)$

ContractID references CONTRACT$($ContractID$)$

INVOICE$($InvoiceNbr$,$ Date, Total$)$

INVOICEPAYMENT$($InvoiceNbr$,$ PaymentID, Amount$)$

InvoiceNbr references INVOICE$($InvoiceNbr$)$

PaymentID references CUSTOMERPAYMENT$($CPaymentID$)$Analyze and document the functional dependencies in $4-63.$

Answers will depend on each student$$s solution for $4-63.$

$4-65.$ Discuss the use of enterprise keys.

$4-66.$ 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.