<filename>Music Database Final/Milestone-3-Adding-Data/more records.sql

USE Music;

--ALBUMS--
--INSERT INTO Albums VALUES(6, 1, 'Rubber Soul', 'Vinyl', 6, 'December 3, 1965', 1);
--INSERT INTO Albums VALUES(7, 2, 'Wish You Were Here', 'Vinyl', 8, 'September 12, 1975', 2);
--INSERT INTO Albums VALUES(8, 12, 'Turn Blue', 'CD', 1, 'May 12, 2014', 3);
--INSERT INTO Albums VALUES(9, 17, '2001 (The Chronic)', 'CD', 3, 'November 16, 1999', 7);
--INSERT INTO Albums VALUES(10, 13, 'Maginfiuqe', 'MP3', 13, 'July 17, 2015', 6);


----ARTISTS--
--INSERT INTO Artists VALUES(17, 'Dr. Dre');
--INSERT INTO Artists VALUES(13, 'Ratatat');


----RECORD LABEL--
--INSERT INTO [Record Label] VALUES(6, 'Because Music', 'Paris', 'France');
--INSERT INTO [Record Label] VALUES(7, 'Aftermath', 'Santa Monica', 'USA');

--TRACKS--
--INSERT INTO Track VALUES(1, 6, 'BlackBird', 2, '2:19');
--INSERT INTO Track VALUES(1, 7, 'Dear Prudence', 2, '3:56');

--INSERT INTO Track VALUES(2, 9, 'The Great Gig in the Sky', 8, '4:15');
--INSERT INTO Track VALUES(2, 10, 'Money', 8, '6:30');

--INSERT INTO Track VALUES(3, 11, 'Everlasting Light', 5, '3:24');
--INSERT INTO Track VALUES(3, 12, 'Tighten Up', 5, '3:31');

--INSERT INTO Track VALUES(4, 13, 'Graduation Day', 3, '1:22');
--INSERT INTO Track VALUES(4, 14, 'Never Let Me Down', 3, '5:24');

--INSERT INTO Track VALUES(5, 15, 'Face to Face', 4, '3:58');
--INSERT INTO Track VALUES(5, 16, 'Voyager', 4, '3:47');

--INSERT INTO Track VALUES(6, 17, 'In My Life', 6, '2:24');
--INSERT INTO Track VALUES(6, 18, 'Nowhere Man', 6, '2:40');


--INSERT INTO Track VALUES(8, 21, 'Weight of Love', 13, '6:50');
--INSERT INTO Track VALUES(8, 22, 'In Our Prime', 13, '4:38');

--INSERT INTO Track VALUES(9, 23, 'The Next Episode', 3, '2:41');
--INSERT INTO Track VALUES(9, 24, 'Forgot About Dre', 3, '3:42');

--INSERT INTO Track VALUES(10, 25, 'Cream on Chrome', 2, '4:15');
--INSERT INTO Track VALUES(10, 26, 'Countach', 2, '2:32');

--INSERT INTO Track VALUES(7, 19, 'Have a Cigar', 8, '5:24');
--INSERT INTO Track VALUES(7, 20, 'Shine On You Crazy Diamond', 8, '13:32');

