Create the Relational Schema for the following EER diagram. Notice that you need

Question

Create the Relational Schema for the following EER diagram. Notice that you need to make a clear notation that includes: name of Relation, Attributes, Primary and Foreign keys, Nullable and Non-nullable attributes. Do not use Oracle sql developer! EXPENSE NEWS ITEM ARTIST RECOMMENDATION SOURCE Description Last Name First Name NewsIt Source Content Recomm endati Summary Quality Evaluation Original Received Date Created Date Is about Name ??? Artist Type ty Provides ense T PROSPECTIVE ARTIST CONTRACTED Is about ARTIST ART MGR EXPENSE ARTIST EXPENSE Samplest ARTIST COMMITMENT Has Is responsible ACommitmeant ID Start Date Start Time End Date End Time Commitment Type Is responsible or ARTIST MANAGER Is responsible CONTRACT AManager I Last Name rac ARTIST PAYMENT Start Date End Date Royalty percentage PERFORMANCE RELATED Category First Name PERSONAL Firmness Belongs to erms Date Amount Works for AGREEMENT ADMIN Causes EVENT Date Gross Amount At Source Tax Withheld Takes place at Last Name First Name Creates eates Covers a performance at Event Description Date erms Covers VENUE Is based CUSTOMER PAYMENT en Name Address INVOICE on CUSTOMER Customer I ?? ?? Date Total Makes Name Organizes Date ess

Explanation / Answer

Give me comment, if you have any doubts...

EXPENSE(ExpenseID:int, Description:string, Amount:real, Account:string, ExpenseType string);

ART_MGR_EXPENSE(ExpenseID int);

ARTIST_EXPENSE(ExpenseID int, ArtistID int);

ARTIST(ArtistID int, LastName string, FirstName string, Gender string, ArtistType string);

PROSPECTIVE_ARTIST(ArtistID int);

CONTRACTED_ARTIST(ArtistID int, AManagerID int);

NEWS_ITEM(NewsItemID int, Source string, Content string);

ARTIST_MANAGER(AManagerID int, LastName string, FirstName string, ArtistID int);

INVOICE(InvoiceNbr int, Date date, Total real, AdminID int);

ARTIST_PAYMENT(APaymentID int, Date date, Amount real, ArtistID int);

AGREEMENT(AgreementNbr int, Date date, GrossAmount real, Tax real, Terms string);

INV_BASED_AGRMT(InvoiceNbr int, AgreementNbr int);

CUSTOMER(CustomerID int, Name string, Address string);

CUSTOMER_PAYMENT(CPyamentID int, Date date, Amount real, CustomerID int);

INV_COVERS_CUST_PAY(CPyamentID int, InvoiceNbr int);

CONTRACT(ContractID int, StartDate date, EndDate date, RoyaltyPerc real, Terms text,  ArtistID int);

EVENT(EventID int, EventDesc string, Date date, Time time, CustomerID int);

ARTIST_COMMITMENT( ACommitmentID int, StartDate date, StartTime time, EndDate date, EndTime time,
CommitmentType string);

PERSONAL(ACommitmentID int, Firmness string);

PERFORMANCE_RELATED(ACommitmentID int, Category string, EventID int);

SOURCE(SouceID int, Name string, Type string, Quality int);

RECOMMENDATION(RecommendationID int, Summary text, QualityEvaluation int, Original string, ReceivedDate date, CreatedDate date, SourceID int);

REC_ABOUT_PROSP_ART(RecommendationID int, ArtistID int);

VENUE(VenueID int, Name string, Address string, Country string);

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.