CREATE TABLE cds(
    id INTEGER PRIMARY KEY NOT NULL,
    title TEXT NOT NULL
);
CREATE TABLE artists(
    id INTEGER PRIMARY KEY NOT NULL,
    name TEXT NOT NULL
);
CREATE TABLE cds_and_artists(
    cds_id INTEGER,
    artists_id INTEGER,
    FOREIGN KEY(cds_id) REFERENCES cds(id) ON DELETE CASCADE,
    FOREIGN KEY(artists_id) REFERENCES artists(id) ON DELETE CASCADE
);
CREATE INDEX cdsindex ON cds_and_artists(cds_id);
CREATE INDEX artistsindex ON cds_and_artists(artists_id);