text: CREATE TABLE school(
     school_id serial PRIMARY KEY,
     name VARCHAR (255) NOT NULL,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  CREATE TABLE class(
     class_id serial PRIMARY KEY,
     name VARCHAR (255) NOT NULL,
     school_id integer,
     created_at TIMESTAMP DEFAULT NOW() 
  );
  
  CREATE TABLE student(
     student_id serial PRIMARY KEY,
     first_name VARCHAR (255) NOT NULL,
     last_name VARCHAR (255) NOT NULL,
     middle_name VARCHAR (255),
     birth_date date NOT NULL,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  CREATE TABLE teacher(
     teacher_id serial PRIMARY KEY, 
     first_name VARCHAR (255) NOT NULL,
     last_name VARCHAR (255) NOT NULL,
     middle_name VARCHAR (255),
     birth_date date NOT NULL,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  CREATE TABLE class_student(
     class_student_id serial PRIMARY KEY,
     class_id integer NOT NULL,
     student_id integer NOT NULL,
     score real,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  CREATE TABLE class_teacher(
     class_teacher_id serial PRIMARY KEY,
     class_id integer NOT NULL,
     teacher_id integer NOT NULL,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  CREATE TABLE schedule(
     schedule_id serial PRIMARY KEY,
     class_teacher_id integer,
     day_of_week VARCHAR (255) NOT NULL,
     time_of_day time NOT NULL,
     created_at TIMESTAMP DEFAULT NOW()
  );
  
  begin;
  
  insert into school
     (school_id, name) 
     values
     (1, 'Hillside High School'),
     (2, 'Riverside High School');
  
  
  insert into class(class_id,name, school_id)
     values
     (101, 'Math', 1),
     (102, 'English', 1),
     (103, 'History', 1),
     (104, 'Biology', 1),
     (105, 'Chemistry', 1),
     (106, 'Physics', 1),
     (201, 'Math', 2),
     (202, 'English', 2),
     (203, 'History', 2),
     (204, 'Biology', 2),
     (205, 'Chemistry', 2),
     (206, 'Physics', 2);
     
     
  
  insert into student(student_id, first_name, last_name, middle_name, birth_date)
     values
     (1,'Dody','Hilda','Buck','1985-2-16'),
  (2,'Eleonora','Morey','Nate','1951-9-13'),
  (3,'Deeann','Otina','Keane','2007-9-13'),
  (4,'Lynnelle','Rivalee','Ricky','1932-8-13'),
  (5,'Doralin','Cleopatre','Weber','1968-7-20'),
  (6,'Hilde','Fagen','Hewett','1955-7-15'),
  (7,'Kyla','Tobey','Cristian','1937-6-24'),
  (8,'Charmian','Vlad','Nicolai','1988-2-1'),
  (9,'Annette','Stratton','Dael','2015-10-17'),
  (10,'Mariette','Ferde','Oran','1995-2-17'),
  (11,'Dorine','Koblick','Gar','2001-11-19'),
  (12,'Malia','Toni','Wilden','2013-8-2'),
  (13,'Ilene','Joey','Burtie','1994-3-18'),
  (14,'Harli','Thamos','Mead','1936-1-21'),
  (15,'Luelle','Johnson','Cesar','2006-3-21'),
  (16,'Dorena','Felipa','Bevan','1950-12-2'),
  (17,'Birdie','Mikihisa','Alf','1941-6-22'),
  (18,'Cordy','Gaeta','Bradan','1962-4-2'),
  (19,'Goldy','Fleming','Tan','1998-10-14'),
  (20,'Amelita','Mark','Broddy','1948-12-16'),
  (21,'Jorrie','Cynde','Claiborne','1989-4-23'),
  (22,'Cherie','Hulbig','Nikolaos','1938-12-8'),
  (23,'Johnna','Tolman','Aksel','1965-2-27'),
  (24,'Giuditta','Wunder','Jerrie','1947-3-5'),
  (25,'Lynnette','Awad','Kelbee','2004-11-19'),
  (26,'Alene','Orrin','Archibold','1933-2-18'),
  (27,'Dasha','Aubreir','Lisle','1976-9-15'),
  (28,'Madelon','Semmes','Broddie','1963-6-12'),
  (29,'Janeta','Resee','Jan','1940-9-11'),
  (30,'Kimbra','Ivory','Dene','1969-9-12'),
  (31,'Alfy','Andrews','Stanislaw','1958-12-6'),
  (32,'Helsa','Reg','Alfredo','1937-2-25'),
  (33,'Linell','Klug','Wainwright','1930-4-4'),
  (34,'Carlye','Caputto','Dana','1931-10-26'),
  (35,'Andria','Coshow','Nikolai','1935-10-28'),
  (36,'Madelena','Berger','Elisha','2012-9-17'),
  (37,'Kacie','Ewald','Jaime','2004-3-20'),
  (38,'Darell','Sheff','Jarvis','1972-10-4'),
  (39,'Katuscha','Drain','Edgar','1990-10-1'),
  (40,'Jamie','Benita','Heriberto','1968-5-16'),
  (41,'Lila','Jankell','Zacharia','1991-6-28'),
  (42,'Lucinda','Kataway','Chester','1979-3-19'),
  (43,'Audy','Swane','Flint','2005-1-1'),
  (44,'Dorris','Pattani','Derrick','1984-3-19'),
  (45,'Amber','Templia','Corby','1999-11-28'),
  (46,'Carita','Jehiah','Hardy','2008-5-6'),
  (47,'Amii','Plerre','Jourdain','2004-1-21'),
  (48,'Judi','Jilleen','Jude','1969-11-6'),
  (49,'Dominica','Miki','Archaimbaud','2015-8-2'),
  (50,'Phil','Kingsley','Gerald','1939-8-16'),
  (51,'Etta','Ashlin','Shaughn','1949-6-5'),
  (52,'Imogen','Jon','Nolan','1958-11-8'),
  (53,'Phebe','Merrilee','Papageno','1968-11-5'),
  (54,'Edie','Bander','Raimondo','1933-4-28'),
  (55,'Gretal','Gibb','Itch','1949-3-17'),
  (56,'Caterina','Cheston','Vincent','2010-9-23'),
  (57,'Liza','Sapphire','Renaud','1981-11-20'),
  (58,'Dee','O''Donovan','Torrin','2003-5-21'),
  (59,'Meryl','Ahrendt','Bret','1961-8-28'),
  (60,'Aime','Arratoon','Freddie','2014-12-5'),
  (61,'Rahel','Teador','Skipp','1987-4-9'),
  (62,'Kalli','Tiana','Bennie','1964-6-8'),
  (63,'Jessika','Nilla','Pat','1968-7-8'),
  (64,'Corry','Haynes','Earlie','2016-2-19'),
  (65,'Merrily','Karp','Otis','2001-6-6'),
  (66,'Rakel','Musette','Wyndham','1985-1-25'),
  (67,'Karola','Savior','Dominique','1964-11-13'),
  (68,'Pat','Trey','Stirling','2010-8-23'),
  (69,'Jorrie','Holle','Mattheus','1969-5-11'),
  (70,'Didi','Lois','Sheffie','1944-10-22'),
  (71,'Harrie','Raynell','Chickie','1948-6-15'),
  (72,'Blanca','Onofredo','Luis','1945-5-4'),
  (73,'Cassey','Evelinn','Ike','1939-8-16'),
  (74,'Ainslie','Estel','Willie','1975-9-26'),
  (75,'Gabi','Deana','Costa','1940-12-20'),
  (76,'Mahalia','Ambrosius','Adam','1982-9-1'),
  (77,'Ginny','Sally','Willi','1954-7-17'),
  (78,'Koo','Meyeroff','Clayborne','1940-10-18'),
  (79,'Nananne','Alena','Yankee','1997-7-13'),
  (80,'Lauren','Sloatman','Chaddie','1954-6-14'),
  (81,'Benetta','Fonville','Thatcher','2009-1-8'),
  (82,'Julietta','Names','Hashim','1977-6-14'),
  (83,'Mollie','Jerrome','Mannie','2008-5-16'),
  (84,'Monica','Tychon','Marten','1968-2-26'),
  (85,'Ingeberg','Minerva','Dewitt','1959-3-25'),
  (86,'Carmon','Kate','Waylan','1988-3-21'),
  (87,'Juliana','Schilt','Ahmad','2018-4-18'),
  (88,'Joyce','Adrianna','Maurits','1970-8-2'),
  (89,'Norene','Aulea','Quillan','1948-7-14'),
  (90,'Gertrud','Rambort','Josiah','2014-1-19'),
  (91,'Ginnifer','Kirk','Teador','2010-8-10'),
  (92,'Aime','Mills','Bailey','1935-8-12'),
  (93,'Morgen','Barnabas','Alejoa','1957-5-2'),
  (94,'Freda','Thomasine','Lauritz','2004-8-27'),
  (95,'Angela','Duyne','Hasty','1932-3-28'),
  (96,'Marybeth','Fini','Gregoor','1947-10-20'),
  (97,'Darcie','Halsey','Hewie','1971-6-5'),
  (98,'Annabela','Patric','Greg','2017-2-22'),
  (99,'Angelle','Cornwell','Devin','2015-8-15'),
  (100,'Merissa','Arianne','Gilles','2010-8-1');
  
  insert into teacher(teacher_id, first_name, last_name, middle_name, birth_date)
     values
  (1,'Leonie','Meg','Shepperd','2016-3-15'),
  (2,'Kanya','Nawrocki','Gordie','1995-12-7'),
  (3,'Jerrilyn','Pia','Swen','2001-2-12'),
  (4,'Page','Okechuku','Smitty','1979-4-9'),
  (5,'Marchelle','Tandy','Gearalt','1946-4-8'),
  (6,'Midge','Goldberg','Marchall','2013-2-23'),
  (7,'Michaella','Dustie','Curran','1975-4-17'),
  (8,'Almeria','Bette-Ann','Ryley','1982-10-14'),
  (9,'Lisabeth','Derick','Marchall','2008-1-23'),
  (10,'Doralia','Alexandra','Mahmoud','1960-3-15'),
  (11,'Crin','Trudey','Jarrod','1984-12-3'),
  (12,'Annmaria','Stedman','Barnaby','2015-11-27'),
  (13,'Fanechka','Dzoba','Filmer','1941-2-10'),
  (14,'Leela','Riplex','Antonio','1978-11-11'),
  (15,'Liva','Yseulte','Pierre','2012-6-16'),
  (16,'Fedora','Runstadler','Wyndham','1973-5-2'),
  (17,'Pearla','Giuseppe','Noam','1985-5-10'),
  (18,'Carlynne','Phaih','Monro','1971-8-4'),
  (19,'Jeannette','Halla','Brocky','2017-6-22'),
  (20,'Krystle','McCully','Skye','1987-5-17'),
  (21,'Caye','Lotta','Orbadiah','1966-1-11'),
  (22,'Lebbie','Jehial','Laurent','1940-11-5'),
  (23,'Aleta','Hunt','Madison','1936-1-21'),
  (24,'Marita','Aindrea','Stanfield','2015-10-4'),
  (25,'Clemmy','Stanhope','Tanney','1950-1-15'),
  (26,'Mathilda','Julieta','Kaine','1943-2-4'),
  (27,'Kizzee','Muffin','Shepperd','1981-8-1'),
  (28,'Donica','Autumn','Felic','1969-7-5'),
  (29,'Joletta','Buchheim','Willie','1989-11-13'),
  (30,'Kimmie','Pacificas','Artemis','1959-11-19'),
  (31,'Lia','Eduard','Averill','1934-11-9'),
  (32,'Pauletta','Biddick','Gerome','1971-6-3'),
  (33,'Janaye','Meece','Hube','1951-4-24'),
  (34,'Berte','Fougere','Chester','2005-12-12'),
  (35,'Jerrylee','Savick','Daryl','1946-8-8'),
  (36,'Ofilia','Kurzawa','Pietro','1997-10-7'),
  (37,'Blake','Izy','Gill','2002-6-6'),
  (38,'Arabella','Jez','Renado','1980-4-5'),
  (39,'Gilemette','Eastman','Guthry','2014-5-18'),
  (40,'Minta','Yesima','Valentino','2016-8-18'),
  (41,'Nissy','Downall','Hughie','1996-3-3'),
  (42,'Gaynor','Caines','Ingamar','1944-7-26'),
  (43,'Nikaniki','Pryce','Ogdon','2007-6-14'),
  (44,'Lyssa','Bish','Silvester','1986-4-14'),
  (45,'Celine','Patrica','Oran','2003-7-4'),
  (46,'Britte','Riker','Karlens','1982-7-8'),
  (47,'Myranda','Orlan','Rodge','2011-5-24'),
  (48,'Hinda','Mercola','Godard','1959-7-22'),
  (49,'Barry','Kumagai','Denny','1986-8-10'),
  (50,'Nanon','Harmaning','Bank','1961-2-26'),
  (51,'Eve','Brookes','Bern','1986-9-9'),
  (52,'Cheslie','Schiff','Land','1981-12-11'),
  (53,'Josefa','Pope','Tiebold','1938-6-15'),
  (54,'Meredithe','Dedric','Tabby','1994-6-2'),
  (55,'Katrine','Cleary','Brnaba','1981-8-5'),
  (56,'Mollie','Catton','Franzen','1978-4-21'),
  (57,'Maryellen','Tobi','Montgomery','1962-10-17'),
  (58,'Honoria','Dedric','Egbert','1977-5-3'),
  (59,'Merla','Hardej','Euell','2014-7-5'),
  (60,'Isidora','Amalita','Brendin','1988-5-24'),
  (61,'Lyndy','Fernanda','Constantin','1938-4-14'),
  (62,'Anselma','Yearwood','Boothe','1976-8-17'),
  (63,'Lauralee','Cassidy','Nikos','1945-9-3'),
  (64,'Meade','Sedgewinn','Luciano','2009-4-26'),
  (65,'Genia','Brenden','Cirilo','2014-9-23'),
  (66,'Beryl','Rodrique','Matthias','1942-5-27'),
  (67,'Myrah','Edea','Barney','1999-4-20'),
  (68,'Dosi','Joachima','Flem','1935-8-15'),
  (69,'Damaris','Hook','Raddy','2006-8-26'),
  (70,'Rafaelia','Trautman','Rodger','1966-12-13'),
  (71,'Angele','Quintin','Matthieu','2003-2-16'),
  (72,'Ina','Lodhia','Jacob','1973-1-19'),
  (73,'Luci','Greenwood','Lovell','1959-9-4'),
  (74,'Gerrie','Johnette','Luca','1945-12-21'),
  (75,'Corilla','Dam','Rochester','1983-11-2'),
  (76,'Ann-Marie','Kunkle','Erv','2013-3-1'),
  (77,'Clarine','Terrill','Lazaro','2000-7-16'),
  (78,'Minni','Donelson','Ara','2005-2-18'),
  (79,'Mariska','Garnet','Edward','1980-10-17'),
  (80,'Ginnie','Grinnell','Horacio','1986-9-15'),
  (81,'Brittaney','Poyssick','Kinsley','2012-11-8'),
  (82,'Querida','Huberman','Antonio','1986-8-24'),
  (83,'Portia','Kahlil','Johny','1990-4-16'),
  (84,'Ardelis','Clarey','Doy','1997-7-27'),
  (85,'Meaghan','Sherl','Colby','1955-10-2'),
  (86,'Marylinda','Eleni','Harmon','1976-11-12'),
  (87,'Minne','Furgeson','Hi','1971-5-16'),
  (88,'Adel','Chrystel','Henrik','1988-11-7'),
  (89,'Antonietta','Caputto','Morris','1996-7-9'),
  (90,'Papagena','Standish','Pepillo','2004-2-15'),
  (91,'Matilda','Bettine','Wolfie','1977-11-10'),
  (92,'Pier','Caril','Stanton','2007-3-18'),
  (93,'Maggee','Laurie','Keen','1987-9-28'),
  (94,'Addy','Olav','Kip','2018-9-23'),
  (95,'Kristal','Reed','Emerson','1979-9-11'),
  (96,'Janet','Margarethe','Jerome','1975-12-23'),
  (97,'Livvyy','Janicki','Joey','1975-11-15'),
  (98,'Beulah','Paik','Josiah','2002-6-5'),
  (99,'Nora','Gayler','Rip','1988-7-9'),
  (100,'Desdemona','Peyton','Klemens','1988-2-22');
  
  
  insert into class_student( class_student_id, class_id, student_id, score)
    values
    (1,102,18,91),
  (2,101,36,89),
  (3,103,93,92),
  (4,102,28,74),
  (5,102,68,83),
  (6,105,11,82),
  (7,102,71,89),
  (8,101,20,88),
  (9,103,48,88),
  (10,102,60,73),
  (11,105,95,79),
  (12,104,44,88),
  (13,105,86,82),
  (14,105,59,65),
  (15,103,44,96),
  (16,101,97,99),
  (17,104,51,93),
  (18,102,84,97),
  (19,102,91,71),
  (20,102,100,70),
  (21,105,73,87),
  (22,101,30,98),
  (23,106,62,80),
  (24,106,12,73),
  (25,102,82,97),
  (26,106,30,77),
  (27,105,67,70),
  (28,102,83,72),
  (29,104,35,83),
  (30,101,56,98),
  (31,101,53,68),
  (32,106,81,93),
  (33,104,73,98),
  (34,105,36,80),
  (35,101,17,64),
  (36,103,13,97),
  (37,105,4,62),
  (38,104,10,81),
  (39,103,96,70),
  (40,104,88,89),
  (41,102,76,73),
  (42,104,84,78),
  (43,102,23,78),
  (44,105,99,98),
  (45,101,65,80),
  (46,103,48,70),
  (47,102,3,91),
  (48,102,60,64),
  (49,104,61,74),
  (50,101,23,75),
  (51,102,33,73),
  (52,101,27,64),
  (53,105,75,78),
  (54,101,15,74),
  (55,101,67,92),
  (56,104,24,60),
  (57,105,58,75),
  (58,102,57,65),
  (59,106,48,82),
  (60,104,18,60),
  (61,104,47,93),
  (62,105,24,77),
  (63,102,47,94),
  (64,106,54,75),
  (65,103,31,89),
  (66,103,66,67),
  (67,103,43,92),
  (68,105,7,84),
  (69,102,25,72),
  (70,106,76,63),
  (71,104,73,80),
  (72,102,12,64),
  (73,105,20,75),
  (74,103,78,70),
  (75,106,98,75),
  (76,104,45,70),
  (77,106,80,90),
  (78,102,64,97),
  (79,103,10,83),
  (80,106,56,62),
  (81,106,6,73),
  (82,104,8,93),
  (83,103,3,91),
  (84,103,25,94),
  (85,105,13,79),
  (86,105,67,77),
  (87,106,16,90),
  (88,106,72,84),
  (89,104,71,85),
  (90,102,37,78),
  (91,106,57,89),
  (92,101,75,60),
  (93,102,22,99),
  (94,103,52,92),
  (95,102,66,95),
  (96,102,42,71),
  (97,102,57,78),
  (98,103,100,91),
  (99,104,100,71),
  (100,104,73,92),
  (101,101,88,82),
  (102,101,25,77),
  (103,102,50,68),
  (104,101,57,81),
  (105,103,51,82),
  (106,103,88,70),
  (107,105,24,63),
  (108,104,86,72),
  (109,102,74,84),
  (110,105,100,93),
  (111,105,49,73),
  (112,101,49,80),
  (113,102,61,98),
  (114,102,8,77),
  (115,105,56,62),
  (116,102,22,63),
  (117,102,60,86),
  (118,103,77,68),
  (119,103,47,72),
  (120,101,90,84),
  (121,104,36,62),
  (122,104,37,67),
  (123,106,17,98),
  (124,105,59,69),
  (125,106,38,81),
  (126,106,55,92),
  (127,103,52,89),
  (128,106,73,67),
  (129,105,56,61),
  (130,102,74,60),
  (131,106,97,73),
  (132,104,90,79),
  (133,103,47,62),
  (134,103,9,92),
  (135,103,10,83),
  (136,104,4,75),
  (137,102,8,76),
  (138,101,71,88),
  (139,102,100,81),
  (140,101,82,61),
  (141,103,31,73),
  (142,106,23,80),
  (143,104,54,84),
  (144,101,32,68),
  (145,104,3,81),
  (146,106,95,78),
  (147,103,45,63),
  (148,105,65,82),
  (149,101,32,70),
  (150,105,37,65),
  (151,106,6,72),
  (152,101,22,84),
  (153,102,15,83),
  (154,104,66,89),
  (155,104,26,96),
  (156,106,78,82),
  (157,103,75,67),
  (158,106,71,100),
  (159,104,35,72),
  (160,104,46,72),
  (161,202,37,99),
  (162,203,82,96),
  (163,205,21,96),
  (164,201,24,68),
  (165,204,51,94),
  (166,206,55,82),
  (167,202,45,80),
  (168,202,89,77),
  (169,205,60,63),
  (170,205,38,74),
  (171,201,67,60),
  (172,205,6,79),
  (173,206,28,79),
  (174,203,29,64),
  (175,206,58,91),
  (176,206,68,63),
  (177,202,70,89),
  (178,206,85,94),
  (179,202,43,69),
  (180,204,83,85),
  (181,204,29,94),
  (182,204,20,85),
  (183,204,75,65),
  (184,203,56,72),
  (185,205,92,90),
  (186,202,85,73),
  (187,204,76,90),
  (188,201,49,75),
  (189,205,30,88),
  (190,206,63,66),
  (191,206,6,76),
  (192,206,79,88),
  (193,206,93,89),
  (194,205,30,61),
  (195,202,65,73),
  (196,204,45,89),
  (197,205,51,85),
  (198,202,20,93),
  (199,202,76,100),
  (200,206,91,77),
  (201,203,66,94),
  (202,206,79,89),
  (203,206,27,80),
  (204,201,69,100),
  (205,201,32,70),
  (206,204,4,92),
  (207,204,79,82),
  (208,205,37,70),
  (209,203,1,64),
  (210,202,87,80),
  (211,203,87,100),
  (212,202,23,89),
  (213,202,78,66),
  (214,206,25,64),
  (215,202,99,67),
  (216,205,92,99),
  (217,205,23,82),
  (218,205,13,88),
  (219,205,32,89),
  (220,203,9,63),
  (221,205,64,62),
  (222,202,31,86),
  (223,201,12,63),
  (224,205,32,71),
  (225,202,71,83),
  (226,204,54,92),
  (227,202,44,66),
  (228,202,64,73),
  (229,202,16,86),
  (230,201,20,91),
  (231,206,15,67),
  (232,206,96,71),
  (233,202,65,77),
  (234,204,60,90),
  (235,204,4,99),
  (236,206,81,87),
  (237,205,11,62),
  (238,202,72,95),
  (239,202,61,75),
  (240,205,58,100),
  (241,206,1,82),
  (242,206,98,95),
  (243,205,1,77),
  (244,201,81,77),
  (245,204,51,95),
  (246,204,6,70),
  (247,205,95,62),
  (248,202,20,61),
  (249,202,62,96),
  (250,205,85,78),
  (251,201,17,86),
  (252,206,17,82),
  (253,202,17,60),
  (254,206,66,75),
  (255,203,100,76),
  (256,202,82,89),
  (257,203,32,97),
  (258,205,15,83),
  (259,202,60,93),
  (260,201,26,77),
  (261,204,2,65),
  (262,202,3,82),
  (263,204,19,75),
  (264,201,54,82),
  (265,204,66,89),
  (266,202,34,85),
  (267,203,58,71),
  (268,206,64,68),
  (269,203,75,73),
  (270,202,92,67),
  (271,206,6,78),
  (272,204,33,73),
  (273,204,35,75),
  (274,202,47,64),
  (275,202,48,82),
  (276,201,85,79),
  (277,205,36,98),
  (278,206,6,83),
  (279,206,21,81),
  (280,205,34,68),
  (281,203,68,80),
  (282,206,67,61),
  (283,201,25,61),
  (284,205,54,74),
  (285,203,56,77),
  (286,204,34,85),
  (287,201,71,90),
  (288,205,61,74),
  (289,206,36,84),
  (290,206,18,69),
  (291,206,19,62),
  (292,206,10,72),
  (293,202,5,98),
  (294,203,29,100),
  (295,203,59,90),
  (296,202,67,66),
  (297,203,70,60),
  (298,201,78,88),
  (299,205,28,60),
  (300,205,100,97),
  (301,201,31,75),
  (302,204,4,87),
  (303,205,6,94),
  (304,205,11,65),
  (305,205,7,61),
  (306,201,18,74),
  (307,206,27,74),
  (308,202,71,61),
  (309,201,32,60),
  (310,206,12,97),
  (311,201,37,77),
  (312,204,46,96),
  (313,205,94,89),
  (314,205,49,99),
  (315,201,24,76),
  (316,206,80,81),
  (317,202,27,100),
  (318,206,2,100),
  (319,203,70,97),
  (320,201,65,93),
  (321,203,97,85),
  (322,206,15,74),
  (323,201,27,67),
  (324,201,58,83),
  (325,205,31,75),
  (326,205,13,67),
  (327,202,32,79),
  (328,205,8,75),
  (329,201,6,69),
  (330,201,85,93),
  (331,202,60,89),
  (332,202,45,82),
  (333,206,81,67),
  (334,206,47,66),
  (335,202,89,83),
  (336,205,1,73),
  (337,206,25,63),
  (338,204,14,79),
  (339,205,34,93),
  (340,205,81,94),
  (341,205,75,97),
  (342,204,58,78),
  (343,202,85,82),
  (344,202,80,97),
  (345,203,83,83),
  (346,205,97,66),
  (347,206,51,97),
  (348,204,10,90),
  (349,201,19,88),
  (350,201,24,88),
  (351,203,100,98),
  (352,205,21,62),
  (353,205,12,60),
  (354,202,33,89),
  (355,202,15,86),
  (356,204,39,94),
  (357,201,86,81),
  (358,203,89,98),
  (359,204,95,79),
  (360,204,76,74);
  
  insert into class_teacher(class_teacher_id, class_id, teacher_id)
    values
    (1,101,1),
  (2,101,2),
  (3,102,3),
  (4,102,4),
  (5,103,5),
  (6,103,6),
  (7,104,7),
  (8,104,8),
  (9,105,9),
  (10,105,10),
  (11,106,11),
  (12,106,12),
  (13,201,13),
  (14,201,14),
  (15,202,15),
  (16,202,16),
  (17,203,17),
  (18,203,18),
  (19,204,19),
  (20,204,20),
  (21,205,21),
  (22,205,22),
  (23,206,23),
  (24,206,24);
  
  insert into schedule(schedule_id, class_teacher_id, day_of_week, time_of_day)
    values
    (1,1,'Monday','09:00:00'),
  (2,2,'Tuesday','14:00:00'),
  (3,3,'Wednesday','09:00:00'),
  (4,4,'Thursday','14:00:00'),
  (5,5,'Friday','09:00:00'),
  (6,6,'Monday','14:00:00'),
  (7,7,'Tuesday','09:00:00'),
  (8,8,'Wednesday','14:00:00'),
  (9,9,'Thursday','09:00:00'),
  (10,10,'Friday','14:00:00'),
  (11,11,'Monday','09:00:00'),
  (12,12,'Tuesday','14:00:00'),
  (13,13,'Wednesday','09:00:00'),
  (14,14,'Thursday','14:00:00'),
  (15,15,'Friday','09:00:00'),
  (16,16,'Monday','14:00:00'),
  (17,17,'Tuesday','09:00:00'),
  (18,18,'Wednesday','14:00:00'),
  (19,19,'Thursday','09:00:00'),
  (20,20,'Friday','14:00:00'),
  (21,21,'Monday','09:00:00'),
  (22,22,'Tuesday','14:00:00'),
  (23,23,'Wednesday','09:00:00'),
  (24,24,'Thursday','14:00:00');