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,
"Citizenship" TEXT,
PRIMARY KEY ("Singer_ID")
);

CREATE TABLE "song" (
"Song_ID" INT,
"Title" TEXT,
"Singer_ID" INT,
PRIMARY KEY ("Song_ID"),
FOREIGN KEY ("Singer_ID") REFERENCES "singer"("Singer_ID")
);





INSERT INTO "singer" VALUES ("1", "Edith Piaf", "1915.0", "French");
INSERT INTO "singer" VALUES ("2", "Charles Aznavour", "1924.0", "French");
INSERT INTO "singer" VALUES ("3", "Celine Dion", "1968.0", "Canadian");
INSERT INTO "singer" VALUES ("4", "Elvis Presley", "1935.0", "American");
INSERT INTO "singer" VALUES ("5", "Adele", "1988.0", "British");
INSERT INTO "singer" VALUES ("6", "Stromae", "1985.0", "Belgian");
INSERT INTO "singer" VALUES ("7", "Johnny Hallyday", "1943.0", "French");
INSERT INTO "singer" VALUES ("8", "Shakira", "1977.0", "Colombian");
INSERT INTO "singer" VALUES ("9", "Dua Lipa", "1995.0", "British");
INSERT INTO "singer" VALUES ("10", "Angèle", "1995.0", "Belgian");
INSERT INTO "song" VALUES ("1", "La Vie en rose", "1");
INSERT INTO "song" VALUES ("2", "Non, je ne regrette rien", "1");
INSERT INTO "song" VALUES ("3", "La Bohème", "2");
INSERT INTO "song" VALUES ("4", "My Heart Will Go On", "3");
INSERT INTO "song" VALUES ("5", "Jailhouse Rock", "4");
INSERT INTO "song" VALUES ("6", "Hello", "5");
INSERT INTO "song" VALUES ("7", "Alors on danse", "6");
INSERT INTO "song" VALUES ("8", "Que je t'aime", "7");
INSERT INTO "song" VALUES ("9", "Waka Waka", "8");
INSERT INTO "song" VALUES ("10", "Don't Start Now", "9");
INSERT INTO "song" VALUES ("11", "Balance ton quoi", "10");
INSERT INTO "song" VALUES ("12", "Formidable", "6");
INSERT INTO "song" VALUES ("13", "Rolling in the Deep", "5");
INSERT INTO "song" VALUES ("14", "Hips Don't Lie", "8");
INSERT INTO "song" VALUES ("15", "All by Myself", "3");