notown=# CREATE TABLE alubms (title text, date date, format text, aid int, PRIMARY KEY (aid));

notown=# CREATE TABLE songs (title text, author text, PRIMARY KEY (title, author));

notown=# CREATE TABLE musicians (ssn int, name tex, address text, phone int, PRIMARY KEY(ssn));

notown=# CREATE TABLE instruments (name text, key text, PRIMARY KEY(name, key));