{"artist": {"columns": [[0, "Artist_ID", "INT", 0, null, 1], [1, "Artist", "TEXT", 0, null, 0], [2, "Age", "INT", 0, null, 0], [3, "Famous_Title", "TEXT", 0, null, 0], [4, "Famous_Release_date", "TEXT", 0, null, 0]], "primary_keys": ["Artist_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Artist_ID"]]], "check_constraints": []}, "volume": {"columns": [[0, "Volume_ID", "INT", 0, null, 1], [1, "Volume_Issue", "TEXT", 0, null, 0], [2, "Issue_Date", "TEXT", 0, null, 0], [3, "Weeks_on_Top", "REAL", 0, null, 0], [4, "Song", "TEXT", 0, null, 0], [5, "Artist_ID", "INT", 0, null, 0]], "primary_keys": ["Volume_ID"], "foreign_keys": [[0, 0, "artist", "Artist_ID", "Artist_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Volume_ID"]]], "check_constraints": []}, "music_festival": {"columns": [[0, "ID", "INT", 0, null, 1], [1, "Music_Festival", "TEXT", 0, null, 0], [2, "Date_of_ceremony", "TEXT", 0, null, 0], [3, "Category", "TEXT", 0, null, 0], [4, "Volume", "INT", 0, null, 0], [5, "Result", "TEXT", 0, null, 0]], "primary_keys": ["ID"], "foreign_keys": [[0, 0, "volume", "Volume", "Volume_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "ID"]]], "check_constraints": []}}
CREATE TABLE artist (
    Artist_ID INT   PRIMARY KEY,
    Artist TEXT,
    Age INT,
    Famous_Title TEXT,
    Famous_Release_date TEXT,
    UNIQUE (Artist_ID)
);

CREATE TABLE volume (
    Volume_ID INT   PRIMARY KEY,
    Volume_Issue TEXT,
    Issue_Date TEXT,
    Weeks_on_Top REAL,
    Song TEXT,
    Artist_ID INT,
    UNIQUE (Volume_ID),
    FOREIGN KEY (Artist_ID) REFERENCES artist(Artist_ID)
);

CREATE TABLE music_festival (
    ID INT   PRIMARY KEY,
    Music_Festival TEXT,
    Date_of_ceremony TEXT,
    Category TEXT,
    Volume INT,
    Result TEXT,
    UNIQUE (ID),
    FOREIGN KEY (Volume) REFERENCES volume(Volume_ID)
);