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);