# This MySQL script creates a database table for lab sheet 7
# that is not even in first normal form

DROP TABLE IF EXISTS MP3;
CREATE TABLE MP3 (
    artist varchar(100),
	album varchar(100),
	tracks text,
	disk varchar(11),
	PRIMARY KEY(artist,album,disk)
);

INSERT INTO MP3 VALUES ('Instant Noise', 'Downright loud', 'Shut your ears (3:20), Sound out (2:44), Quiet as... well no (4:09)','Heavy');
INSERT INTO MP3 VALUES ('Deci Bells', 'CN U HEAR ME?', 'Deaf as a dodo (1:45), The Dog Ate My Ear Muffs (5:19), The Dog ate... - Remix (5:05), Hello? (2:34)','Heavy');
INSERT INTO MP3 VALUES ('Wolfgang Amadeus Gocart', 'Serenatas', 'Vrooom (5:11), Nobody does it later (3:49)','Groovy');
INSERT INTO MP3 VALUES ('HM Royal British Corgi Choir', 'Serenading the moon', 'Woooohoohoohoooooo! (4:52), Woof Waarrhh Woof Woof Wooooo..! (7:13), Shut up! Shut up! Now! ...wohoohohooo! (5:21)','Groovy');
INSERT INTO MP3 VALUES ('HM Royal British Corgi Choir', 'Serenading the moon', 'Woah! Wah! Woah! (1:20), Grrrrrr! [I like the look of your heels] (0:25)','Light');