lab 2 databases

CREATE TABLE CD_RecordLabel (
  labelname VARCHAR(30) PRIMARY KEY,
  webpage VARCHAR(60),
  house CHAR(6),
  street VARCHAR(50),
  postcode CHAR(8),
  country VARCHAR(30),
  email VARCHAR(50),
  town VARCHAR(25)
);

CREATE TABLE CD_Artist (
  idNumber INT PRIMARY KEY AUTO_INCREMENT,
  artistName VARCHAR(20),
  bio VARCHAR(140),
  email VARCHAR(50),
  webpage VARCHAR(50),
  dateOfBirth DATE
);

CREATE TABLE CD_CD (
  catalogNo INT PRIMARY KEY,
  title VARCHAR(20) NOT NULL,
  publicationDate DATE,
  releasedBy VARCHAR(30) NOT NULL,
  original INT,
  isFrontedBy INT,
  FOREIGN KEY (releasedBy) REFERENCES CD_RecordLabel(labelName),
  FOREIGN KEY (original) REFERENCES CD_CD(catalogNo),
  FOREIGN KEY (isFrontedBy) REFERENCES CD_Artist(idNumber)
);

CREATE TABLE CD_Genre (
  genre VARCHAR(25) NOT NULL,
  catalogNo INT NOT NULL,
  PRIMARY KEY (genre, catalogNo),
  FOREIGN KEY (catalogNo) REFERENCES CD_CD(catalogNo) ON DELETE CASCADE
);

CREATE TABLE CD_Track (
  trackNo INT AUTO_INCREMENT,
  cdNo INT NOT NULL,
  trackTitle VARCHAR(25) NOT NULL,
  PRIMARY KEY (trackNo, cdNo),
  FOREIGN KEY (cdNo) REFERENCES CD_CD(catalogNo)
);

CREATE TABLE CD_Performs (
  artistId INT NOT NULL,
  trackNo INT NOT NULL,
  cdNo INT NOT NULL,
  PRIMARY KEY (artistId, trackNo, cdNo),
  FOREIGN KEY (artistId) REFERENCES CD_Artist(idNumber),
  FOREIGN KEY (trackNo, cdNo) REFERENCES CD_Track(trackNo, cdNo)
);