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

Give me a comment, If you get an error...

CREATE TABLE EXPENSE(
    ExpernseID INTEGER NOT NULL PRIMARY KEY,
    Description VARCHAR(255),
    Amount REAL,
    Account VARCHAR(10),
    ExpenseType VARCHAR(10)
);

CREATE TABLE ART_MGR_EXPENSE(
    ExpenseID INTEGER NOT NULL PRIMARY KEY,
    FOREIGN KEY(ExpenseID) REFERENCES EXPENSE(ExpenseID)
);

CREATE TABLE ARTIST_EXPENSE(
    ExpenseID INTEGER NOT NULL PRIMARY KEY,
    ArtistID INTEGER,
    FOREIGN KEY(ExpenseID) REFERENCES EXPENSE(ExpenseID),
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(AritstID),
);

CREATE TABLE ARTIST(
    ArtistID INTEGER NOT NULL PRIMARY KEY,
    LastName VARCHAR(255),
    FirstName VARCHAR(255),
    Gender ENUM('M', 'F'),
    ArtistType VARCHAR(10)
);

CREATE TABLE PROSPECTIVE_ARTIST(
    ArtistID INTEGER NOT NULL PRIMARY KEY,
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(ArtistID)
);

CREATE TABLE CONTRACTED_ARTIST(
    ArtistID INTEGER NOT NULL PRIMARY KEY,
    AManagerID INTEGER,
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(ArtistID),
    FOREIGN KEY(AManagerID) REFERENCES ARTIST(AManagerID)
);

CREATE TABLE NEWS_ITEM(
    NewsItemID INTEGER NOT NULL PRIMARY KEY,
    Source VARCHAR(50),
    Content TEXT
);

CREATE TABLE ARTIST_MANAGER(
    AManagerID INTEGER NOT NULL PRIMARY KEY,
    LastName VARCHAR(255),
    FirstName VARCHAR(255),
    ArtistID INTEGER,
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(ArtistID)
);

CREATE TABLE INVOICE(
    InvoiceNbr INTEGER NOT NULL PRIMARY KEY,
    Date DATE,
    Total REAL,
    AdminID INTEGER
    FOREIGN KEY(AdminID) REFERENCES ADMIN(AdminID)
);

CREATE TABLE ARTIST_PAYMENT(
    APaymentID INTEGER NOT NULL PRIMARY KEY,
    Date DATE,
    Amount REAL,
    ArtistID INTEGER,
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(ArtistID)
    FOREIGN KEY(AdminID) REFERENCES ADMIN(AdminID)
);

CREATE TABLE AGREEMENT(
    AgreementNbr INTEGER NOT NULL PRIMARY KEY,
    Date DATE,
    GrossAmount REAL,
    Tax REAL,
    Terms TEXT
);

CREATE TABLE INV_BASED_AGRMT(
    InvoiceNbr INTEGER NOT NULL PRIMARY KEY,
    AgreementNbr INTEGER NOT NULL PRIMARY KEY,
    PRIMARY KEY(InvoiceNbr, AgreementNbr)
    FOREIGN KEY(InvoiceNbr) REFERENCES INVOICE(InvoiceNbr),
    FOREIGN KEY(AgreementNbr) REFERENCES INVOICE(AgreementNbr),
);

CREATE TABLE CUSTOMER(
    CustomerID INTEGER NOT NULL PRIMARY KEY,
    Name VARCHAR(255),
    Address VARCHAR(255)
);

CREATE TABLE CUSTOMER_PAYMENT(
    CPyamentID INTEGER NOT NULL PRIMARY KEY,
    Date DATE,
    Amount REAL,
    CustomerID INTEGER,
    FOREIGN KEY(CustomerID) REFERENCES CUSTOMER(CustomerID)
);

CREATE TABLE INV_COVERS_CUST_PAY(
    CPyamentID INTEGER,
    InvoiceNbr INTEGER,
    PRIMARY KEY(CPyamentID, InvoiceNbr),
    FOREIGN KEY(InvoiceNbr) REFERENCES INVOICE(InvoiceNbr),
    FOREIGN KEY(CPyamentID) REFERENCES CUSTOMER_PAYMENT(CPyamentID)
);

CREATE TABLE CONTRACT(
    ContractID int NOT NULL PRIMARY KEY,
    StartDate DATE,
    EndDate DATE,
    RoyaltyPerc REAL,
    Terms TEXT,
    ArtistID INTEGER,
    FOREIGN KEY(ArtistID) REFERENCES ARTIST(ArtistID)
);

CREATE TABLE EVENT(
    EventID INTEGER NOT NULL PRIMARY KEY,
    EventDesc VARCHAR(255),
    `Date` DATE,
    `Time` TIME,
    CustomerID INTEGER,
    FOREIGN KEY(CustomerID) REFERENCES CUSTOMER(CustomerID)
);

CREATE TABLE ARTIST_COMMITMENT(
    ACommitmentID int NOT NULL PRIMARY KEY,
    StartDate DATE,
    StartTime TIME,
    EndDate DATE,
    EndTime TIME,
    CommitmentType VARCHAR(10)
);

CREATE TABLE PERSONAL(
    ACommitmentID int NOT NULL PRIMARY KEY,
    Firmness VARCHAR(50),
    FOREIGN KEY(ACommitmentID) REFERENCES ARTIST_COMMITMENT(ACommitmentID)
);

CREATE TABLE PERFORMANCE_RELATED(
    ACommitmentID int NOT NULL PRIMARY KEY,
    Category VARCHAR(50),
    EventID INTEGER,
    FOREIGN KEY(ACommitmentID) REFERENCES ARTIST_COMMITMENT(ACommitmentID),
    FOREIGN KEY(EventID) REFERENCES ARTIST_COMMITMENT(EventID)
);

CREATE TABLE SOURCE(
    SouceID INTEGER NOT NULL PRIMARY KEY,
    Name VARCHAR(255),
    Type VARCHAR(10),
    Quality INTEGER
);

CREATE TABLE RECOMMENDATION(
    RecommendationID INTEGER NOT NULL PRIMARY KEY,
    Summary TEXT,
    QualityEvaluation INTEGER,
    Original VARCHAR(50),
    ReceivedDate DATE,
    CreatedDate DATE,
    SourceID INTEGER,
    FOREIGN KEY(SourceID) REFERENCES SOURCE(SourceID)
);

CREATE TABLE REC_ABOUT_PROSP_ART(
    RecommendationID INT,
    ArtistID INT,
    PRIMARY KEY(RecommendationID, ArtistID),
    FOREIGN KEY(RecommendatioID) REFERENCES ARTIST(ArtistID),
    FOREIGN KEY(ArtistID) REFERENCES PROSPECTIVE_ARTIST(ArtistID)
);

CREATE TABLE VENUE(
    VenueID INTEGER NOT NULL PRIMARY KEY,
    Name VARCHAR(255),
    Address VARCHAR(255),
    Country VARCHAR(100)
);

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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