PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "singer" (
"Singer_ID" INT,
"Name" TEXT,
"Birth_Year" FLOAT,
"Net_Worth_Millions" FLOAT,
"Citizenship" TEXT,
PRIMARY KEY ("Singer_ID")
);

CREATE TABLE "song" (
"Song_ID" INT,
"Title" TEXT,
PRIMARY KEY ("Song_ID")
);





INSERT INTO "singer" VALUES ("1", "Frank Sinatra", "1915.0", "100.0", "USA");
INSERT INTO "singer" VALUES ("2", "Elvis Presley", "1935.0", "200.0", "USA");
INSERT INTO "singer" VALUES ("3", "Bob Dylan", "1941.0", "180.0", "USA");
INSERT INTO "singer" VALUES ("4", "Aretha Franklin", "1942.0", "80.0", "USA");
INSERT INTO "singer" VALUES ("5", "Stevie Wonder", "1950.0", "110.0", "USA");
INSERT INTO "singer" VALUES ("6", "Madonna", "1958.0", "850.0", "USA");
INSERT INTO "singer" VALUES ("7", "Michael Jackson", "1958.0", "500.0", "USA");
INSERT INTO "singer" VALUES ("8", "Prince", "1958.0", "300.0", "USA");
INSERT INTO "singer" VALUES ("9", "Elton John", "1947.0", "500.0", "UK");
INSERT INTO "singer" VALUES ("10", "David Bowie", "1947.0", "230.0", "UK");
INSERT INTO "singer" VALUES ("11", "Adele", "1988.0", "220.0", "UK");
INSERT INTO "singer" VALUES ("12", "Ed Sheeran", "1991.0", "200.0", "UK");
INSERT INTO "singer" VALUES ("13", "Julio Iglesias", "1943.0", "600.0", "Spain");
INSERT INTO "singer" VALUES ("14", "Enrique Iglesias", "1975.0", "100.0", "Spain");
INSERT INTO "singer" VALUES ("15", "Celine Dion", "1968.0", "800.0", "Canada");
INSERT INTO "singer" VALUES ("16", "Leonard Cohen", "1934.0", "50.0", "Canada");
INSERT INTO "singer" VALUES ("17", "Johnny Cash", "1932.0", "60.0", "USA");
INSERT INTO "singer" VALUES ("18", "Willie Nelson", "1933.0", "25.0", "USA");
INSERT INTO "singer" VALUES ("19", "Taylor Swift", "1989.0", "570.0", "USA");
INSERT INTO "singer" VALUES ("20", "Beyonce", "1981.0", "500.0", "USA");
INSERT INTO "song" VALUES ("1", "My Way");
INSERT INTO "song" VALUES ("2", "Hound Dog");
INSERT INTO "song" VALUES ("3", "Like a Rolling Stone");
INSERT INTO "song" VALUES ("4", "Respect");
INSERT INTO "song" VALUES ("5", "Superstition");
INSERT INTO "song" VALUES ("6", "Like a Virgin");
INSERT INTO "song" VALUES ("7", "Billie Jean");
INSERT INTO "song" VALUES ("8", "Purple Rain");
INSERT INTO "song" VALUES ("9", "Rocket Man");
INSERT INTO "song" VALUES ("10", "Space Oddity");
INSERT INTO "song" VALUES ("11", "Rolling in the Deep");
INSERT INTO "song" VALUES ("12", "Shape of You");
INSERT INTO "song" VALUES ("13", "Begin the Beguine");
INSERT INTO "song" VALUES ("14", "Bailando");
INSERT INTO "song" VALUES ("15", "My Heart Will Go On");
INSERT INTO "song" VALUES ("16", "Hallelujah");
INSERT INTO "song" VALUES ("17", "Ring of Fire");
INSERT INTO "song" VALUES ("18", "On the Road Again");
INSERT INTO "song" VALUES ("19", "Blank Space");
INSERT INTO "song" VALUES ("20", "Single Ladies");