SET table_type=INNODB;
CREATE TABLE label (
lbltitle VARCHAR(15),
lblstreet VARCHAR(25),
lblcity VARCHAR(20),
lblstate VARCHAR(20),
lblpostcode VARCHAR(10),
lblnation VARCHAR(20),
	PRIMARY KEY (lbltitle));
	
CREATE TABLE cd (
cdid INTEGER,
cdlblid VARCHAR(10),
cdtitle VARCHAR(25),
cdyear YEAR,
lbltitle VARCHAR(15),
	PRIMARY KEY (cdid),
	FOREIGN KEY (lbltitle) REFERENCES label(lbltitle));
	
CREATE TABLE track (
trkid INTEGER,
trknum INTEGER NOT NULL,
trktitle VARCHAR(25) NOT NULL,
trklength DECIMAL(4,2) NOT NULL,
cdid INTEGER,
	PRIMARY KEY(trkid),
	FOREIGN KEY (cdid) REFERENCES cd(cdid));
	

INSERT INTO label VALUES ('Atlantic', '75 Rockefeller Plaza','New York', 'NY','10019', 'USA');
INSERT INTO cd VALUES (1, 'A2 1311','Giant Steps', 1960,'Atlantic');
INSERT INTO cd VALUES (2, '83012-2','Swing', 1977,'Atlantic');
INSERT INTO track VALUES (1, 1, 'Giant steps', 4.72,1);
INSERT INTO track VALUES (2, 2, 'Cousin Mary', 5.75,1);
INSERT INTO track VALUES (3, 3, 'Countdown', 2.35,1);
INSERT INTO track VALUES (4, 4, 'Spiral', 5.93,1);
INSERT INTO track VALUES (5, 5, 'Syeeda''s song flute', 7,1);
INSERT INTO track VALUES (6, 6, 'Naima', 4.35,1);
INSERT INTO track VALUES (7, 7, 'Mr. P.C.', 6.95,1);
INSERT INTO track VALUES (8, 8, 1, 3.67,1);
INSERT INTO track VALUES (9, 9, 'Naima', 4.45,1);
INSERT INTO track VALUES (10, 10, 'Cousin Mary', 5.9,1);
INSERT INTO track VALUES (11, 11, 'Countdown', 4.55,1);
INSERT INTO track VALUES (12, 12, 'Syeeda''s song flute', 7.03,1);
INSERT INTO track VALUES (13, 1, 'Stomp of King Porter', 3.2,2);
INSERT INTO track VALUES (14, 2, 'Sing a Study in Brown', 2.85,2);
INSERT INTO track VALUES (15, 3, 'Sing Moten''s Swing', 3.6,2);
INSERT INTO track VALUES (16, 4, 'A-tisket, A-tasket', 2.95,2);
INSERT INTO track VALUES (17, 5, 'I Know Why', 3.57,2);
INSERT INTO track VALUES (18, 6, 'Sing You Sinners', 2.75,2);
INSERT INTO track VALUES (19, 7, 'Java Jive', 2.85,2);
INSERT INTO track VALUES (20, 8, 'Down South Camp Meetin''', 3.25,2);
INSERT INTO track VALUES (21, 9, 'Topsy', 3.23,2);
INSERT INTO track VALUES (22, 10, 'Clouds', 7.2,2);
INSERT INTO track VALUES (23, 11, 'Skyliner', 3.18,2);
INSERT INTO track VALUES (24, 12, 'It''s Good Enough to Keep', 3.18,2);
INSERT INTO track VALUES (25, 13, 'Choo Choo Ch'' Boogie', 3,2);