EXPENSE NEWS ITEM ARTIST RECOMMENDATION SOURCE Description Amount Account Expens

Question

EXPENSE NEWS ITEM ARTIST RECOMMENDATION SOURCE Description Amount Account Expense Type rtist ID Last Name First Name Gender Artist Type Name Type Quality Source Content Summary Quality Evaluation Original Received Date Created Date PROSPECTIVE ARTIST CONTRACTED ARTIST ART MGR EXPENSE ARTIST EXPENSE (Samples) ARTIST COMMITMENT mitment Start Date Start Time End Date End Time Commitment Type ARTIST MANAGER CONTRACT Last Name First Name ARTIST PAYMENT Start Date End Date Royalty percentage Terms PERSONAL Firmness PERFORMANCE RELATED CategoryY AP Date Amount AGREEMENT ADMIN Admin ID Last Name First Name reement Nbr Date Gross Amount At Source Tax Withheld Terms EVENT Event ID Event Descri ption Date Time VENUE CUSTOMER PAYMENT enue ID Name Address Country INVOICE CUSTOMER Customer ID Name Address Date Total Date Amount Draw

Explanation / Answer

The Relational Schema as follows :-

EXPENSE (Expense_ID, Description, Amount, Account, Expense_Type)

Expense_ID-Primary Key

NEWSITEM (NewsItem_ID, Source, Content)

NewsItem_ID- Primary Key

ARTIST (Artist_ID, LastName, FirstName, Gender, ArtistType)

Artist_ID- Primary Key

RECOMMENDATION (Recommendation ID, Summary, QualityEvaluation, Original, Received Date, CreatedDate)

Recommendation_ID- Primary Key

SOURCE (Source_ID, Name, Type, Quality)

Source_ID- Primary Key

ARTISTMANAGER (AManager_ID, LastName, FirstName)

AManager_ID- Primary Key

ARTISTPAYMENT (APayment_ID, Date, Amount)

APayment_ID- Primary Key

CONTRACT (Contract ID, StartDate, EndDate, RoyalityPercentage, Terms)

Contract_ID- Primary Key

PERSONAL (Firmness)

ARTISTCOMMITMENT (ACommitmentID, StartDate, StartTime, EndDate, EndTime, CommitmentType)

ACommitmentID- Primary Key

PERFORMANCERELATED (Category)

ADMIN (Admin_ID, Lastname, Firstname)

Admin_ID- Primary Key

AGREEMENT (Agreement_Nbr, Date, GrossAmount, AtSourceTaxWithheld, Terms)

Agreement_Nbr- Primary Key

EVENT (Event_ID, EventDescription, Date, Time)

Event_ID- Primary Key

INVOICE (Invoice_Nbr, Date, Total)

Invoice_Nbr- Primary Key

CUSTOMERPAYMENT (CPayment_ID, Date, Amount)

CPayment_ID- Primary Key

CUSTOMER (Customer_ID, Name, Address)

Customer_ID- Primary Key

VENUE (Venue_ID, Name, Address, Country)

Venue_ID- Primary Key

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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