nGSxvapU

1DROP TABLE IF EXISTS singers;
2DROP TABLE IF EXISTS albums;
3DROP TABLE IF EXISTS awards;
4PRAGMA foreign_keys = ON;
5
6create table singers ( sid INTEGER, s_name CHAR(30), origin CHAR(20), PRIMARY KEY(sid));
7create table albums (aid  INTEGER, a_name CHAR(30), year INTEGER, rating Integer, sid INTEGER NOT NULL, awards INTEGER, genre CHAR(20), PRIMARY KEY(aid), FOREIGN KEY (sid) REFERENCES singers);
8create table awards (aid  INTEGER, a_name CHAR(30), sid INTEGER NOT NULL, status INTEGER, PRIMARY KEY(aid), FOREIGN KEY (sid) REFERENCES singers);
9
10INSERT INTO singers VALUES( 1, 'Taylor Swift', 'US');
11INSERT INTO singers VALUES( 2, 'Bryan Adams', 'Canada');
12INSERT INTO singers VALUES( 3, 'Drake', 'Canada');
13INSERT INTO singers VALUES( 4, 'Sia', 'Australia');
14INSERT INTO singers VALUES( 5, 'Justin Bieber', 'Canada');
15INSERT INTO singers VALUES( 6, 'Kylie Minogue', 'Australia');
16INSERT INTO singers VALUES( 7, 'Florida Georgia Line', 'US');
17INSERT INTO singers VALUES( 8, 'Feist', 'Canada');
18INSERT INTO singers VALUES( 9, 'The Weeknd', 'Canada');
19
20INSERT INTO albums VALUES( 1, '1000 Forms of Fear', 2013 , 5, 4, NULL, 'Pop');
21INSERT INTO albums VALUES( 2, '18 till I Die', 1996, 4, 2, 2, 'Rock');
22INSERT INTO albums VALUES( 3, 'Waking Up the Neighbours', 1991, 5, 2, 0, 'Pop');
23INSERT INTO albums VALUES( 4, '1989', 2014, 4, 1, NULL, 'Pop');
24INSERT INTO albums VALUES( 5, 'Scorpion', 2018, 4, 3,1, 'Rap');
25INSERT INTO albums VALUES( 6, 'Monarch', 1999, 3, 8, 0, 'Pop');
26INSERT INTO albums VALUES( 7, 'Take Care', 2011, 5, 3, 6, 'Rap');
27INSERT INTO albums VALUES( 8, 'Beauty Behind the Madness', 2015, 3, 9, 1, 'Pop');
28INSERT INTO albums VALUES( 9, 'Dig Your Roots', 2016, 4, 7, 0, 'Country');
29INSERT INTO albums VALUES( 10, 'Purpose', 2015, 2, 5, 0, 'Pop');
30INSERT INTO albums VALUES( 11, 'Live In Sydney', 2001, 5, 6, 2, 'Rop');
31INSERT INTO albums VALUES( 12, 'Some Poeple Have Real Problems', 2008, 5, 4, 4, 'Pop');