Paste this to create or re-create the database tables.
-- MediaCollection Sample Database
-- Introduction to Database Systems Modeling and Administration
-- James M. Reneau Ph.D.
-- Version 2025-02-08
-- C) J.M.Reneau Ph.D. - All Rights Reserved
-- Create Database Tables Script
DROP TABLE IF EXISTS album_track;
DROP TABLE IF EXISTS song;
DROP TABLE IF EXISTS movie;
DROP TABLE IF EXISTS album;
DROP TABLE IF EXISTS artist;
DROP TABLE IF EXISTS studio;
CREATE TABLE artist (artist_id INTEGER primary key,
name VARCHAR(40));
CREATE TABLE studio (studio_id INTEGER primary key,
name VARCHAR(40));
CREATE TABLE album (album_id INTEGER primary key,
album_title VARCHAR(40),
year INTEGER,
artist_id INTEGER,
cost DECIMAL(14,2),
purchased_datetime DATETIME,
sold_datetime DATETIME,
price DECIMAL(14,2),
FOREIGN KEY (artist_id) REFERENCES artist(artist_id)
);
CREATE TABLE movie (movie_id INTEGER primary key,
title VARCHAR(40),
year INTEGER,
director_id INTEGER,
studio_id INTEGER,
sec_length INTEGER,
cost DECIMAL(14,2),
purchased_datetime DATETIME,
sold_datetime DATETIME,
price DECIMAL(14,2),
FOREIGN KEY (director_id) REFERENCES artist(artist_id),
FOREIGN KEY (studio_id) REFERENCES studio(studio_id)
);
CREATE TABLE song (song_id INTEGER primary key,
song_title VARCHAR(40),
artist_id INTEGER,
sec_length INTEGER,
FOREIGN KEY (artist_id) REFERENCES artist(artist_id)
);
CREATE TABLE album_track (album_id INTEGER,
track INTEGER,
song_id INTEGER,
PRIMARY KEY (album_id, track),
FOREIGN KEY (song_id) REFERENCES song(song_id)
);
Paste this to insert the data and build the balances.
-- MediaCollection Sample Database
-- Introduction to Database Systems Modeling and Administration
-- James M. Reneau Ph.D.
-- Version 2025-02-08
-- C) J.M.Reneau Ph.D. - All Rights Reserved
-- Insert Sample Data and Update Script
INSERT INTO artist VALUES (1,'Motley Grunge');
INSERT INTO artist VALUES (2,'Queen Ant');
INSERT INTO artist VALUES (3,'Roach to Men');
INSERT INTO artist VALUES (4,'Taylor Slow');
INSERT INTO artist VALUES (5,'George Wiggly');
INSERT INTO artist VALUES (6,'Madison Tuckered');
INSERT INTO artist VALUES (7,'Purple Frog');
INSERT INTO artist VALUES (8,'Hazy Daisy');
INSERT INTO artist VALUES (9,'Frankie Ford Cooper');
INSERT INTO artist VALUES (10,'Stanberg Cubic');
INSERT INTO artist VALUES (999,'Various');
INSERT INTO studio VALUES (1,'Dreamplay');
INSERT INTO studio VALUES (2,'23 Century Rodent');
INSERT INTO studio VALUES (3,'Disgruntled Artists');
INSERT INTO movie VALUES (1, '21 Days After', 2000, 4, 1,5440, NULL, NULL, NULL, NULL);
INSERT INTO movie VALUES (2, 'Fools Gold Rush', 2020, 10, 2, 5770 ,NULL, NULL, NULL, NULL);
INSERT INTO movie VALUES (3, 'Eyes Glued Open', 2020, 10, 2, 6330 ,NULL, NULL, NULL, NULL);
INSERT INTO movie VALUES (4, 'The Bearable Lightness of Being', 2024, 9, 3,4007 ,NULL, NULL, NULL, NULL);
INSERT INTO movie VALUES (5, 'Error Concert Tour Highlights', 2025, 4, 1,3548 ,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (1, 'Motley as it Gets', 2000, 1,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (2, 'Motley and More', 2002, 1,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (3, 'Can''t Get More Motley', 2004, 1,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (4, 'Echoes of Stardust', 2020, 2,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (5, 'Midnight Mirage', 2021, 2,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (6, 'Neon Dreamscape', 2020, 3,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (7, 'Sapphire Serenade', 2021, 3,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (8, 'Whispering Willow', 2022, 3,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (9, 'Labyrinth of Echoes', 2024, 3,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (10, 'Solar Symphony', 1970, 4,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (11, 'Velvet Twilight', 1974, 4,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (12, 'Nebula Reverie',1976, 4,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (13, 'Crimson Cascade', 1982, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (14, 'Ephemeral Odyssey', 1984, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (15, 'Lunar Lullaby', 1987, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (16, 'Mystic Mirage', 2000, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (17, 'Celestial Canvas', 1981, 4,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (18, 'Silent Solstice', 2001, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (19, 'Enigma’s Embrace', 2003, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (20, 'Galactic Groove', 2020, 5,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (21, 'Astral Alchemy', 1977, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (22, 'Sonic Sanctuary', 1977, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (23, 'Dreamweaver’s Delight', 1978, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (24, 'Harmony Horizon', 1979, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (25, 'Stardust Serenade', 1980, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (26, 'Whispers in the Void', 1983, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (27, 'Best Of', 2010, 1,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (28, 'Greatest Hits', 2020, 4,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (29, 'Greatest Hits', 1982, 7,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (31, 'Greatest Hits of the Century', 2000, 999,NULL, NULL, NULL, NULL);
INSERT INTO album VALUES (32, 'Prime Cuts', 2024, 999,NULL, NULL, NULL, NULL);
INSERT INTO song VALUES (1,'Whispers in the Moonlight', 5, NULL);
INSERT INTO song VALUES (10,'Solar Symphony', 1, NULL);
INSERT INTO song VALUES (100,'Celestial Canvas', 4, NULL);
INSERT INTO song VALUES (101,'Whispers in the Twilight', 5, NULL);
INSERT INTO song VALUES (102,'Nebula Nocturne', 5, NULL);
INSERT INTO song VALUES (103,'Sapphire Serenade', 4, NULL);
INSERT INTO song VALUES (104,'Luminous Lullaby', 7, NULL);
INSERT INTO song VALUES (105,'Galactic Groove', 5, NULL);
INSERT INTO song VALUES (106,'Labyrinth of Echoes', 4, NULL);
INSERT INTO song VALUES (107,'Stellar Serenity', 5, NULL);
INSERT INTO song VALUES (108,'Ethereal Echo', 4, NULL);
INSERT INTO song VALUES (109,'Crimson Crescendo', 1, NULL);
INSERT INTO song VALUES (11,'Nebula Nocturne', 5, NULL);
INSERT INTO song VALUES (110,'Solar Sonata', 5, NULL);
INSERT INTO song VALUES (111,'Harmonic Haven', 4, NULL);
INSERT INTO song VALUES (112,'Mystic Melodies', 5, NULL);
INSERT INTO song VALUES (113,'Whispering Willow', 2, NULL);
INSERT INTO song VALUES (114,'Nebulous Nocturne', 3, NULL);
INSERT INTO song VALUES (115,'Sapphire Skies', 1, NULL);
INSERT INTO song VALUES (116,'Lunar Lyric', 1, NULL);
INSERT INTO song VALUES (117,'Velvet Voyage', 5, NULL);
INSERT INTO song VALUES (118,'Astral Aria', 2, NULL);
INSERT INTO song VALUES (119,'Cosmic Canticle', 1, NULL);
INSERT INTO song VALUES (12,'Sapphire Shores', 1, NULL);
INSERT INTO song VALUES (120,'Enigma’s Em', 4, NULL);
INSERT INTO song VALUES (121,'Pushing Up - Demo', 8, NULL);
INSERT INTO song VALUES (122,'Bunch of Buds - Demo', 8, NULL);
INSERT INTO song VALUES (123,'Spring Fresh - Single', 8, NULL);
INSERT INTO song VALUES (13,'Astral Alchemy', 7, NULL);
INSERT INTO song VALUES (14,'Mystic Melodies', 5, NULL);
INSERT INTO song VALUES (15,'Labyrinth of Whispers', 5, NULL);
INSERT INTO song VALUES (16,'Celestial Canvas', 5, NULL);
INSERT INTO song VALUES (17,'Harmony Horizon', 7, NULL);
INSERT INTO song VALUES (18,'Enigma’s Embrace', 5, NULL);
INSERT INTO song VALUES (19,'Dreamweaver’s Delight', 4, NULL);
INSERT INTO song VALUES (2,'Neon Dreams', 4, NULL);
INSERT INTO song VALUES (20,'Silent Solstice', 4, NULL);
INSERT INTO song VALUES (21,'Cosmic Carousel', 5, NULL);
INSERT INTO song VALUES (22,'Velvet Vortex', 1, NULL);
INSERT INTO song VALUES (23,'Lunar Lullaby', 3, NULL);
INSERT INTO song VALUES (24,'Sapphire Serenade', 4, NULL);
INSERT INTO song VALUES (25,'Nebulous Notes', 5, NULL);
INSERT INTO song VALUES (26,'Echoes of Stardust', 1, NULL);
INSERT INTO song VALUES (27,'Whispering Willow', 1, NULL);
INSERT INTO song VALUES (28,'Cerulean Constellation', 4, NULL);
INSERT INTO song VALUES (29,'Ethereal Echo', 7, NULL);
INSERT INTO song VALUES (3,'Stardust Serenade', 5, NULL);
INSERT INTO song VALUES (30,'Mystical Melancholy', 2, NULL);
INSERT INTO song VALUES (31,'Harbor of Echoes', 4, NULL);
INSERT INTO song VALUES (32,'Sonic Sanctuary', 5, NULL);
INSERT INTO song VALUES (33,'Twilight Tango', 4, NULL);
INSERT INTO song VALUES (34,'Lullaby for Nebulas', 4, NULL);
INSERT INTO song VALUES (35,'Galaxy’s Edge', 7, NULL);
INSERT INTO song VALUES (36,'Serenade of Shadows', 5, NULL);
INSERT INTO song VALUES (37,'Starlit Secrets', 3, NULL);
INSERT INTO song VALUES (38,'Enchanted Echoes', 3, NULL);
INSERT INTO song VALUES (39,'Moonrise Melodies', 5, NULL);
INSERT INTO song VALUES (4,'Midnight Mirage', 7, NULL);
INSERT INTO song VALUES (40,'Whispers in the Void', 1, NULL);
INSERT INTO song VALUES (41,'Nostalgic Nebula', 1, NULL);
INSERT INTO song VALUES (42,'Sapphire Skies', 7, NULL);
INSERT INTO song VALUES (43,'Luminous Lullaby', 5, NULL);
INSERT INTO song VALUES (44,'Velvet Veil', 4, NULL);
INSERT INTO song VALUES (45,'Celestial Waltz', 5, NULL);
INSERT INTO song VALUES (46,'Mystic Moonbeam', 7, NULL);
INSERT INTO song VALUES (47,'Ephemeral Elegy', 7, NULL);
INSERT INTO song VALUES (48,'Solar Serenade', 7, NULL);
INSERT INTO song VALUES (49,'Harmonic Horizon', 3, NULL);
INSERT INTO song VALUES (5,'Ephemeral Echoes', 7, NULL);
INSERT INTO song VALUES (50,'Midnight Muse', 4, NULL);
INSERT INTO song VALUES (51,'Nebula Nocturne', 5, NULL);
INSERT INTO song VALUES (52,'Sonic Stardust', 1, NULL);
INSERT INTO song VALUES (53,'Labyrinth of Dreams', 4, NULL);
INSERT INTO song VALUES (54,'Crimson Crescendo', 5, NULL);
INSERT INTO song VALUES (55,'Stellar Serenity', 7, NULL);
INSERT INTO song VALUES (56,'Whispered Wonders', 7, NULL);
INSERT INTO song VALUES (57,'Galactic Groove', 3, NULL);
INSERT INTO song VALUES (58,'Lunar Lullaby', 5, NULL);
INSERT INTO song VALUES (59,'Sapphire Sonata', 3, NULL);
INSERT INTO song VALUES (6,'Velvet Twilight', 5, NULL);
INSERT INTO song VALUES (60,'Nebulous Nocturne', 5, NULL);
INSERT INTO song VALUES (61,'Ethereal Embrace', 4, NULL);
INSERT INTO song VALUES (62,'Cosmic Canticle', 5, NULL);
INSERT INTO song VALUES (63,'Velvet Voyage', 7, NULL);
INSERT INTO song VALUES (64,'Astral Aria', 5, NULL);
INSERT INTO song VALUES (65,'Mystical Mirage', 7, NULL);
INSERT INTO song VALUES (66,'Harmony Haven', 7, NULL);
INSERT INTO song VALUES (67,'Enigma’s Echo', 5, NULL);
INSERT INTO song VALUES (68,'Dreamweaver’s Dance', 3, NULL);
INSERT INTO song VALUES (69,'Silent Soliloquy', 4, NULL);
INSERT INTO song VALUES (7,'Galactic Groove', 4, NULL);
INSERT INTO song VALUES (70,'Celestial Cadence', 2, NULL);
INSERT INTO song VALUES (71,'Whispers in the Starlight', 4, NULL);
INSERT INTO song VALUES (72,'Nebula Nostalgia', 3, NULL);
INSERT INTO song VALUES (73,'Sapphire Seas', 7, NULL);
INSERT INTO song VALUES (74,'Luminous Lyric', 7, NULL);
INSERT INTO song VALUES (75,'Velvet Visions', 2, NULL);
INSERT INTO song VALUES (76,'Cerulean Chorus', 1, NULL);
INSERT INTO song VALUES (77,'Ethereal Enchantment', 7, NULL);
INSERT INTO song VALUES (78,'Galaxy’s Grace', 3, NULL);
INSERT INTO song VALUES (79,'Mystic Melancholy', 3, NULL);
INSERT INTO song VALUES (8,'Luminous Reverie', 7, NULL);
INSERT INTO song VALUES (80,'Labyrinth of Light', 4, NULL);
INSERT INTO song VALUES (81,'Solar Serenade', 7, NULL);
INSERT INTO song VALUES (82,'Harmonic Harmony', 5, NULL);
INSERT INTO song VALUES (83,'Midnight Melodies', 5, NULL);
INSERT INTO song VALUES (84,'Nebula Nocturne', 3, NULL);
INSERT INTO song VALUES (85,'Sonic Synchrony', 4, NULL);
INSERT INTO song VALUES (86,'Stardust Serenade', 4, NULL);
INSERT INTO song VALUES (87,'Whispered Whims', 1, NULL);
INSERT INTO song VALUES (88,'Lunar Lullaby', 4, NULL);
INSERT INTO song VALUES (89,'Sapphire Symphony', 7, NULL);
INSERT INTO song VALUES (9,'Crimson Cascade', 7, NULL);
INSERT INTO song VALUES (90,'Nebulous Notes', 3, NULL);
INSERT INTO song VALUES (91,'Ephemeral Echo', 7, NULL);
INSERT INTO song VALUES (92,'Cosmic Crescendo', 5, NULL);
INSERT INTO song VALUES (93,'Velvet Vortex', 1, NULL);
INSERT INTO song VALUES (94,'Astral Anthem', 2, NULL);
INSERT INTO song VALUES (95,'Mystical Moonrise', 5, NULL);
INSERT INTO song VALUES (96,'Harmony Horizon', 5, NULL);
INSERT INTO song VALUES (97,'Enigma’s Embrace', 7, NULL);
INSERT INTO song VALUES (98,'Dreamweaver’s Delight', 5, NULL);
INSERT INTO song VALUES (99,'Silent Solstice', 3, NULL);
UPDATE song SET sec_length = 236 WHERE song_id = 1 ;
UPDATE song SET sec_length = 242 WHERE song_id = 2 ;
UPDATE song SET sec_length = 306 WHERE song_id = 3 ;
UPDATE song SET sec_length = 246 WHERE song_id = 4 ;
UPDATE song SET sec_length = 243 WHERE song_id = 5 ;
UPDATE song SET sec_length = 309 WHERE song_id = 6 ;
UPDATE song SET sec_length = 182 WHERE song_id = 7 ;
UPDATE song SET sec_length = 319 WHERE song_id = 8 ;
UPDATE song SET sec_length = 212 WHERE song_id = 9 ;
UPDATE song SET sec_length = 321 WHERE song_id = 10 ;
UPDATE song SET sec_length = 148 WHERE song_id = 11 ;
UPDATE song SET sec_length = 378 WHERE song_id = 12 ;
UPDATE song SET sec_length = 209 WHERE song_id = 13 ;
UPDATE song SET sec_length = 249 WHERE song_id = 14 ;
UPDATE song SET sec_length = 292 WHERE song_id = 15 ;
UPDATE song SET sec_length = 311 WHERE song_id = 16 ;
UPDATE song SET sec_length = 140 WHERE song_id = 17 ;
UPDATE song SET sec_length = 248 WHERE song_id = 18 ;
UPDATE song SET sec_length = 219 WHERE song_id = 19 ;
UPDATE song SET sec_length = 292 WHERE song_id = 20 ;
UPDATE song SET sec_length = 245 WHERE song_id = 21 ;
UPDATE song SET sec_length = 277 WHERE song_id = 22 ;
UPDATE song SET sec_length = 304 WHERE song_id = 23 ;
UPDATE song SET sec_length = 179 WHERE song_id = 24 ;
UPDATE song SET sec_length = 302 WHERE song_id = 25 ;
UPDATE song SET sec_length = 187 WHERE song_id = 26 ;
UPDATE song SET sec_length = 306 WHERE song_id = 27 ;
UPDATE song SET sec_length = 254 WHERE song_id = 28 ;
UPDATE song SET sec_length = 303 WHERE song_id = 29 ;
UPDATE song SET sec_length = 294 WHERE song_id = 30 ;
UPDATE song SET sec_length = 320 WHERE song_id = 31 ;
UPDATE song SET sec_length = 285 WHERE song_id = 32 ;
UPDATE song SET sec_length = 363 WHERE song_id = 33 ;
UPDATE song SET sec_length = 203 WHERE song_id = 34 ;
UPDATE song SET sec_length = 260 WHERE song_id = 35 ;
UPDATE song SET sec_length = 262 WHERE song_id = 36 ;
UPDATE song SET sec_length = 343 WHERE song_id = 37 ;
UPDATE song SET sec_length = 272 WHERE song_id = 38 ;
UPDATE song SET sec_length = 339 WHERE song_id = 39 ;
UPDATE song SET sec_length = 315 WHERE song_id = 40 ;
UPDATE song SET sec_length = 273 WHERE song_id = 41 ;
UPDATE song SET sec_length = 336 WHERE song_id = 42 ;
UPDATE song SET sec_length = 239 WHERE song_id = 43 ;
UPDATE song SET sec_length = 409 WHERE song_id = 44 ;
UPDATE song SET sec_length = 262 WHERE song_id = 45 ;
UPDATE song SET sec_length = 331 WHERE song_id = 46 ;
UPDATE song SET sec_length = 257 WHERE song_id = 47 ;
UPDATE song SET sec_length = 217 WHERE song_id = 48 ;
UPDATE song SET sec_length = 342 WHERE song_id = 49 ;
UPDATE song SET sec_length = 301 WHERE song_id = 50 ;
UPDATE song SET sec_length = 290 WHERE song_id = 51 ;
UPDATE song SET sec_length = 128 WHERE song_id = 52 ;
UPDATE song SET sec_length = 309 WHERE song_id = 53 ;
UPDATE song SET sec_length = 171 WHERE song_id = 54 ;
UPDATE song SET sec_length = 181 WHERE song_id = 55 ;
UPDATE song SET sec_length = 425 WHERE song_id = 56 ;
UPDATE song SET sec_length = 152 WHERE song_id = 57 ;
UPDATE song SET sec_length = 274 WHERE song_id = 58 ;
UPDATE song SET sec_length = 266 WHERE song_id = 59 ;
UPDATE song SET sec_length = 173 WHERE song_id = 60 ;
UPDATE song SET sec_length = 310 WHERE song_id = 61 ;
UPDATE song SET sec_length = 411 WHERE song_id = 62 ;
UPDATE song SET sec_length = 210 WHERE song_id = 63 ;
UPDATE song SET sec_length = 273 WHERE song_id = 64 ;
UPDATE song SET sec_length = 319 WHERE song_id = 65 ;
UPDATE song SET sec_length = 311 WHERE song_id = 66 ;
UPDATE song SET sec_length = 299 WHERE song_id = 67 ;
UPDATE song SET sec_length = 242 WHERE song_id = 68 ;
UPDATE song SET sec_length = 185 WHERE song_id = 69 ;
UPDATE song SET sec_length = 156 WHERE song_id = 70 ;
UPDATE song SET sec_length = 339 WHERE song_id = 71 ;
UPDATE song SET sec_length = 345 WHERE song_id = 72 ;
UPDATE song SET sec_length = 258 WHERE song_id = 73 ;
UPDATE song SET sec_length = 177 WHERE song_id = 74 ;
UPDATE song SET sec_length = 301 WHERE song_id = 75 ;
UPDATE song SET sec_length = 243 WHERE song_id = 76 ;
UPDATE song SET sec_length = 430 WHERE song_id = 77 ;
UPDATE song SET sec_length = 252 WHERE song_id = 78 ;
UPDATE song SET sec_length = 276 WHERE song_id = 79 ;
UPDATE song SET sec_length = 198 WHERE song_id = 80 ;
UPDATE song SET sec_length = 310 WHERE song_id = 81 ;
UPDATE song SET sec_length = 338 WHERE song_id = 82 ;
UPDATE song SET sec_length = 330 WHERE song_id = 83 ;
UPDATE song SET sec_length = 308 WHERE song_id = 84 ;
UPDATE song SET sec_length = 202 WHERE song_id = 85 ;
UPDATE song SET sec_length = 354 WHERE song_id = 86 ;
UPDATE song SET sec_length = 231 WHERE song_id = 87 ;
UPDATE song SET sec_length = 303 WHERE song_id = 88 ;
UPDATE song SET sec_length = 279 WHERE song_id = 89 ;
UPDATE song SET sec_length = 315 WHERE song_id = 90 ;
UPDATE song SET sec_length = 338 WHERE song_id = 91 ;
UPDATE song SET sec_length = 246 WHERE song_id = 92 ;
UPDATE song SET sec_length = 231 WHERE song_id = 93 ;
UPDATE song SET sec_length = 273 WHERE song_id = 94 ;
UPDATE song SET sec_length = 213 WHERE song_id = 95 ;
UPDATE song SET sec_length = 256 WHERE song_id = 96 ;
UPDATE song SET sec_length = 292 WHERE song_id = 97 ;
UPDATE song SET sec_length = 338 WHERE song_id = 98 ;
UPDATE song SET sec_length = 307 WHERE song_id = 99 ;
UPDATE song SET sec_length = 257 WHERE song_id = 100 ;
UPDATE song SET sec_length = 230 WHERE song_id = 101 ;
UPDATE song SET sec_length = 296 WHERE song_id = 102 ;
UPDATE song SET sec_length = 288 WHERE song_id = 103 ;
UPDATE song SET sec_length = 264 WHERE song_id = 104 ;
UPDATE song SET sec_length = 148 WHERE song_id = 105 ;
UPDATE song SET sec_length = 284 WHERE song_id = 106 ;
UPDATE song SET sec_length = 194 WHERE song_id = 107 ;
UPDATE song SET sec_length = 146 WHERE song_id = 108 ;
UPDATE song SET sec_length = 294 WHERE song_id = 109 ;
UPDATE song SET sec_length = 287 WHERE song_id = 110 ;
UPDATE song SET sec_length = 249 WHERE song_id = 111 ;
UPDATE song SET sec_length = 209 WHERE song_id = 112 ;
UPDATE song SET sec_length = 225 WHERE song_id = 113 ;
UPDATE song SET sec_length = 286 WHERE song_id = 114 ;
UPDATE song SET sec_length = 94 WHERE song_id = 115 ;
UPDATE song SET sec_length = 226 WHERE song_id = 116 ;
UPDATE song SET sec_length = 251 WHERE song_id = 117 ;
UPDATE song SET sec_length = 404 WHERE song_id = 118 ;
UPDATE song SET sec_length = 222 WHERE song_id = 119 ;
UPDATE song SET sec_length = 284 WHERE song_id = 120 ;
UPDATE song SET sec_length = 217 WHERE song_id = 121 ;
UPDATE song SET sec_length = 246 WHERE song_id = 122 ;
UPDATE song SET sec_length = 158 WHERE song_id = 123 ;
INSERT INTO album_track VALUES (1,1,115);
INSERT INTO album_track VALUES (1,2,116);
INSERT INTO album_track VALUES (10,1,24);
INSERT INTO album_track VALUES (10,2,31);
INSERT INTO album_track VALUES (10,3,53);
INSERT INTO album_track VALUES (10,4,88);
INSERT INTO album_track VALUES (10,5,100);
INSERT INTO album_track VALUES (10,6,103);
INSERT INTO album_track VALUES (10,7,120);
INSERT INTO album_track VALUES (11,1,2);
INSERT INTO album_track VALUES (11,2,69);
INSERT INTO album_track VALUES (11,3,108);
INSERT INTO album_track VALUES (11,4,111);
INSERT INTO album_track VALUES (12,1,28);
INSERT INTO album_track VALUES (12,2,33);
INSERT INTO album_track VALUES (12,3,34);
INSERT INTO album_track VALUES (12,4,44);
INSERT INTO album_track VALUES (12,5,50);
INSERT INTO album_track VALUES (12,6,71);
INSERT INTO album_track VALUES (13,1,21);
INSERT INTO album_track VALUES (13,2,32);
INSERT INTO album_track VALUES (13,3,39);
INSERT INTO album_track VALUES (14,1,25);
INSERT INTO album_track VALUES (14,2,51);
INSERT INTO album_track VALUES (14,3,67);
INSERT INTO album_track VALUES (14,4,101);
INSERT INTO album_track VALUES (15,1,3);
INSERT INTO album_track VALUES (15,2,36);
INSERT INTO album_track VALUES (15,3,54);
INSERT INTO album_track VALUES (15,4,92);
INSERT INTO album_track VALUES (15,5,96);
INSERT INTO album_track VALUES (15,6,98);
INSERT INTO album_track VALUES (15,7,117);
INSERT INTO album_track VALUES (16,1,6);
INSERT INTO album_track VALUES (16,2,15);
INSERT INTO album_track VALUES (16,3,16);
INSERT INTO album_track VALUES (16,4,105);
INSERT INTO album_track VALUES (17,1,7);
INSERT INTO album_track VALUES (17,2,19);
INSERT INTO album_track VALUES (17,3,20);
INSERT INTO album_track VALUES (17,4,61);
INSERT INTO album_track VALUES (17,5,80);
INSERT INTO album_track VALUES (17,6,85);
INSERT INTO album_track VALUES (17,7,86);
INSERT INTO album_track VALUES (17,8,106);
INSERT INTO album_track VALUES (18,1,1);
INSERT INTO album_track VALUES (18,2,11);
INSERT INTO album_track VALUES (18,3,45);
INSERT INTO album_track VALUES (18,4,95);
INSERT INTO album_track VALUES (19,1,14);
INSERT INTO album_track VALUES (19,2,18);
INSERT INTO album_track VALUES (19,3,64);
INSERT INTO album_track VALUES (19,4,82);
INSERT INTO album_track VALUES (2,1,22);
INSERT INTO album_track VALUES (2,2,40);
INSERT INTO album_track VALUES (2,3,52);
INSERT INTO album_track VALUES (2,4,87);
INSERT INTO album_track VALUES (2,5,93);
INSERT INTO album_track VALUES (2,6,119);
INSERT INTO album_track VALUES (20,1,43);
INSERT INTO album_track VALUES (20,2,58);
INSERT INTO album_track VALUES (20,3,60);
INSERT INTO album_track VALUES (20,4,62);
INSERT INTO album_track VALUES (20,5,83);
INSERT INTO album_track VALUES (20,6,102);
INSERT INTO album_track VALUES (20,7,107);
INSERT INTO album_track VALUES (21,1,4);
INSERT INTO album_track VALUES (21,2,5);
INSERT INTO album_track VALUES (21,3,8);
INSERT INTO album_track VALUES (21,4,17);
INSERT INTO album_track VALUES (21,5,35);
INSERT INTO album_track VALUES (21,6,48);
INSERT INTO album_track VALUES (21,7,77);
INSERT INTO album_track VALUES (21,8,81);
INSERT INTO album_track VALUES (21,9,104);
INSERT INTO album_track VALUES (22,1,63);
INSERT INTO album_track VALUES (23,1,42);
INSERT INTO album_track VALUES (23,2,46);
INSERT INTO album_track VALUES (23,3,55);
INSERT INTO album_track VALUES (23,4,65);
INSERT INTO album_track VALUES (23,5,97);
INSERT INTO album_track VALUES (24,1,47);
INSERT INTO album_track VALUES (24,2,89);
INSERT INTO album_track VALUES (25,1,13);
INSERT INTO album_track VALUES (25,2,56);
INSERT INTO album_track VALUES (25,3,66);
INSERT INTO album_track VALUES (25,4,73);
INSERT INTO album_track VALUES (25,5,74);
INSERT INTO album_track VALUES (26,1,9);
INSERT INTO album_track VALUES (26,2,29);
INSERT INTO album_track VALUES (26,3,91);
INSERT INTO album_track VALUES (27,1,26);
INSERT INTO album_track VALUES (27,2,76);
INSERT INTO album_track VALUES (27,3,115);
INSERT INTO album_track VALUES (27,4,116);
INSERT INTO album_track VALUES (27,5,119);
INSERT INTO album_track VALUES (28,1,7);
INSERT INTO album_track VALUES (28,2,31);
INSERT INTO album_track VALUES (28,3,34);
INSERT INTO album_track VALUES (28,4,53);
INSERT INTO album_track VALUES (28,5,69);
INSERT INTO album_track VALUES (28,6,71);
INSERT INTO album_track VALUES (28,7,86);
INSERT INTO album_track VALUES (28,8,106);
INSERT INTO album_track VALUES (28,9,108);
INSERT INTO album_track VALUES (29,1,5);
INSERT INTO album_track VALUES (29,2,9);
INSERT INTO album_track VALUES (29,3,46);
INSERT INTO album_track VALUES (29,4,47);
INSERT INTO album_track VALUES (29,5,56);
INSERT INTO album_track VALUES (29,6,81);
INSERT INTO album_track VALUES (29,7,91);
INSERT INTO album_track VALUES (3,1,10);
INSERT INTO album_track VALUES (3,2,12);
INSERT INTO album_track VALUES (3,3,26);
INSERT INTO album_track VALUES (3,4,27);
INSERT INTO album_track VALUES (3,5,41);
INSERT INTO album_track VALUES (3,6,76);
INSERT INTO album_track VALUES (3,7,109);
INSERT INTO album_track VALUES (31,1,120);
INSERT INTO album_track VALUES (31,2,20);
INSERT INTO album_track VALUES (31,3,40);
INSERT INTO album_track VALUES (31,4,60);
INSERT INTO album_track VALUES (31,5,100);
INSERT INTO album_track VALUES (31,6,101);
INSERT INTO album_track VALUES (31,7,115);
INSERT INTO album_track VALUES (32,1,1);
INSERT INTO album_track VALUES (32,2,2);
INSERT INTO album_track VALUES (32,3,3);
INSERT INTO album_track VALUES (32,4,5);
INSERT INTO album_track VALUES (32,5,7);
INSERT INTO album_track VALUES (32,6,11);
INSERT INTO album_track VALUES (32,7,13);
INSERT INTO album_track VALUES (32,8,17);
INSERT INTO album_track VALUES (32,9,19);
INSERT INTO album_track VALUES (4,1,30);
INSERT INTO album_track VALUES (4,2,94);
INSERT INTO album_track VALUES (4,3,113);
INSERT INTO album_track VALUES (5,1,70);
INSERT INTO album_track VALUES (5,2,75);
INSERT INTO album_track VALUES (5,3,118);
INSERT INTO album_track VALUES (6,1,57);
INSERT INTO album_track VALUES (6,2,68);
INSERT INTO album_track VALUES (6,3,72);
INSERT INTO album_track VALUES (6,4,99);
INSERT INTO album_track VALUES (6,5,114);
INSERT INTO album_track VALUES (7,1,23);
INSERT INTO album_track VALUES (7,2,59);
INSERT INTO album_track VALUES (7,3,78);
INSERT INTO album_track VALUES (7,4,84);
INSERT INTO album_track VALUES (8,1,37);
INSERT INTO album_track VALUES (8,2,49);
INSERT INTO album_track VALUES (9,1,38);
INSERT INTO album_track VALUES (9,2,79);
INSERT INTO album_track VALUES (9,3,90);
UPDATE album SET cost = 12.16 WHERE album_id = 1 ;
UPDATE album SET purchased_datetime = '2008-02-03' WHERE album_id = 1 ;
UPDATE album SET cost = 12.69 WHERE album_id = 2 ;
UPDATE album SET purchased_datetime = '2024-08-12' WHERE album_id = 2 ;
UPDATE album SET cost = 16.06 WHERE album_id = 3 ;
UPDATE album SET purchased_datetime = '2014-08-23' WHERE album_id = 3 ;
UPDATE album SET cost = 12.17 WHERE album_id = 4 ;
UPDATE album SET purchased_datetime = '2013-05-29' WHERE album_id = 4 ;
UPDATE album SET cost = 11.45 WHERE album_id = 5 ;
UPDATE album SET purchased_datetime = '2022-09-03' WHERE album_id = 5 ;
UPDATE album SET cost = 11.65 WHERE album_id = 6 ;
UPDATE album SET purchased_datetime = '2000-03-19' WHERE album_id = 6 ;
UPDATE album SET cost = 16.87 WHERE album_id = 7 ;
UPDATE album SET purchased_datetime = '2017-02-12' WHERE album_id = 7 ;
UPDATE album SET cost = 11.1 WHERE album_id = 8 ;
UPDATE album SET purchased_datetime = '2013-04-17' WHERE album_id = 8 ;
UPDATE album SET cost = 17.59 WHERE album_id = 9 ;
UPDATE album SET purchased_datetime = '2019-10-11' WHERE album_id = 9 ;
UPDATE album SET cost = 16.55 WHERE album_id = 10 ;
UPDATE album SET purchased_datetime = '2000-12-06' WHERE album_id = 10 ;
UPDATE album SET sold_datetime = '2023-06-30' WHERE album_id = 10 ;
UPDATE album SET price = 23.79 WHERE album_id = 10 ;
UPDATE album SET cost = 11.52 WHERE album_id = 11 ;
UPDATE album SET purchased_datetime = '2000-07-22' WHERE album_id = 11 ;
UPDATE album SET cost = 13.75 WHERE album_id = 12 ;
UPDATE album SET purchased_datetime = '2009-01-15' WHERE album_id = 12 ;
UPDATE album SET cost = 14.19 WHERE album_id = 13 ;
UPDATE album SET purchased_datetime = '2024-10-13' WHERE album_id = 13 ;
UPDATE album SET cost = 15.97 WHERE album_id = 14 ;
UPDATE album SET purchased_datetime = '2019-01-25' WHERE album_id = 14 ;
UPDATE album SET cost = 13.34 WHERE album_id = 15 ;
UPDATE album SET purchased_datetime = '2004-11-24' WHERE album_id = 15 ;
UPDATE album SET cost = 11.38 WHERE album_id = 16 ;
UPDATE album SET purchased_datetime = '2015-10-25' WHERE album_id = 16 ;
UPDATE album SET cost = 13.2 WHERE album_id = 17 ;
UPDATE album SET purchased_datetime = '2017-05-01' WHERE album_id = 17 ;
UPDATE album SET cost = 12.65 WHERE album_id = 18 ;
UPDATE album SET purchased_datetime = '2006-05-31' WHERE album_id = 18 ;
UPDATE album SET cost = 14.02 WHERE album_id = 19 ;
UPDATE album SET purchased_datetime = '2019-04-23' WHERE album_id = 19 ;
UPDATE album SET cost = 9.46 WHERE album_id = 20 ;
UPDATE album SET purchased_datetime = '2000-02-11' WHERE album_id = 20 ;
UPDATE album SET cost = 11.0 WHERE album_id = 21 ;
UPDATE album SET purchased_datetime = '2003-08-29' WHERE album_id = 21 ;
UPDATE album SET cost = 11.43 WHERE album_id = 22 ;
UPDATE album SET purchased_datetime = '2017-03-20' WHERE album_id = 22 ;
UPDATE album SET cost = 8.98 WHERE album_id = 23 ;
UPDATE album SET purchased_datetime = '2020-03-14' WHERE album_id = 23 ;
UPDATE album SET cost = 13.64 WHERE album_id = 24 ;
UPDATE album SET purchased_datetime = '2017-07-13' WHERE album_id = 24 ;
UPDATE album SET cost = 14.71 WHERE album_id = 25 ;
UPDATE album SET purchased_datetime = '2005-11-24' WHERE album_id = 25 ;
UPDATE album SET cost = 15.1 WHERE album_id = 26 ;
UPDATE album SET purchased_datetime = '2000-09-14' WHERE album_id = 26 ;
UPDATE album SET cost = 15.76 WHERE album_id = 27 ;
UPDATE album SET purchased_datetime = '2016-07-01' WHERE album_id = 27 ;
UPDATE album SET cost = 16.04 WHERE album_id = 28 ;
UPDATE album SET purchased_datetime = '2011-06-13' WHERE album_id = 28 ;
UPDATE album SET sold_datetime = '2022-01-21' WHERE album_id = 28 ;
UPDATE album SET price = 56.16 WHERE album_id = 28 ;
UPDATE album SET cost = 13.67 WHERE album_id = 29 ;
UPDATE album SET purchased_datetime = '2020-02-18' WHERE album_id = 29 ;
UPDATE album SET sold_datetime = '2021-12-19' WHERE album_id = 29 ;
UPDATE album SET price = 33.5 WHERE album_id = 29 ;
UPDATE album SET cost = 9.59 WHERE album_id = 30 ;
UPDATE album SET purchased_datetime = '2010-06-09' WHERE album_id = 30 ;
UPDATE album SET cost = 14.28 WHERE album_id = 31 ;
UPDATE album SET purchased_datetime = '2003-10-03' WHERE album_id = 31 ;
UPDATE album SET cost = 8.12 WHERE album_id = 32 ;
UPDATE album SET purchased_datetime = '2020-07-07' WHERE album_id = 32 ;
UPDATE movie SET cost = 15.05 WHERE movie_id = 1 ;
UPDATE movie SET purchased_datetime = '2012-07-20' WHERE movie_id = 119 ;
UPDATE movie SET cost = 34.69 WHERE movie_id = 2 ;
UPDATE movie SET purchased_datetime = '2004-02-19' WHERE movie_id = 120 ;
UPDATE movie SET cost = 18.9 WHERE movie_id = 3 ;
UPDATE movie SET purchased_datetime = '2005-12-19' WHERE movie_id = 121 ;
UPDATE movie SET cost = 49.49 WHERE movie_id = 4 ;
UPDATE movie SET purchased_datetime = '2018-03-25' WHERE movie_id = 122 ;
UPDATE movie SET cost = 22.61 WHERE movie_id = 5 ;
UPDATE movie SET purchased_datetime = '2001-02-22' WHERE movie_id = 5 ;
UPDATE movie SET sold_datetime = '2024-01-10' WHERE movie_id = 5;
UPDATE movie SET price = 59.90 WHERE movie_id = 5 ;