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 "conductor" (
"Conductor_ID" INT UNIQUE,
"Name" TEXT,
PRIMARY KEY ("Conductor_ID")
);

CREATE TABLE "orchestra" (
"Orchestra_ID" INT,
"Orchestra" TEXT,
"Conductor_ID" INT,
"Record_Company" TEXT,
"Year_of_Founded" FLOAT,
PRIMARY KEY ("Orchestra_ID"),
FOREIGN KEY ("Conductor_ID") REFERENCES "conductor"("Conductor_ID")
);





INSERT INTO "conductor" VALUES ("1", "Leonard Bernstein");
INSERT INTO "conductor" VALUES ("2", "Herbert von Karajan");
INSERT INTO "conductor" VALUES ("3", "Gustavo Dudamel");
INSERT INTO "conductor" VALUES ("4", "Riccardo Muti");
INSERT INTO "conductor" VALUES ("5", "Zubin Mehta");
INSERT INTO "conductor" VALUES ("6", "Marin Alsop");
INSERT INTO "conductor" VALUES ("7", "Yannick Nézet-Séguin");
INSERT INTO "conductor" VALUES ("8", "Valery Gergiev");
INSERT INTO "conductor" VALUES ("9", "Daniel Barenboim");
INSERT INTO "conductor" VALUES ("10", "Simon Rattle");
INSERT INTO "orchestra" VALUES ("1", "New York Philharmonic", "1", "Sony Classical", "1842.0");
INSERT INTO "orchestra" VALUES ("2", "Berlin Philharmonic", "2", "Deutsche Grammophon", "1882.0");
INSERT INTO "orchestra" VALUES ("3", "Los Angeles Philharmonic", "3", "Deutsche Grammophon", "1919.0");
INSERT INTO "orchestra" VALUES ("4", "Chicago Symphony Orchestra", "4", "CSO Resound", "1891.0");
INSERT INTO "orchestra" VALUES ("5", "Israel Philharmonic Orchestra", "5", "Sony Classical", "1936.0");
INSERT INTO "orchestra" VALUES ("6", "Baltimore Symphony Orchestra", "6", "Naxos", "1916.0");
INSERT INTO "orchestra" VALUES ("7", "Philadelphia Orchestra", "7", "Deutsche Grammophon", "1900.0");
INSERT INTO "orchestra" VALUES ("8", "Mariinsky Orchestra", "8", "Mariinsky", "1783.0");
INSERT INTO "orchestra" VALUES ("9", "Staatskapelle Berlin", "9", "Warner Classics", "1570.0");
INSERT INTO "orchestra" VALUES ("10", "London Symphony Orchestra", "10", "LSO Live", "1904.0");
INSERT INTO "orchestra" VALUES ("11", "Vienna Philharmonic", "2", "Sony Classical", "1842.0");
INSERT INTO "orchestra" VALUES ("12", "Royal Concertgebouw Orchestra", "1", "RCO Live", "1888.0");
INSERT INTO "orchestra" VALUES ("13", "San Francisco Symphony", "3", "SFS Media", "1911.0");
INSERT INTO "orchestra" VALUES ("14", "Boston Symphony Orchestra", "4", "BSO Classics", "1881.0");
INSERT INTO "orchestra" VALUES ("15", "Cleveland Orchestra", "5", "Decca", "1918.0");
INSERT INTO "orchestra" VALUES ("16", "Leipzig Gewandhaus Orchestra", "6", "Accentus Music", "1743.0");
INSERT INTO "orchestra" VALUES ("17", "Bavarian Radio Symphony Orchestra", "7", "BR-Klassik", "1949.0");
INSERT INTO "orchestra" VALUES ("18", "Dresden Staatskapelle", "8", "Profil", "1548.0");
INSERT INTO "orchestra" VALUES ("19", "Orchestre de Paris", "9", "Erato", "1967.0");
INSERT INTO "orchestra" VALUES ("20", "Philharmonia Orchestra", "10", "Signum Classics", "1945.0");
INSERT INTO "orchestra" VALUES ("21", "Metropolitan Opera Orchestra", "1", "DG", "1883.0");
INSERT INTO "orchestra" VALUES ("22", "Sydney Symphony Orchestra", "2", "ABC Classics", "1932.0");
INSERT INTO "orchestra" VALUES ("23", "Oslo Philharmonic", "3", "LAWO Classics", "1919.0");
INSERT INTO "orchestra" VALUES ("24", "Swedish Radio Symphony Orchestra", "4", "BIS", "1925.0");
INSERT INTO "orchestra" VALUES ("25", "Finnish Radio Symphony Orchestra", "5", "Ondine", "1927.0");
INSERT INTO "orchestra" VALUES ("26", "Czech Philharmonic", "6", "Supraphon", "1896.0");
INSERT INTO "orchestra" VALUES ("27", "Warsaw Philharmonic", "7", "CD Accord", "1901.0");
INSERT INTO "orchestra" VALUES ("28", "Budapest Festival Orchestra", "8", "Channel Classics", "1983.0");
INSERT INTO "orchestra" VALUES ("29", "Singapore Symphony Orchestra", "9", "BIS", "1979.0");
INSERT INTO "orchestra" VALUES ("30", "Hong Kong Philharmonic Orchestra", "10", "Naxos", "1895.0");
INSERT INTO "orchestra" VALUES ("31", "National Symphony Orchestra", "1", "Naxos", "1931.0");
INSERT INTO "orchestra" VALUES ("32", "Atlanta Symphony Orchestra", "2", "Telarc", "1945.0");
INSERT INTO "orchestra" VALUES ("33", "Houston Symphony", "3", "Pentatone", "1913.0");
INSERT INTO "orchestra" VALUES ("34", "Dallas Symphony Orchestra", "4", "DSO Live", "1900.0");
INSERT INTO "orchestra" VALUES ("35", "Seattle Symphony", "5", "Seattle Symphony Media", "1903.0");
INSERT INTO "orchestra" VALUES ("36", "Minnesota Orchestra", "6", "BIS", "1903.0");
INSERT INTO "orchestra" VALUES ("37", "St. Louis Symphony Orchestra", "7", "Naxos", "1880.0");
INSERT INTO "orchestra" VALUES ("38", "Cincinnati Symphony Orchestra", "8", "Fanfare Cincinnati", "1895.0");
INSERT INTO "orchestra" VALUES ("39", "Detroit Symphony Orchestra", "9", "DSO Live", "1914.0");
INSERT INTO "orchestra" VALUES ("40", "Pittsburgh Symphony Orchestra", "10", "Reference Recordings", "1895.0");
INSERT INTO "orchestra" VALUES ("41", "New Japan Philharmonic", "1", "Exton", "1972.0");
INSERT INTO "orchestra" VALUES ("42", "NHK Symphony Orchestra", "2", "King Records", "1926.0");
INSERT INTO "orchestra" VALUES ("43", "Tokyo Metropolitan Symphony Orchestra", "3", "Denon", "1965.0");
INSERT INTO "orchestra" VALUES ("44", "Melbourne Symphony Orchestra", "4", "ABC Classics", "1906.0");
INSERT INTO "orchestra" VALUES ("45", "New Zealand Symphony Orchestra", "5", "Naxos", "1946.0");
INSERT INTO "orchestra" VALUES ("46", "Orchestra of the Age of Enlightenment", "6", "Virgin Classics", "1986.0");
INSERT INTO "orchestra" VALUES ("47", "Academy of Ancient Music", "7", "Harmonia Mundi", "1973.0");
INSERT INTO "orchestra" VALUES ("48", "Les Arts Florissants", "8", "Erato", "1979.0");
INSERT INTO "orchestra" VALUES ("49", "Freiburger Barockorchester", "9", "Harmonia Mundi", "1987.0");
INSERT INTO "orchestra" VALUES ("50", "Concerto Köln", "10", "Berlin Classics", "1985.0");
INSERT INTO "orchestra" VALUES ("51", "Unique Records", "1", "OneTimeLabel", "2000.0");
INSERT INTO "orchestra" VALUES ("52", "Another Orchestra", "2", "Sony Classical", "1990.0");