1CREATE TABLE artist ( 2 artistid INTEGER PRIMARY KEY, 3 name TEXT NOT NULL 4); 5 6CREATE TABLE cd ( 7 cdid INTEGER PRIMARY KEY, 8 artist INTEGER NOT NULL REFERENCES artist(artistid), 9 title TEXT NOT NULL 10); 11 12CREATE TABLE track ( 13 trackid INTEGER PRIMARY KEY, 14 cd INTEGER NOT NULL REFERENCES cd(cdid), 15 title TEXT NOT NULL 16);