Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement