InsertStatements.sql

INSERT INTO AREAS (PersonID, TheseNo, Area) VALUES
(9000, 100000, 'Database'),
(9000, 100000, 'Relational Model'),
(9000, 100001, 'Big Data'),
(9000, 100001, 'Ontology'),
(9001, 100002, 'Network'),
(9001, 100002, 'Switch'),
(9001, 100003, 'Internet'),
(9001, 100003, 'Router'),
(9002, 100004, 'Embedded'),
(9002, 100004, 'System'),
(9002, 100005, 'Electronic'),
(9002, 100005, 'Microcontroller'),
(9003, 100006, 'English'),
(9003, 100006, 'Software'),
(9003, 100007, 'Algorithm'),
(9003, 100007, 'Software Analysis'),
(9004, 100008, 'Network'),
(9004, 100008, 'Operating Systems'),
(9004, 100009, 'Multithread'),
(9004, 100009, 'Wireless Networks'),
(9005, 100010, 'AI'),
(9005, 100010, 'Machine Learning'),
(9005, 100011, 'Data Science'),
(9005, 100011, 'Deep Learning'),
(9006, 100012, 'Algorithm'),
(9006, 100012, 'Differential'),
(9006, 100013, 'Calculations'),
(9006, 100013, 'Graph Theory'),
(9007, 100014, 'Python'),
(9007, 100015, 'Algorithm'),
(9008, 100016, 'Graph Theory'),
(9008, 100016, 'Wireless Networks'),
(9008, 100017, 'IoT'),
(9008, 100017, 'Optimization'),
(9009, 100018, 'Java'),
(9009, 100018, 'OOP'),
(9009, 100019, 'C#'),
(9009, 100019, 'Object'),
(9010, 100020, 'Operating Systems'),
(9010, 100020, 'Process'),
(9010, 100021, 'Optimization'),
(9010, 100021, 'Thread'),
(9011, 100022, 'Software'),
(9011, 100023, 'Systems'),
(9012, 100024, 'Data Privacy'),
(9012, 100024, 'Security'),
(9012, 100025, 'Criptography'),
(9012, 100025, 'IoT'),
(9013, 100026, 'Mobile'),
(9013, 100027, 'Cloud'),
(9014, 100028, 'C'),
(9014, 100028, 'Programming Language'),
(9014, 100029, 'CPP'),
(9014, 100029, 'Python'),
(9015, 100030, 'Circuit'),
(9015, 100030, 'Electric'),
(9015, 100031, 'IoT'),
(9015, 100031, 'Microprocessors'),
(9016, 100032, 'Logic'),
(9016, 100032, 'Logic Gates'),
(9016, 100033, 'Design'),
(9016, 100033, 'Microservice'),
(9017, 100034, 'Image Processing'),
(9017, 100034, 'Pattern Recognition'),
(9017, 100035, 'Deep Learning'),
(9017, 100035, 'Machine Learning'),
(9018, 100036, 'Embedded'),
(9018, 100037, 'Microservice'),
(9019, 100038, 'IoT'),
(9019, 100039, 'Graph Theory'),
(9021, 100042, 'Embedded'),
(9021, 100043, 'Microprocessor'),
(9022, 100044, 'Python'),
(9022, 100045, 'OOP'),
(9023, 100046, 'Java'),
(9023, 100047, 'OOP'),
(9024, 100048, 'Operating Systems'),
(9024, 100049, 'Process'),
(9025, 100050, 'Design Pattern'),
(9025, 100051, 'OOP'),
(9026, 100052, 'Maths'),
(9026, 100053, 'Differential'),
(9027, 100054, 'Physics'),
(9027, 100055, 'Newton'),
(9028, 100056, 'Electronic'),
(9028, 100057, 'Circuits'),
(9029, 100058, 'Microprocessors'),
(9029, 100059, 'Microcontrollers'),
(9030, 100060, 'C'),
(9030, 100061, 'CPP'),
(9031, 100062, 'Logic'),
(9031, 100063, 'Logic Gates'),
(9032, 100064, 'Data Structures'),
(9032, 100065, 'Algorithm'),
(9033, 100066, 'Network'),
(9033, 100067, 'Computer');

INSERT INTO ASSIST_PROF (PersonID) VALUES
(9014),
(9015),
(9016),
(9017),
(9018),
(9019),
(9036),
(9039),
(9042),
(9043),
(9047),
(9048),
(9052),
(9054),
(9066),
(9068),
(9074),
(9077),
(9078),
(9081),
(9083),
(9084),
(9098),
(9099),
(9105),
(9107),
(9123),
(9125),
(9129),
(9131),
(9132),
(9139),
(9140),
(9141),
(9142),
(9143);

INSERT INTO ASSOC_PROF (PersonID) VALUES
(9009),
(9010),
(9011),
(9012),
(9013),
(9034),
(9037),
(9040),
(9046),
(9050),
(9051),
(9065),
(9069),
(9075),
(9079),
(9080),
(9094),
(9095),
(9102),
(9103),
(9104),
(9109),
(9110),
(9111),
(9122),
(9124),
(9126),
(9127),
(9128),
(9135),
(9136),
(9137),
(9145),
(9150);

INSERT INTO COLLEGE (CName, CPhone, COffice, DeanID) VALUES
('Ege University Faculty of Engineering', '2323881032', 'Erzene / Bornova / İzmir', 9020),
('Hacettepe University Faculty of Engineering', '3123055000', 'Hacettepe / Altındağ / Ankara', 9162),
('İstanbul Technical University Faculty of Engineering', '2122852900', 'Reşitpaşa / Sarıyer / İstanbul', 9121),
('Middle East Technical University Faculty of Engineering', '3122102000', 'Dumlupınar / Çankaya / Ankara', 9064),
('Yıldız Technical University Faculty of Engineering', '2324868412', 'Davutpaşa / Esenler / İstanbul', 9093);

INSERT INTO COURSE (CoCode, CoName, CoDesc, Credits, Level, CurrCode, CoType) VALUES
(1000, 'Matematik I', NULL, 5, 1, 100000, 1),
(1001, 'Fizik I', NULL, 5, 1, 100000, 1),
(1002, 'Algoritma ve Programlama I', NULL, 7, 1, 100000, 1),
(1003, 'Technical English', NULL, 4, 1, 100000, 1),
(1004, 'Matematik II', NULL, 5, 2, 100000, 1),
(1005, 'Fizik II', NULL, 5, 2, 100000, 1),
(1006, 'Ayrık Yapılar', NULL, 7, 2, 100000, 1),
(1007, 'Algoritma ve Programlama II', NULL, 7, 2, 100000, 1),
(1008, 'Introduction to Computer Science', NULL, 3, 3, 100000, 1),
(1009, 'Diferansiyel Denklemler', NULL, 4, 3, 100000, 1),
(1010, 'Electricial Circuits', NULL, 5, 3, 100000, 1),
(1011, 'Data Structures', NULL, 6, 3, 100000, 1),
(1012, 'Olasılık ve İstatistik', NULL, 3, 3, 100000, 1),
(1013, 'Mantık Devreleri Tasarımı', NULL, 5, 3, 100000, 1),
(1014, 'Automata Theory', NULL, 6, 4, 100000, 1),
(1015, 'Doğrusal Cebir ve Nümerik Yöntemler', NULL, 6, 4, 100000, 1),
(1016, 'Digital Electronics', NULL, 5, 4, 100000, 1),
(1017, 'Programming Languages', NULL, 6, 4, 100000, 1),
(1018, 'Digital Computer Design', NULL, 6, 4, 100000, 1),
(1019, 'Modern Biyoloji', NULL, 3, 4, 100000, 1),
(1020, 'Database Management', NULL, 7, 5, 100000, 1),
(1021, 'Nesneye Dayalı Programlama', NULL, 4, 5, 100000, 1),
(1022, 'İşletim Sistemleri', NULL, 4, 5, 100000, 1),
(1023, 'Mikroişlemciler', NULL, 6, 5, 100000, 1),
(1024, 'Bilgisayar Ağları', NULL, 5, 5, 100000, 1),
(1025, 'Üst Ortam Programlama', NULL, 3, 5, 100000, 2),
(1026, 'Windows Programlama', NULL, 3, 5, 100000, 2),
(1027, 'Mobil Programlama', NULL, 3, 5, 100000, 2),
(1028, 'Bilgisayar Güvenliğinin Temelleri', NULL, 3, 5, 100000, 2),
(1029, 'İnovasyon, Teknoloji ve Girişimcilik', NULL, 3, 5, 100000, 3),
(1030, 'Software Analysis and Design', NULL, 7, 6, 100000, 1),
(1031, 'Microcontroller Based System Design', NULL, 5, 6, 100000, 1),
(1032, 'Analysis of Algorithms', NULL, 6, 6, 100000, 1),
(1033, 'Yapay Zeka Yöntemleri', NULL, 5, 6, 100000, 1),
(1034, 'Ağ Teknolojileri', NULL, 4, 6, 100000, 1),
(1035, 'Veri Bilimine Giriş', NULL, 3, 6, 100000, 2),
(1036, 'Bilgisayar Grafikleri', NULL, 3, 6, 100000, 2),
(1037, 'Ontoloji Mühendisliği', NULL, 3, 6, 100000, 2),
(1038, 'Girişimcilik ve İş Planı Hazırlama', NULL, 3, 6, 100000, 3),
(1039, 'Software Engineering', NULL, 6, 7, 100000, 1),
(1040, 'İş Sağlığı ve Güvenliği', NULL, 6, 7, 100000, 1),
(1041, 'Görüntü İşleme', NULL, 4, 7, 100000, 1),
(1042, 'Veri Madenciliği', NULL, 4, 7, 100000, 1),
(1043, 'Simülasyon ve Modelleme', NULL, 4, 7, 100000, 2),
(1044, 'Bilgi Gösterimi', NULL, 4, 7, 100000, 2),
(1045, 'Kriptoloji', NULL, 4, 7, 100000, 2),
(1046, 'Bulut Bilişim', NULL, 4, 7, 100000, 2),
(1047, 'Pazarlama', NULL, 4, 7, 100000, 3),
(1048, 'Sosyal Biliş', NULL, 4, 7, 100000, 3),
(1049, 'Temel Bankacılık', NULL, 4, 7, 100000, 3),
(1050, 'Girişimcilik ve Etik', NULL, 4, 7, 100000, 3),
(1051, 'Genel Sosyoloji', NULL, 4, 7, 100000, 3),
(1052, 'İletişim', NULL, 4, 7, 100000, 3),
(1053, 'Yöneylem Araştırması', NULL, 7, 8, 100000, 1),
(1054, 'Computer Architecture', NULL, 7, 8, 100000, 1),
(1055, 'Sistem Analizi ve Tasarımı', NULL, 7, 8, 100000, 1),
(1056, 'Üretim Bilgi Sistemleri', NULL, 3, 8, 100000, 1),
(1057, 'Mobil Bulut Programlama', NULL, 3, 8, 100000, 2),
(1058, 'Evrimsel Hesaplama', NULL, 3, 8, 100000, 2),
(1059, 'Mikroservisler', NULL, 3, 8, 100000, 2),
(1060, 'Paralel Programlama İlkeleri', NULL, 3, 8, 100000, 2),
(1061, 'Maths I', NULL, 5, 1, 100001, 1),
(1062, 'Physics I', NULL, 5, 1, 100001, 1),
(1063, 'Algorithm and Programming I', NULL, 7, 1, 100001, 1),
(1064, 'Technical English', NULL, 4, 1, 100001, 1),
(1065, 'Maths II', NULL, 5, 2, 100001, 1),
(1066, 'Physics II', NULL, 5, 2, 100001, 1),
(1067, 'Discrete Maths', NULL, 7, 2, 100001, 1),
(1068, 'Algorithm and Programming II', NULL, 7, 2, 100001, 1),
(1069, 'Introduction to Computer Science', NULL, 3, 3, 100001, 1),
(1070, 'Differential Equations', NULL, 4, 3, 100001, 1),
(1071, 'Electricial Circuits', NULL, 5, 3, 100001, 1),
(1072, 'Data Structures', NULL, 6, 3, 100001, 1),
(1073, 'Probability and Statistics', NULL, 3, 3, 100001, 1),
(1074, 'Logic Design', NULL, 5, 3, 100001, 1),
(1075, 'Automata Theory', NULL, 6, 4, 100001, 1),
(1076, 'Numerical Systems', NULL, 6, 4, 100001, 1),
(1077, 'Digital Electronics', NULL, 5, 4, 100001, 1),
(1078, 'Programming Languages', NULL, 6, 4, 100001, 1),
(1079, 'Digital Computer Design', NULL, 6, 4, 100001, 1),
(1080, 'Modern Biology', NULL, 3, 4, 100001, 1),
(1081, 'Database Management', NULL, 7, 5, 100001, 1),
(1082, 'Object Oriented Programming', NULL, 4, 5, 100001, 1),
(1083, 'Operating Systems', NULL, 4, 5, 100001, 1),
(1084, 'Microprocessors', NULL, 6, 5, 100001, 1),
(1085, 'Computer Networks', NULL, 5, 5, 100001, 1),
(1086, 'Web Design', NULL, 3, 5, 100001, 2),
(1087, 'Windows Programming', NULL, 3, 5, 100001, 2),
(1088, 'Mobile Programming', NULL, 3, 5, 100001, 2),
(1089, 'Computer Security Essentials', NULL, 3, 5, 100001, 2),
(1090, 'Innovation and Technology', NULL, 3, 5, 100001, 3),
(1091, 'Software Analysis and Design', NULL, 7, 6, 100001, 1),
(1092, 'Microcontroller Based System Design', NULL, 5, 6, 100001, 1),
(1093, 'Analysis of Algorithms', NULL, 6, 6, 100001, 1),
(1094, 'Artificial Intelligence Methods', NULL, 5, 6, 100001, 1),
(1095, 'Network Techs', NULL, 4, 6, 100001, 2),
(1096, 'Introduction to Data Science', NULL, 3, 6, 100001, 2),
(1097, 'Computer Graphics', NULL, 3, 6, 100001, 2),
(1098, 'Ontology Engineering', NULL, 3, 6, 100001, 2),
(1099, 'Entrepreneurship and Business', NULL, 3, 6, 100001, 3),
(1100, 'Software Engineering', NULL, 6, 7, 100001, 1),
(1101, 'Work Safety', NULL, 6, 7, 100001, 1),
(1102, 'Image Processing', NULL, 4, 7, 100001, 1),
(1103, 'Data Mining', NULL, 4, 7, 100001, 1),
(1104, 'Simulation and Modeling', NULL, 4, 7, 100001, 2),
(1105, 'Information Techs', NULL, 4, 7, 100001, 2),
(1106, 'Criptology', NULL, 4, 7, 100001, 2),
(1107, 'Cloud Computing', NULL, 4, 7, 100001, 2),
(1108, 'Marketing', NULL, 4, 7, 100001, 3),
(1109, 'Social Knowledge', NULL, 4, 7, 100001, 3),
(1110, 'Finance Essentials', NULL, 4, 7, 100001, 3),
(1111, 'Social Ethic', NULL, 4, 7, 100001, 3),
(1112, 'General Sosyology', NULL, 4, 7, 100001, 3),
(1113, 'Communication', NULL, 4, 7, 100001, 3),
(1114, 'Operations Research', NULL, 7, 8, 100001, 1),
(1115, 'Computer Architecture', NULL, 7, 8, 100001, 1),
(1116, 'System Analysis and Design', NULL, 7, 8, 100001, 1),
(1117, 'Production Info Systems', NULL, 3, 8, 100001, 2),
(1118, 'Mobile Cloud Computing', NULL, 3, 8, 100001, 2),
(1119, 'Evolutionary Computing', NULL, 3, 8, 100001, 2),
(1120, 'Microservices', NULL, 3, 8, 100001, 2),
(1121, 'Parallel Programing Principles', NULL, 3, 8, 100001, 2);

INSERT INTO CURRICULUM (CurrCode, Validity, EdType, EdLang, DCode) VALUES
(100000, '2026', 0, 'EN-TR', 1000),
(100001, '2030', 0, 'EN', 1000),
(100002, '2026', 0, 'EN', 1001),
(100003, '2028', 0, 'EN', 1002),
(100004, '2032', 0, 'EN', 1003),
(100005, '2026', 0, 'EN', 1004),
(100006, '2028', 0, 'TR', 1005),
(100007, '2028', 0, 'EN', 1005),
(100008, '2030', 0, 'EN', 1007),
(100009, '2030', 0, 'EN', 1008);

INSERT INTO DEPARTMENT (DCode, DName, DOffice, DPhone, DArea, CName, ChairID, CStartDate) VALUES
(1000, 'EU Department of Computer Engineering', 'Bornova / İzmir', '2323887221', 10, 'Ege University Faculty of Engineering', 9000, '2022-09-13'),
(1001, 'METU Department of Computer Engineering', 'Çankaya / Ankara', '3127383784', 10, 'Middle East Technical University Faculty of Engineering', 9057, '2020-10-15'),
(1002, 'METU Department of Software Engineering', 'Çankaya / Ankara', '3127438484', 11, 'Middle East Technical University Faculty of Engineering', 9033, '2021-12-29'),
(1003, 'HU Department of Computer Engineering', 'Beytepe / Ankara', '3127484637', 10, 'Hacettepe University Faculty of Engineering', 9134, '2016-10-11'),
(1004, 'HU Department of ArtificiaI Intelligence Engineering', 'Beytepe / Ankara', '3127463635', 12, 'Hacettepe University Faculty of Engineering', 9151, '2022-04-23'),
(1005, 'YTU Department of Computer Engineering', 'Davutpaşa / İstanbul', '2327436643', 10, 'Yıldız Technical University Faculty of Engineering', 9070, '2017-10-10'),
(1006, 'YTU Department of Software Engineering', 'Davutpaşa / İstanbul', '2327473748', 11, 'Yıldız Technical University Faculty of Engineering', 9086, '2021-10-09'),
(1007, 'ITU Department of Computer Engineering', 'Ayazağa / İstanbul', '2126373625', 10, 'İstanbul Technical University Faculty of Engineering', 9101, '2019-06-30'),
(1008, 'ITU Department of Artificial Intelligence Engineering', 'Ayazağa / İstanbul', '2125362725', 12, 'İstanbul Technical University Faculty of Engineering', 9119, '2015-09-15');

INSERT INTO DEPT_MAJOR (MajorCode, MajorName) VALUES
(10, 'Computer Engineering'),
(11, 'Software Engineering'),
(12, 'Artificial Intelligence Engineering');

INSERT INTO FAC_MEMBER (PersonID, DCode, LecType) VALUES
(9000, 1000, 4),
(9001, 1000, 4),
(9002, 1000, 4),
(9003, 1000, 4),
(9004, 1000, 4),
(9005, 1000, 4),
(9006, 1000, 4),
(9007, 1000, 4),
(9008, 1000, 4),
(9009, 1000, 3),
(9010, 1000, 3),
(9011, 1000, 3),
(9012, 1000, 3),
(9013, 1000, 3),
(9014, 1000, 2),
(9015, 1000, 2),
(9016, 1000, 2),
(9017, 1000, 2),
(9018, 1000, 2),
(9019, 1000, 2),
(9020, 1000, 4),
(9021, 1000, 1),
(9022, 1000, 1),
(9023, 1000, 1),
(9024, 1000, 1),
(9025, 1000, 1),
(9026, 1000, 1),
(9027, 1000, 1),
(9028, 1000, 1),
(9029, 1000, 1),
(9030, 1000, 1),
(9031, 1000, 1),
(9032, 1000, 1),
(9033, 1000, 4),
(9034, NULL, 3),
(9035, NULL, 4),
(9036, NULL, 2),
(9037, NULL, 3),
(9038, NULL, 4),
(9039, NULL, 2),
(9040, NULL, 3),
(9041, NULL, 4),
(9042, NULL, 2),
(9043, NULL, 2),
(9044, NULL, 4),
(9045, NULL, 4),
(9046, NULL, 3),
(9047, NULL, 2),
(9048, NULL, 2),
(9049, NULL, 4),
(9050, NULL, 3),
(9051, NULL, 3),
(9052, NULL, 2),
(9053, NULL, 4),
(9054, NULL, 2),
(9055, NULL, 1),
(9056, NULL, 1),
(9057, NULL, 4),
(9058, NULL, 1),
(9059, NULL, 1),
(9060, NULL, 1),
(9061, NULL, 1),
(9062, NULL, 1),
(9063, NULL, 1),
(9064, NULL, 4),
(9065, NULL, 3),
(9066, NULL, 2),
(9067, NULL, 4),
(9068, NULL, 2),
(9069, NULL, 3),
(9070, NULL, 4),
(9071, NULL, 4),
(9072, NULL, 4),
(9073, NULL, 4),
(9074, NULL, 2),
(9075, NULL, 3),
(9076, NULL, 4),
(9077, NULL, 2),
(9078, NULL, 2),
(9079, NULL, 3),
(9080, NULL, 3),
(9081, NULL, 2),
(9082, NULL, 4),
(9083, NULL, 2),
(9084, NULL, 2),
(9085, NULL, 4),
(9086, NULL, 4),
(9087, NULL, 1),
(9088, NULL, 1),
(9089, NULL, 1),
(9090, NULL, 1),
(9091, NULL, 1),
(9092, NULL, 1),
(9093, NULL, 4),
(9094, NULL, 3),
(9095, NULL, 3),
(9096, NULL, 4),
(9097, NULL, 4),
(9098, NULL, 2),
(9099, NULL, 2),
(9100, NULL, 4),
(9101, NULL, 4),
(9102, NULL, 3),
(9103, NULL, 3),
(9104, NULL, 3),
(9105, NULL, 2),
(9106, NULL, 4),
(9107, NULL, 2),
(9108, NULL, 4),
(9109, NULL, 3),
(9110, NULL, 3),
(9111, NULL, 3),
(9112, NULL, 1),
(9113, NULL, 1),
(9114, NULL, 1),
(9115, NULL, 1),
(9116, NULL, 1),
(9117, NULL, 1),
(9118, NULL, 1),
(9119, NULL, 4),
(9120, NULL, 1),
(9121, NULL, 4),
(9122, NULL, 3),
(9123, NULL, 2),
(9124, NULL, 3),
(9125, NULL, 2),
(9126, NULL, 3),
(9127, NULL, 3),
(9128, NULL, 3),
(9129, NULL, 2),
(9130, NULL, 4),
(9131, NULL, 2),
(9132, NULL, 2),
(9133, NULL, 4),
(9134, NULL, 4),
(9135, NULL, 3),
(9136, NULL, 3),
(9137, NULL, 3),
(9138, NULL, 4),
(9139, NULL, 2),
(9140, NULL, 2),
(9141, NULL, 2),
(9142, NULL, 2),
(9143, NULL, 2),
(9144, NULL, 4),
(9145, NULL, 3),
(9146, NULL, 4),
(9147, NULL, 4),
(9148, NULL, 4),
(9149, NULL, 4),
(9150, NULL, 3),
(9151, NULL, 4),
(9152, NULL, 4),
(9153, NULL, 1),
(9154, NULL, 1),
(9155, NULL, 1),
(9156, NULL, 1),
(9157, NULL, 1),
(9158, NULL, 1),
(9159, NULL, 1),
(9160, NULL, 1),
(9161, NULL, 1),
(9162, NULL, 4);

INSERT INTO INSTRUCTOR (InstID) VALUES
(9000),
(9001),
(9002),
(9003),
(9004),
(9005),
(9006),
(9007),
(9008),
(9009),
(9010),
(9011),
(9012),
(9013),
(9014),
(9015),
(9016),
(9017),
(9018),
(9019),
(9020),
(9033),
(9034),
(9035),
(9036),
(9037),
(9038),
(9039),
(9040),
(9041),
(9042),
(9043),
(9044),
(9045),
(9046),
(9047),
(9048),
(9049),
(9050),
(9051),
(9052),
(9053),
(9054),
(9057),
(9064),
(9065),
(9066),
(9067),
(9068),
(9069),
(9070),
(9071),
(9072),
(9073),
(9074),
(9075),
(9076),
(9077),
(9078),
(9079),
(9080),
(9081),
(9082),
(9083),
(9084),
(9085),
(9086),
(9093),
(9094),
(9095),
(9096),
(9097),
(9098),
(9099),
(9100),
(9101),
(9102),
(9103),
(9104),
(9105),
(9106),
(9107),
(9108),
(9109),
(9110),
(9111),
(9119),
(9121),
(9122),
(9123),
(9124),
(9125),
(9126),
(9127),
(9128),
(9129),
(9130),
(9131),
(9132),
(9133),
(9134),
(9135),
(9136),
(9137),
(9138),
(9139),
(9140),
(9141),
(9142),
(9143),
(9144),
(9145),
(9146),
(9147),
(9148),
(9149),
(9150),
(9151),
(9152),
(9162);

INSERT INTO LABORATORY (SectionID, LWeekDays, LBuilding, LRoomNo) VALUES
(100155, '00100', 'Main', 6),
(100156, '01000', 'Main', 6),
(100157, '01000', 'Main', 7),
(100158, '00001', 'Main', 1),
(100159, '10000', 'Main', 6),
(100160, '00001', 'Main', 9),
(100161, '01000', 'Main', 3),
(100162, '00100', 'Main', 5),
(100163, '00100', 'Main', 3),
(100164, '01000', 'Main', 15),
(100165, '10000', 'Main', 9),
(100166, '00010', 'Main', 15),
(100167, '00001', 'Main', 4),
(100168, '10000', 'Main', 8),
(100169, '00100', 'Main', 2),
(100170, '01000', 'Main', 16),
(100171, '01000', 'Main', 7);

INSERT INTO MANDATORY (CoCode) VALUES
(1000),
(1001),
(1002),
(1003),
(1004),
(1005),
(1006),
(1007),
(1008),
(1009),
(1010),
(1011),
(1012),
(1013),
(1014),
(1015),
(1016),
(1017),
(1018),
(1019),
(1020),
(1021),
(1022),
(1023),
(1024),
(1030),
(1031),
(1032),
(1033),
(1034),
(1039),
(1040),
(1041),
(1042),
(1053),
(1054),
(1055),
(1056),
(1061),
(1062),
(1063),
(1064),
(1065),
(1066),
(1067),
(1068),
(1069),
(1070),
(1071),
(1072),
(1073),
(1074),
(1075),
(1076),
(1077),
(1078),
(1079),
(1080),
(1081),
(1082),
(1083),
(1084),
(1085),
(1091),
(1092),
(1093),
(1094),
(1100),
(1101),
(1102),
(1103),
(1114),
(1115),
(1116);

INSERT INTO N_TECHNICAL (CoCode) VALUES
(1029),
(1038),
(1047),
(1048),
(1049),
(1050),
(1051),
(1052),
(1090),
(1099),
(1108),
(1109),
(1110),
(1111),
(1112),
(1113);

INSERT INTO OPTIONAL (CoCode) VALUES
(1025),
(1026),
(1027),
(1028),
(1029),
(1035),
(1036),
(1037),
(1038),
(1043),
(1044),
(1045),
(1046),
(1047),
(1048),
(1049),
(1050),
(1051),
(1052),
(1057),
(1058),
(1059),
(1060),
(1086),
(1087),
(1088),
(1089),
(1090),
(1095),
(1096),
(1097),
(1098),
(1099),
(1104),
(1105),
(1106),
(1107),
(1108),
(1109),
(1110),
(1111),
(1112),
(1113),
(1117),
(1118),
(1119),
(1120),
(1121);

INSERT INTO PERSON (PersonID, Fname, Mname, Lname, Phone, Address) VALUES
(1000, 'Muhammet', NULL, 'Şancı', '5558111709', '23 Nisan / Nilüfer'),
(1001, 'Leman', NULL, 'Sultanova', '5477572644', 'Yaylacık / Buca'),
(1002, 'Altuğ', NULL, 'Şahin', '5325042567', 'Mavişehir / Bostanlı'),
(1003, 'Doğuş', NULL, 'Şengül', '5059558502', 'Ergene / Bornova'),
(1004, 'Murat', NULL, 'Koruk', '5085425927', 'Şükrüçavuş / Mudanya'),
(1005, 'Ahmet', NULL, 'Arslanbay', '5129853162', 'İstiklal / Gürsu'),
(1006, 'Burhan', NULL, 'Şimşek', '5507045244', 'İstiklal / Osmangazi'),
(1007, 'Hüseyin', NULL, 'Dal', '5297197359', 'Özlüce / Nilüfer'),
(1008, 'Gökhan', NULL, 'Alp', '5231255419', 'Ömerbey / Mudanya'),
(1009, 'Burak', NULL, 'Kuru', '5195181190', 'Çukur / Keles'),
(1010, 'Berkay', NULL, 'Ala', '5138029377', 'Çelebi / İznik'),
(1011, 'Rabia', NULL, 'Kuzu', '5022996146', 'Çayır / Yenişehir'),
(1012, 'Burak', NULL, 'Şef', '5041198559', 'Esenevler / Yıldırım'),
(1013, 'Cansu', NULL, 'Aksoy', '5399403953', 'Ertuğrulgazi / Keles'),
(1014, 'Azim', NULL, 'Keskin', '5229464900', 'Ertuğrul / Nilüfer'),
(1015, 'Murat', NULL, 'Leylak', '5393936913', 'Emirsultan / Karacabey'),
(1016, 'Su', NULL, 'Eda', '5309272817', 'Doğanevler / Osmangazi'),
(1017, 'Cengizhan', NULL, 'Kaya', '5546041676', 'Esenevler / Yıldırım'),
(1018, 'Yusuf', NULL, 'Sakin', '5426531969', 'Ertuğrulgazi / Keles'),
(1019, 'Burak', NULL, 'Kutus', '5432153389', 'Ertuğrul / Nilüfer'),
(1020, 'Okan', NULL, 'Özkan', '5161866394', 'Emirsultan / Karacabey'),
(1021, 'Dilara', NULL, 'Beril', '5412029117', 'Doğanevler / Osmangazi'),
(1022, 'Baran', NULL, 'Şan', '5037131337', 'Zeyniler / Yıldırım'),
(1023, 'Melike', NULL, 'Ünal', '5433016011', 'Zafer / Gürsu'),
(1024, 'Beril', NULL, 'Ece', '5245366800', 'Yenice / Keles'),
(1025, 'Murat', NULL, 'Özkan', '5151954961', 'Yeni / Yenişehir'),
(1026, 'Baran', NULL, 'Dolu', '5361208933', 'Tavşanlı / Karacabey'),
(1027, 'Nalan', NULL, 'Öz', '5415147555', 'Süleymaniye / İnegöl'),
(1028, 'Ece', NULL, 'Gürsoy', '5199965783', 'Soğukkuyu / Osmangazi'),
(1029, 'Işıl', NULL, 'Ateş', '5127245113', 'Ocaklı / Mustafakemalpaşa'),
(1030, 'Tolga', NULL, 'Kurt', '5516991570', 'Mütareke / Mudanya'),
(1031, 'Zeki', NULL, 'Kocaman', '5185552413', 'Muradiye / Orhangazi'),
(1032, 'Murat', NULL, 'Koca', '5062236483', 'Merkez / Harmancık'),
(1033, 'Sedat', NULL, 'Köse', '5049647721', 'Maksem / Osmangazi'),
(1034, 'Elif', NULL, 'Harman', '5404482309', 'Kılavuzlar / Harmancık'),
(1035, 'Nevzat', NULL, 'Öksüz', '5217434538', 'Kurtuluş / Gürsu'),
(1036, 'Esra', NULL, 'Ece', '5265209931', 'Kirazlı / Keles'),
(1037, 'Özgür', NULL, 'Ok', '5418477598', 'Karaca / Harmancık'),
(1038, 'Şule', NULL, 'Aksoy', '5081563809', 'Hürriyet / Orhangazi'),
(1039, 'Burhan', NULL, 'Dal', '5138357566', 'Hüdavendigar / Karacabey'),
(1040, 'Okan', NULL, 'Narlı', '5345018565', 'Huzur / İnegöl'),
(1041, 'Poyraz', NULL, 'Mert', '5095846121', 'Hoca Hasan / Büyükorhan'),
(1042, 'Önder', NULL, 'Yıldız', '5257652452', 'Hasanbey / Mudanya'),
(1043, 'Ali', 'Baran', 'Demir', '5284782074', 'Hamidiye / Gemlik'),
(1044, 'Burcu', NULL, 'Atmaca', '5308556157', 'Halitpaşa / Mudanya'),
(1045, 'Efe', NULL, 'Fatih', '5251791465', 'Geçit / Osmangazi'),
(1046, 'İbrahim', NULL, 'Köse', '5513153299', 'Gedikler / Büyükorhan'),
(1047, 'Hazal', NULL, 'Karataş', '5143635375', 'Gazipaşa / Orhaneli'),
(1048, 'Deniz', NULL, 'Keles', '5372704524', 'Fatih / Orhangazi'),
(1049, 'Ali', NULL, 'Hocagil', '5158139355', 'Eşrefzade / İznik'),
(1050, 'Can', NULL, 'Kara', '5312721867', 'Esentepe / Kestel'),
(1051, 'Emir', NULL, 'Keskin', '5307999677', 'Esentepe / Orhaneli'),
(1052, 'Cengiz', NULL, 'Can', '5349631537', 'Esenevler / Yıldırım'),
(1053, 'Nevzat', NULL, 'Karaalp', '5514852284', 'Ertuğrulgazi / Keles'),
(1054, 'Baran', NULL, 'Aslan', '5067404347', 'Ertuğrul / Nilüfer'),
(1055, 'Yusuf', NULL, 'Kocaman', '5256663762', 'Emirsultan / Karacabey'),
(1056, 'Önder', NULL, 'Şimşek', '5387529386', 'Doğanevler / Osmangazi'),
(1057, 'Zeki', NULL, 'Dağdeviren', '5451663313', 'Derecik / Mustafakemalpaşa'),
(1058, 'Bora', NULL, 'Alp', '5095005313', 'Cumhuriyet / Büyükorhan'),
(1059, 'Ahsen', NULL, 'Sarı', '5108666718', 'Burhaniye / İnegöl'),
(1060, 'Deniz', NULL, 'Bayak', '5533427623', 'Beşevler / Nilüfer'),
(1061, 'Kadriye', NULL, 'Konak', '5472657396', 'Beyler / İznik'),
(1062, 'Efsun', NULL, 'Menes', '5064825032', 'Ballısaray / Harmancık'),
(1063, 'İlayda', NULL, 'Kırmızı', '5431028553', 'Balaban / Yıldırım'),
(1064, 'Okan', NULL, 'Büyük', '5337346376', 'Ataevler / Nilüfer'),
(1065, 'Berkay', NULL, 'Kesik', '5388677194', 'Ata / Gemlik'),
(1066, 'Ali', NULL, 'Ünsüz', '5072795308', 'Altınşehir / Nilüfer'),
(1067, 'Yusuf', NULL, 'Kaynar', '5137193802', 'Akhisar / İnegöl'),
(1068, 'Yusuf', NULL, 'Kayıp', '5517103164', 'Ahmet Vefik Paşa / Kestel'),
(1069, 'Canperk', NULL, 'Koca', '5536703092', 'Adalet / Mustafakemalpaşa'),
(1070, 'Berkay', NULL, 'Öksüz', '5198084356', 'Halitpaşa / Mudanya'),
(1071, 'Efe', NULL, 'Taşdelen', '5177813461', 'Geçit / Osmangazi'),
(1072, 'Poyraz', NULL, 'Dağ', '5103923004', 'Gedikler / Büyükorhan'),
(1073, 'Hasan', NULL, 'Kara', '5206878188', 'Gazipaşa / Orhaneli'),
(1074, 'Cengiz', NULL, 'Döver', '5535432415', 'Fatih / Orhangazi'),
(1075, 'Emir', NULL, 'Kelek', '5439137859', 'Eşrefzade / İznik'),
(1076, 'Muhammet', NULL, 'Sefir', '5091905012', 'Esentepe / Orhaneli'),
(1077, 'Özgür', NULL, 'Gündoğan', '5272117606', 'Derecik / Mustafakemalpaşa'),
(1078, 'Efe', NULL, 'Koruk', '5462422819', 'Cumhuriyet / Büyükorhan'),
(1079, 'Selman', NULL, 'Türk', '5142154185', 'Burhaniye / İnegöl'),
(1080, 'Arif', NULL, 'Kaşdelen', '5356891396', 'Beşevler / Nilüfer'),
(1081, 'Berfin', NULL, 'Dere', '5086672535', 'Beyler / İznik'),
(1082, 'Hüseyin', NULL, 'Uyuk', '5483801919', 'Adaköy / Gürsu'),
(1083, 'Aysun', NULL, 'Kocaman', '5236699592', 'Adaköy / Mustafakemalpaşa'),
(1084, 'Sedat', NULL, 'Kara', '5467761650', '30 Ağustos / Nilüfer'),
(1085, 'Ela', NULL, 'Yeşil', '5168685897', '29 Ekim / Nilüfer'),
(1086, 'Nevzat', NULL, 'Şanlı', '5317355663', '23 Nisan / Nilüfer'),
(1087, 'Hüseyin', NULL, 'Kapya', '5204764929', '19 Mayıs / Nilüfer'),
(1088, 'Zübeyiralp', NULL, 'Güney', '5385085284', 'Şükrüçavuş / Mudanya'),
(1089, 'Reza', NULL, 'Aqobi', '5425191159', 'İstiklal / Gürsu'),
(1090, 'Fatih', NULL, 'Koçyiğit', '5294961345', 'İstiklal / Osmangazi'),
(1091, 'Ahmet', NULL, 'Mülayim', '5507032820', 'Özlüce / Nilüfer'),
(1092, 'Yiğit', NULL, 'Başdağ', '5051233530', 'Ömerbey / Mudanya'),
(1093, 'Burak', NULL, 'Aslan', '5322871114', 'Çukur / Keles'),
(1094, 'Buğra', NULL, 'Aydin', '5198157112', 'Çelebi / İznik'),
(1095, 'Talha', NULL, 'Pehlivanoğlu', '5446009594', 'Çayır / Yenişehir'),
(1096, 'Gökhan', NULL, 'Bayar', '5466042794', 'Esenevler / Yıldırım'),
(1097, 'Emin', NULL, 'Özkan', '5331482919', 'Ertuğrulgazi / Keles'),
(1098, 'Berke', NULL, 'Turgut', '5184062846', 'Ertuğrul / Nilüfer'),
(1099, 'Erdal', NULL, 'Baran', '5489527041', 'Emirsultan / Karacabey'),
(1100, 'Eren', NULL, 'Başçetin', '5106521335', 'Doğanevler / Osmangazi'),
(1101, 'Sefa', NULL, 'Hasabo', '5028613944', 'Esenevler / Yıldırım'),
(1102, 'Ezgi', NULL, 'Akçay', '5231415595', 'Ertuğrulgazi / Keles'),
(1103, 'Bager', NULL, 'Dağli', '5146727056', 'Ertuğrul / Nilüfer'),
(1104, 'Onur', NULL, 'Gümüş', '5065316258', 'Emirsultan / Karacabey'),
(1105, 'Can', NULL, 'Nacar', '5497245179', 'Doğanevler / Osmangazi'),
(1106, 'Can', 'Berk', 'Abalioğlu', '5066086712', 'Zeyniler / Yıldırım'),
(1107, 'Oğulcan', NULL, 'Kahraman', '5172099534', 'Zafer / Gürsu'),
(1108, 'Yusuf', NULL, 'Topulca', '5232723952', 'Yenice / Keles'),
(1109, 'Seydi', NULL, 'Kizilay', '5287324490', 'Yeni / Yenişehir'),
(1110, 'Rukiye', NULL, 'Karataş', '5167376143', 'Tavşanlı / Karacabey'),
(1111, 'Yusufcan', NULL, 'Tartar', '5299809207', 'Süleymaniye / İnegöl'),
(1112, 'Ekin', NULL, 'Bahadir', '5203155685', 'Soğukkuyu / Osmangazi'),
(1113, 'Oğulcan', NULL, 'Saru', '5534557832', 'Ocaklı / Mustafakemalpaşa'),
(1114, 'Muhammed', 'Emre', 'Çelebi', '5424049847', 'Mütareke / Mudanya'),
(1115, 'Burak', NULL, 'Yağiz', '5526607745', 'Muradiye / Orhangazi'),
(1116, 'Bülent', 'Ruhat', 'Elaslan', '5206617585', 'Merkez / Harmancık'),
(1117, 'Ahmet', NULL, 'Tutga', '5312428681', 'Maksem / Osmangazi'),
(1118, 'Emircan', NULL, 'Gürelek', '5245214904', 'Kılavuzlar / Harmancık'),
(1119, 'Ulaş', 'Can', 'Ergüneş', '5428265352', 'Kurtuluş / Gürsu'),
(1120, 'Özlem', NULL, 'Bektaşoğlu', '5152528922', 'Kirazlı / Keles'),
(1121, 'Ecem', NULL, 'Saygicak', '5154433267', 'Karaca / Harmancık'),
(1122, 'Ekin', NULL, 'Avcik', '5047045774', 'Hürriyet / Orhangazi'),
(1123, 'Alp', NULL, 'Filiz', '5242525286', 'Hüdavendigar / Karacabey'),
(1124, 'Arda', NULL, 'Akyüz', '5236207129', 'Huzur / İnegöl'),
(1125, 'Görkem', NULL, 'Bayraşaşahin', '5437284528', 'Hoca Hasan / Büyükorhan'),
(1126, 'Gürcan', NULL, 'Cerrahoğlu', '5391167557', 'Hasanbey / Mudanya'),
(1127, 'Yunus', NULL, 'Kaygalak', '5191655521', 'Hamidiye / Gemlik'),
(1128, 'Bariş', NULL, 'Yeğnidemir', '5037135321', 'Halitpaşa / Mudanya'),
(1129, 'Atakan', NULL, 'Günaydin', '5463326240', 'Geçit / Osmangazi'),
(1130, 'Samet', NULL, 'Doğan', '5438035702', 'Gedikler / Büyükorhan'),
(1131, 'Sinan', NULL, 'Demirel', '5212508213', 'Gazipaşa / Orhaneli'),
(1132, 'Burak', NULL, 'Özdemir', '5396226343', 'Fatih / Orhangazi'),
(1133, 'Bilal', NULL, 'Ceran', '5189182285', 'Eşrefzade / İznik'),
(1134, 'Özgür', NULL, 'Yavuz', '5399603651', 'Esentepe / Kestel'),
(1135, 'Altuğ', NULL, 'Karademir', '5253056582', 'Esentepe / Orhaneli'),
(1136, 'Zeynep', NULL, 'Kanşimşek', '5131395350', 'Esenevler / Yıldırım'),
(1137, 'Ozan', NULL, 'İnce', '5328687747', 'Ertuğrulgazi / Keles'),
(1138, 'Emir', NULL, 'Tataroğlu', '5523713228', 'Ertuğrul / Nilüfer'),
(1139, 'Mehmet', NULL, 'Yilmaz', '5322447414', 'Emirsultan / Karacabey'),
(1140, 'Ali', NULL, 'Bahar', '5455124876', 'Doğanevler / Osmangazi'),
(1141, 'Halil', NULL, 'Hasabo', '5085398230', 'Derecik / Mustafakemalpaşa'),
(1142, 'İbrahim', NULL, 'Akçay', '5522466286', 'Cumhuriyet / Büyükorhan'),
(1143, 'Ahmet', 'Hakan', 'Dağli', '5184801616', 'Burhaniye / İnegöl'),
(1144, 'Ramazan', NULL, 'Gümüş', '5469738044', 'Beşevler / Nilüfer'),
(1145, 'Diren', 'Yiğit', 'Saru', '5529967689', 'Beyler / İznik'),
(1146, 'Merve', NULL, 'Çelebi', '5177055140', 'Ballısaray / Harmancık'),
(1147, 'Riza', NULL, 'Yağiz', '5216477949', 'Balaban / Yıldırım'),
(1148, 'Asli', NULL, 'Elaslan', '5131884170', 'Ataevler / Nilüfer'),
(1149, 'Doğukan', NULL, 'Tutga', '5036756973', 'Ata / Gemlik'),
(1150, 'Metehan', NULL, 'Gürelek', '5512111711', 'Altınşehir / Nilüfer'),
(1151, 'Onur', 'Deniz', 'Kizilay', '5255454515', 'Akhisar / İnegöl'),
(1152, 'Onur', NULL, 'Karataş', '5201882425', 'Ahmet Vefik Paşa / Kestel'),
(1153, 'Damla', NULL, 'Tartar', '5487084362', 'Adalet / Mustafakemalpaşa'),
(1154, 'Gizem', 'Duygu', 'Bahadir', '5394321009', 'Halitpaşa / Mudanya'),
(1155, 'Adem', 'Buğra', 'Karataş', '5505756474', 'Geçit / Osmangazi'),
(1156, 'Utku', 'Reşat', 'Sönmez', '5457494491', 'Gedikler / Büyükorhan'),
(1157, 'Selman', NULL, 'Soydan', '5535062459', 'Gazipaşa / Orhaneli'),
(1158, 'Abdulkadir', NULL, 'Akdoğan', '5301076650', 'Fatih / Orhangazi'),
(1159, 'Hüseyin', NULL, 'Çalik', '5465231059', 'Eşrefzade / İznik'),
(1160, 'Ahmet', 'Fırat', 'Öztürk', '5247083268', 'Esentepe / Orhaneli'),
(1161, 'Sinem', NULL, 'Çopur', '5054171084', 'Derecik / Mustafakemalpaşa'),
(1162, 'Ozan', NULL, 'Çan', '5538317525', 'Cumhuriyet / Büyükorhan'),
(1163, 'Hüseyin', 'Emre', 'Güner', '5498299088', 'Burhaniye / İnegöl'),
(1164, 'Orkun', NULL, 'Akyüz', '5142243604', 'Beşevler / Nilüfer'),
(1165, 'Bahri', NULL, 'Okumuş', '5032058091', 'Beyler / İznik'),
(1166, 'Bilgekağan', NULL, 'Sarioğlu', '5095311450', 'Adaköy / Gürsu'),
(1167, 'Safiye', 'Defne', 'Eke', '5435059932', 'Adaköy / Mustafakemalpaşa'),
(1168, 'Hüseyin', NULL, 'Bahadir', '5301456879', '30 Ağustos / Nilüfer'),
(1169, 'Uğur', NULL, 'Saru', '5294222479', '29 Ekim / Nilüfer'),
(1170, 'Yasin', NULL, 'Çelebi', '5082411780', '23 Nisan / Nilüfer'),
(1171, 'Meliha', NULL, 'Taş', '5223184207', '19 Mayıs / Nilüfer'),
(1172, 'Hüseyin', NULL, 'Kargi', '5046869856', 'Şükrüçavuş / Mudanya'),
(1173, 'Ata', 'Çağın', 'Akçay', '5181834640', 'İstiklal / Gürsu'),
(1174, 'Ahmed', NULL, 'Budanoğlu', '5125744351', 'İstiklal / Osmangazi'),
(1175, 'Harun', NULL, 'Özkurt', '5541787423', 'Özlüce / Nilüfer'),
(1176, 'Berk', NULL, 'Zeytin', '5027696740', 'Ömerbey / Mudanya'),
(1177, 'Dilem', NULL, 'Uyumaz', '5266962236', 'Çukur / Keles'),
(1178, 'Betül', NULL, 'Kolbaşi', '5483519931', 'Çelebi / İznik'),
(1179, 'Bedirhan', NULL, 'Aksoy', '5065695325', 'Çayır / Yenişehir'),
(1180, 'Umut', NULL, 'Oğuz', '5256453682', 'Esenevler / Yıldırım'),
(1181, 'Hazal', NULL, 'Cebeci', '5326083848', 'Ertuğrulgazi / Keles'),
(1182, 'Mustafa', NULL, 'Şentürk', '5318175479', 'Ertuğrul / Nilüfer'),
(1183, 'Duhan', NULL, 'Yücel', '5321362778', 'Emirsultan / Karacabey'),
(1184, 'Mustafa', NULL, 'Demir', '5273224175', 'Doğanevler / Osmangazi'),
(1185, 'Ege', NULL, 'Karataş', '5334952361', 'Esenevler / Yıldırım'),
(1186, 'Mahmut', NULL, 'Boblanli', '5506957966', 'Ertuğrulgazi / Keles'),
(1187, 'Aysen', NULL, 'Alanya', '5128471774', 'Ertuğrul / Nilüfer'),
(1188, 'Yusuf', NULL, 'Çelik', '5247558770', 'Emirsultan / Karacabey'),
(1189, 'Mert', NULL, 'Bayir', '5088406912', 'Doğanevler / Osmangazi'),
(1190, 'İlker', NULL, 'Yavuz', '5303053364', 'Zeyniler / Yıldırım'),
(1191, 'Ömer', NULL, 'Dikme', '5051864442', 'Zafer / Gürsu'),
(1192, 'Pamir', NULL, 'Çengel', '5318125418', 'Yenice / Keles'),
(1193, 'Mutlu', NULL, 'Cengiz', '5282797234', 'Yeni / Yenişehir'),
(1194, 'Hasan', 'Görkem', 'Kurt', '5211114501', 'Tavşanlı / Karacabey'),
(1195, 'Göktuğ', NULL, 'Kenar', '5257608822', 'Süleymaniye / İnegöl'),
(1196, 'Şerafettin', NULL, 'Gazibaba', '5467704447', 'Soğukkuyu / Osmangazi'),
(1197, 'Mehmet', NULL, 'Nuraydin', '5354479250', 'Ocaklı / Mustafakemalpaşa'),
(1198, 'Şaban', NULL, 'Yaban', '5369572069', 'Mütareke / Mudanya'),
(1199, 'Lale', NULL, 'Yeşil', '5188806682', 'Muradiye / Orhangazi'),
(1200, 'Elif', NULL, 'Ulus', '5467607729', 'Merkez / Harmancık'),
(1201, 'Cem', NULL, 'Furat', '5495051008', 'Maksem / Osmangazi'),
(1202, 'Olga', NULL, 'Tosun', '5428082818', 'Kılavuzlar / Harmancık'),
(1203, 'Gediz', NULL, 'Demirel', '5065185736', 'Kurtuluş / Gürsu'),
(1204, 'Mustafa', NULL, 'Saklavci', '5099746990', 'Kirazlı / Keles'),
(1205, 'Oğuz', NULL, 'Pabuşçu', '5411087222', 'Karaca / Harmancık'),
(1206, 'Nilüfer', NULL, 'Akman', '5128079250', 'Hürriyet / Orhangazi'),
(1207, 'Duru', NULL, 'Tosun', '5083082291', 'Hüdavendigar / Karacabey'),
(1208, 'Furkan', NULL, 'Yilmazmiş', '5203936427', 'Huzur / İnegöl'),
(1209, 'Mertcan', NULL, 'Eroğlu', '5302159129', 'Hoca Hasan / Büyükorhan'),
(1210, 'Osman', 'Bora', 'İnci', '5289919591', 'Hasanbey / Mudanya'),
(1211, 'Yusuf', 'Bora', 'Kilinç', '5128852641', 'Hamidiye / Gemlik'),
(1212, 'Yusuf', NULL, 'Gültekin', '5518211920', 'Halitpaşa / Mudanya'),
(1213, 'Berfin', NULL, 'Gönül', '5259079726', 'Geçit / Osmangazi'),
(1214, 'Dicle', NULL, 'Bahar', '5327675727', 'Gedikler / Büyükorhan'),
(1215, 'Emir', NULL, 'Sarikoç', '5479442383', 'Gazipaşa / Orhaneli'),
(1216, 'Şevval', NULL, 'Dinç', '5359842994', 'Fatih / Orhangazi'),
(1217, 'Pinar', NULL, 'Buyruk', '5193345059', 'Eşrefzade / İznik'),
(1218, 'Abdulkadir', NULL, 'Parmaksiz', '5408978007', 'Esentepe / Kestel'),
(1219, 'Ahmet', NULL, 'Taşel', '5106472299', 'Esentepe / Orhaneli'),
(1220, 'Burak', NULL, 'Gökçen', '5113895511', 'Esenevler / Yıldırım'),
(1221, 'Ergün', 'Deniz', 'Sevinçok', '5547895846', 'Ertuğrulgazi / Keles'),
(1222, 'Sedanur', NULL, 'Özaytürk', '5394703376', 'Ertuğrul / Nilüfer'),
(1223, 'Nilay', NULL, 'Karahan', '5321411498', 'Emirsultan / Karacabey'),
(1224, 'Oğuz', NULL, 'Doğdu', '5274215625', 'Doğanevler / Osmangazi'),
(1225, 'Derya', NULL, 'Çelebi', '5526501436', 'Derecik / Mustafakemalpaşa'),
(1226, 'Hasen', NULL, 'Balta', '5415634204', 'Cumhuriyet / Büyükorhan'),
(1227, 'Seyfettin', NULL, 'Bozkurt', '5183593163', 'Burhaniye / İnegöl'),
(1228, 'Mehmet', 'Yiğit', 'Çelik', '5075375043', 'Beşevler / Nilüfer'),
(1229, 'Mehmet', 'Akif', 'Başpinar', '5276093938', 'Beyler / İznik'),
(1230, 'Uğur', 'Alp', 'Sevim', '5522444434', 'Ballısaray / Harmancık'),
(1231, 'Arda', NULL, 'Çelik', '5101908498', 'Balaban / Yıldırım'),
(1232, 'Salim', 'Taner', 'Aruk', '5208016874', 'Ataevler / Nilüfer'),
(1233, 'Feyza', 'Nur', 'Ilgaz', '5463621271', 'Ata / Gemlik'),
(1234, 'Onur', NULL, 'Ok', '5312336267', 'Altınşehir / Nilüfer'),
(1235, 'Ali', 'Yaşar', 'Ökten', '5217643296', 'Akhisar / İnegöl'),
(1236, 'Cansu', NULL, 'Yilmaz', '5515936555', 'Ahmet Vefik Paşa / Kestel'),
(1237, 'Kerem', NULL, 'Altay', '5241107870', 'Adalet / Mustafakemalpaşa'),
(1238, 'Büşra', 'Ece', 'Duran', '5374881534', 'Halitpaşa / Mudanya'),
(1239, 'Furkan', NULL, 'İkiz', '5383214983', 'Geçit / Osmangazi'),
(1240, 'Kaan', 'Berk', 'Köse', '5539386262', 'Gedikler / Büyükorhan'),
(1241, 'Berat', NULL, 'Gülsoy', '5315748943', 'Gazipaşa / Orhaneli'),
(1242, 'Mehmet', 'Can', 'Akyüz', '5291664196', 'Fatih / Orhangazi'),
(1243, 'Barkin', NULL, 'Arslan', '5356093027', 'Eşrefzade / İznik'),
(1244, 'Emre', NULL, 'Hazar', '5517427102', 'Esentepe / Orhaneli'),
(1245, 'Fatih', NULL, 'Bilgiç', '5143215288', 'Derecik / Mustafakemalpaşa'),
(1246, 'Mert', NULL, 'Abubakr', '5456997035', 'Cumhuriyet / Büyükorhan'),
(1247, 'Onur', NULL, 'Guliyev', '5486911206', 'Burhaniye / İnegöl'),
(1248, 'Erdoğan', NULL, 'Tülüce', '5217924005', 'Beşevler / Nilüfer'),
(1249, 'Baran', NULL, 'Usanmaz', '5382126045', 'Beyler / İznik'),
(1250, 'Alparslan', NULL, 'Kavuncu', '5284013561', 'Adaköy / Gürsu'),
(1251, 'Volkan', NULL, 'Akbaş', '5406646441', 'Adaköy / Mustafakemalpaşa'),
(1252, 'Talip', 'Ata', 'Akdoğan', '5342777794', '30 Ağustos / Nilüfer'),
(1253, 'Serdar', NULL, 'Baş', '5543379104', '29 Ekim / Nilüfer'),
(1254, 'Zümrüt', NULL, 'Esen', '5466353489', '23 Nisan / Nilüfer'),
(1255, 'Abdullah', NULL, 'Molla', '5249851728', '19 Mayıs / Nilüfer'),
(1256, 'Alper', NULL, 'Kurtalan', '5441682238', 'Ataevler / Nilüfer'),
(1257, 'Mehmet', NULL, 'Köse', '5543846361', 'Ata / Gemlik'),
(1258, 'İbrahim', NULL, 'Korkmaz', '5313925788', 'Altınşehir / Nilüfer'),
(1259, 'Seçkin', NULL, 'Özgün', '5382506060', 'Akhisar / İnegöl'),
(1260, 'Senanur', NULL, 'Usmanov', '5472226115', 'Ahmet Vefik Paşa / Kestel'),
(1261, 'Sedat', NULL, 'Tülüce', '5179336617', 'Adalet / Mustafakemalpaşa'),
(1262, 'Samet', 'İlhan', 'Usanmaz', '5099216301', '23 Nisan / Nilüfer'),
(1263, 'Birsen', NULL, 'Şen', '5207891142', 'Yalı / Karşıyaka'),
(1264, 'Serdal', NULL, 'Kandemir', '5278212202', 'Erzene / Bornova'),
(1265, 'Bünyamin', NULL, 'Çevik', '5358371599', 'Kazımdirik / Bornova'),
(1266, 'Özgür', NULL, 'Erkuran', '5504948605', 'Manavkuyu / Bayraklı'),
(1267, 'Ferdi', NULL, 'Tüten', '5546436437', 'Bostanlı / Karşıyaka'),
(1268, 'Reyhan', NULL, 'Öztürk', '5084838600', 'Yeşilova / Bornova'),
(1269, 'İlhan', NULL, 'Yüzbaşioğlu', '5307182868', 'Göksu / Buca'),
(1270, 'Gülşah', NULL, 'Vural', '5425651532', 'Atatürk / Bornova'),
(1271, 'Nalan', NULL, 'Yücel', '5322295179', 'Bahçelievler / Karşıyaka'),
(1272, 'Semih', NULL, 'Sönmez', '5413738831', 'Osmangazi / Bayraklı'),
(1273, 'Ergün', NULL, 'Ertekin', '5354398852', 'Mansuroğlu / Bayraklı'),
(1274, 'Fatih', NULL, 'Dede', '5462443635', 'Şemikler / Karşıyaka'),
(1275, 'Şenay', NULL, 'Uyanik', '5051064500', 'Vatan / Karabağlar'),
(1276, 'Yusuf', 'Kenan', 'Aslan', '5397918307', 'Yıldız / Buca'),
(1277, 'Çetin', NULL, 'Akbulut', '5547299138', 'İnönü / Bornova'),
(1278, 'Tarkan', NULL, 'Orhon', '5266203873', 'Mevlana / Bornova'),
(1279, 'Meral', 'Leman', 'Uz', '5291377544', 'Yunus Emre / Karabağlar'),
(1280, 'Ergün', NULL, 'Yavuz', '5282074242', 'Örnekköy / Karşıyaka'),
(1281, 'Kenan', 'Ahmet', 'Erdem', '5189351790', 'Doğanlar / Bornova'),
(1282, 'Ural', NULL, 'Kulaç', '5457632430', 'Evka 3 / Bornova'),
(1283, 'Yahya', NULL, 'Kaya', '5054396356', 'Adalet / Bayraklı'),
(1284, 'Bengü', NULL, 'Selvi', '5025386134', 'Fırat / Buca'),
(1285, 'Fatih', 'Nazmi', 'Akpinar', '5458768543', 'Günaltay / Karabağlar'),
(1286, 'Dilek', NULL, 'Abacioğlu', '5412648162', 'Yenigün / Buca'),
(1287, 'Mehmet', NULL, 'Çay', '5308011102', 'Rafet Paşa / Bornova'),
(1288, 'Tufan', 'Akın', 'Işik', '5393788033', 'Çamlıkule / Buca'),
(1289, 'Mehmet', NULL, 'Özer', '5099946537', 'Kozağaç / Buca'),
(1290, 'Turgay', 'Yılmaz', 'Özdemir', '5204313368', 'Dedebaşı / Karşıyaka'),
(1291, 'Güldehen', NULL, 'Öztürk', '5317293286', 'Buca Koop / Buca'),
(1292, 'Gökmen', NULL, 'Tahtaci', '5382713424', 'Yeşilbağlar / Buca'),
(1293, 'Bülent', NULL, 'Büyükcam', '5275631838', 'Güzelyalı / Konak'),
(1294, 'Erol', NULL, 'Kulaksiz', '5231401812', 'Yamanlar / Bayraklı'),
(1295, 'Bahri', NULL, 'Aksel', '5454602729', 'Barış / Buca'),
(1296, 'Özen', 'Özlem', 'Eroğlu', '5244076228', 'İnönü / Buca'),
(1297, 'Selma', NULL, 'Karakum', '5181712531', 'Mustafa Kemal / Buca'),
(1298, 'Tuğsem', NULL, 'Dal', '5469967173', 'Göztepe / Konak'),
(1299, 'Teslime', 'Nazlı', 'Öcal', '5232443309', 'Zübeyde Hanım / Karşıyaka'),
(1300, 'Gülçin', NULL, 'Ayhan', '5392371513', 'Onur / Balçova'),
(1301, 'İsmail', NULL, 'Yiğit', '5436559455', 'Onur / Bayraklı'),
(1302, 'Murat', NULL, 'Yarbil', '5107251291', 'Atatürk / Buca'),
(1303, 'Ebru', NULL, 'Canacankatan', '5159691967', 'Atıfbey / Gaziemir'),
(1304, 'Tümay', NULL, 'Gümüşay', '5527944058', 'Ufuk / Buca'),
(1305, 'Ahmet', NULL, 'Murt', '5482297556', 'Adatepe / Buca'),
(1306, 'Ebru', NULL, 'Halhalli', '5221701785', 'Yaylacık / Buca'),
(1307, 'Evrim', NULL, 'Uluöz', '5292659201', 'Tepekule / Bayraklı'),
(1308, 'Yasin', NULL, 'Şeyhanli', '5549397023', 'Gümüşpala / Bayraklı'),
(1309, 'Saliha', NULL, 'Çalişkantürk', '5333543595', 'Bozyaka / Karabağlar'),
(1310, 'Deniz', NULL, 'Yilmaz', '5129065767', 'Bahçelievler / Karabağlar'),
(1311, 'Belgin', NULL, 'Saraçoğlu', '5235695169', 'Kızılay / Bornova'),
(1312, 'Özlem', NULL, 'Sezer', '5275335404', 'Evka 4 / Bornova'),
(1313, 'Gonca', NULL, 'Doğan', '5094082333', 'Gazi / Gaziemir'),
(1314, 'Esra', NULL, 'Demir', '5106979496', 'Yiğitler / Buca'),
(1315, 'Seçkin', NULL, 'Kayayurt', '5502372696', 'Eğitim / Balçova'),
(1316, 'Esra', NULL, 'Sürüm', '5344064009', 'Kuruçeşme / Buca'),
(1317, 'Fatih', NULL, 'Yavaşi', '5431061428', 'Gazi Osman Paşa / Bornova'),
(1318, 'Mustafa', NULL, 'Turgut', '5504182889', 'Irmak / Gaziemir'),
(1319, 'Fevziye', NULL, 'Şen', '5241653827', 'Cumhuriyet / Karşıyaka'),
(1320, 'Mustafa', 'Arif', 'Tanrikulu', '5208862106', 'Mavişehir / Karşıyaka'),
(1321, 'Birgül', NULL, 'Barbaros', '5142733151', 'Bahriye Üçok / Karşıyaka'),
(1322, 'Özlem', NULL, 'Aldinç', '5486257910', 'Hürriyet / Buca'),
(1323, 'Fuat', NULL, 'Tekin', '5508263166', 'Cengizhan / Bayraklı'),
(1324, 'Nihal', NULL, 'Gülşan', '5057868795', 'Bahariye / Karşıyaka'),
(1325, 'Ayşegül', NULL, 'Küfeciler', '5114473591', 'Postacılar / Bayraklı'),
(1326, 'Sema', NULL, 'Almacioğlu', '5401655843', 'Emek / Bayraklı'),
(1327, 'Zafer', NULL, 'Çildir', '5292934012', 'Dokuz Eylül / Gaziemir'),
(1328, 'Nursel', NULL, 'Türkdoğan', '5367074608', 'Korutürk / Balçova'),
(1329, 'Gülperi', NULL, 'Kaya', '5456478294', 'R.Şevket İnce / Bayraklı'),
(1330, 'Bilge', NULL, 'Öner', '5376626466', 'Fuat Edip Baksı / Bayraklı'),
(1331, 'Fatih', NULL, 'Şeliman', '5506161370', 'Aksoy / Karşıyaka'),
(1332, 'Cengiz', NULL, 'Yaman', '5182451603', 'Murat Reis / Konak'),
(1333, 'Simge', NULL, 'Atik', '5494594299', 'Barbaros / Bornova'),
(1334, 'Sema', 'Nilay', 'Yiğit', '5399514119', 'Soğukkuyu / Bayraklı'),
(1335, 'Emine', NULL, 'Giray', '5483514110', 'Kazım Karabekir / Karabağlar'),
(1336, 'Rifat', 'Can', 'Yalçinkaya', '5453153649', 'Çalıkuşu / Karabağlar'),
(1337, 'Sinan', NULL, 'Kiliç', '5375515252', 'Refet Bele / Karabağlar'),
(1338, 'Latife', NULL, 'Şentürk', '5439794584', 'Donanmacı / Karşıyaka'),
(1339, 'Mehmet', NULL, 'Karabağ', '5393683038', 'Kemalpaşa / Bornova'),
(1340, 'Nurdan', NULL, 'Değirmenci', '5303198298', 'Gürpınar / Bornova'),
(1341, 'Meltem', NULL, 'Boduroğlu', '5105954716', 'Fevzi Çakmak / Balçova'),
(1342, 'Ülkühan', NULL, 'Yildiz', '5434669598', 'Peker / Karabağlar'),
(1343, 'Hasan', NULL, 'Güler', '5302008291', 'Ali Fuat Cebesoy / Karabağlar'),
(1344, 'Gülden', NULL, 'Eraslan', '5275756967', 'Ergene / Bornova'),
(1345, 'Samet', NULL, 'Üzer', '5078752969', 'Bahar / Karabağlar'),
(1346, 'Berna', NULL, 'Pişirgen', '5164379692', 'Gülyaka / Karabağlar'),
(1347, 'Özlem', NULL, 'Adanir', '5422515392', 'Çetin Emeç / Balçova'),
(1348, 'Nafiye', NULL, 'Koç', '5446264857', 'Çamlıpınar / Buca'),
(1349, 'Kenan', NULL, 'Korkmaz', '5464918449', 'İhsan Alyanak / Karabağlar'),
(1350, 'Serkan', NULL, 'Yenidoğan', '5213193899', 'Doğanay / Karabağlar'),
(1351, 'Nursel', NULL, 'Aydoğan', '5328753391', 'Akıncılar / Buca'),
(1352, 'Abdullah', NULL, 'Acarbulut', '5332329232', 'Atilla / Konak'),
(1353, 'Ergül', NULL, 'Erge', '5355611617', 'Zafertepe / Konak'),
(1354, 'Hasan', NULL, 'Erdoğan', '5346987668', 'Zafer / Bornova'),
(1355, 'Mustafa', NULL, 'Öğüt', '5058021871', 'Çankaya / Konak'),
(1356, 'Sibel', NULL, 'Aydin', '5547693382', 'Umut / Karabağlar'),
(1357, 'Fulya', NULL, 'Kuşku', '5115867298', 'Reis / Karabağlar'),
(1358, 'Vedat', NULL, 'Ekici', '5409209114', 'Mustafa Kemal / Karşıyaka'),
(1359, 'Harun', NULL, 'Aydiner', '5344679133', 'Çiçek / Bayraklı'),
(1360, 'Filiz', NULL, 'Aktaş', '5431917670', 'Vali Rahmi Bey / Buca'),
(1361, 'Nuray', NULL, 'Belgemen', '5429723653', 'Arap Hasan / Karabağlar'),
(1362, 'Şirin', NULL, 'Çetin', '5327895475', 'Hürriyet / Gaziemir'),
(1363, 'Özlem', NULL, 'Oflaz', '5336674655', 'Huzur / Narlıdere'),
(1364, 'Burcu', NULL, 'Buğrul', '5386745761', 'Sevgi / Karabağlar'),
(1365, 'Pinar', NULL, 'Baysoy', '5224053612', 'İnkılap / Buca'),
(1366, 'Hatun', NULL, 'Bükülmez', '5359442351', 'Üçkuyular / Karabağlar'),
(1367, 'Ceyda', NULL, 'Yilmaz', '5153457899', 'Goncalar / Karşıyaka'),
(1368, 'Burcu', NULL, 'Biçakçi', '5142517095', 'Naldöken / Bornova'),
(1369, 'Ayşe', NULL, 'Kara', '5041801144', 'Sarıyer / Karabağlar'),
(1370, 'Alper', NULL, 'Timurtaş', '5093037016', '2. İnönü / Narlıdere'),
(1371, 'Feyza', NULL, 'Dayar', '5175424775', 'Yeşil / Gaziemir'),
(1372, 'Murat', NULL, 'Ateş', '5137318318', 'Kültür / Konak'),
(1373, 'Mücella', NULL, 'Binboğa', '5549769890', 'Fahrettin Altay / Karabağlar'),
(1374, 'Feyzahan', NULL, 'Kiziltepe', '5543318713', 'Uğur Mumcu / Karabağlar'),
(1375, 'Şenay', NULL, 'Kaya', '5142483445', 'Ilıca / Narlıdere'),
(1376, 'Merih', NULL, 'Abseyi', '5411415316', 'Nergiz / Karşıyaka'),
(1377, 'Yusuf', NULL, 'Amirova', '5244952607', 'Ulubatlı / Konak'),
(1378, 'Arda', NULL, 'Uçan', '5158621481', 'Teleferik / Balçova'),
(1379, 'Evre', NULL, 'Öztürk', '5205157867', 'Aydoğdu / Buca'),
(1380, 'Konuralp', NULL, 'Taş', '5256609024', 'Meriç / Bornova'),
(1381, 'Kivanç', NULL, 'Ceylan', '5222024497', 'Selvili / Karabağlar'),
(1382, 'Emine', NULL, 'Kiliç', '5235957652', 'Muhittin Erener / Bayraklı'),
(1383, 'Volkan', NULL, 'Erol', '5225661273', 'Ferahlı / Konak'),
(1384, 'Nihat', NULL, 'Tayfun', '5367046125', 'Karabağlar / Karabağlar'),
(1385, 'Rengin', NULL, 'Kaya', '5136212869', 'Sevgi / Gaziemir'),
(1386, 'Emre', NULL, 'Karakurt', '5261909722', 'Tahsin Yazıcı / Karabağlar'),
(1387, 'Arife', NULL, 'Budunoğlu', '5496816898', 'Aktepe / Gaziemir'),
(1388, 'Sedat', NULL, 'Özer', '5286937137', 'Aydın / Karabağlar'),
(1389, 'Murat', NULL, 'Saygin', '5437794599', 'Gazikent / Gaziemir'),
(1390, 'Cem', NULL, 'Eryavuz', '5059719810', 'Güneşli / Konak'),
(1391, 'Erhan', NULL, 'Polat', '5276772591', 'Devrim / Karabağlar'),
(1392, 'Ömür', NULL, 'Çiçek', '5424371348', 'Koşukavak / Bornova'),
(1393, 'Yurdun', NULL, 'Yilmaz', '5147068689', 'Barış / Karabağlar'),
(1394, 'Sema', NULL, 'Çelik', '5493482432', 'Karacaoğlan / Bornova'),
(1395, 'Tuba', NULL, 'Ünsal', '5397677397', 'İnönü / Karşıyaka'),
(1396, 'Serpil', NULL, 'Alpinar', '5268595329', 'Zeytinlik / Konak'),
(1397, 'Cenk', NULL, 'Cindemir', '5251715711', 'Esenlik / Karabağlar'),
(1398, 'Taner', NULL, 'Akduman', '5148006780', 'Çay / Bayraklı'),
(1399, 'Zekeriya', NULL, 'Uyar', '5474137031', 'Mithatpaşa / Konak'),
(9000, 'Murat', 'Osman', 'Ünalır', '5325843535', 'EU Bornova / İzmir'),
(9001, 'Levent', NULL, 'Toker', '5467893738', 'EU Bornova / İzmir'),
(9002, 'Oğuz', NULL, 'Dikenelli', '5673454678', 'EU Bornova / İzmir'),
(9003, 'Yasemin', NULL, 'Topaloğlu', '5334564567', 'EU Bornova / İzmir'),
(9004, 'Aylin', NULL, 'Kantarcı', '5127899900', 'EU Bornova / İzmir'),
(9005, 'Aybars', NULL, 'Uğur', '5357653568', 'EU Bornova / İzmir'),
(9006, 'Vecdi', NULL, 'Aytaç', '5425120090', 'EU Bornova / İzmir'),
(9007, 'Özgür', NULL, 'Gümüş', '5273930087', 'EU Bornova / İzmir'),
(9008, 'Orhan', NULL, 'Dağdeviren', '5239890087', 'EU Bornova / İzmir'),
(9009, 'Rıza', 'Cenk', 'Erdur', '5367827839', 'EU Bornova / İzmir'),
(9010, 'Hasan', NULL, 'Bulut', '5223830234', 'EU Bornova / İzmir'),
(9011, 'Şebnem', NULL, 'Bora', '5273904382', 'EU Bornova / İzmir'),
(9012, 'Özgü', NULL, 'Can', '5247893627', 'EU Bornova / İzmir'),
(9013, 'Özgün', NULL, 'Yılmaz', '5356283826', 'EU Bornova / İzmir'),
(9014, 'Ahmet', NULL, 'Egesoy', '5368273273', 'EU Bornova / İzmir'),
(9015, 'Emine', NULL, 'Sezer', '5342536372', 'EU Bornova / İzmir'),
(9016, 'Birol', NULL, 'Çiloğlugil', '5493827362', 'EU Bornova / İzmir'),
(9017, 'Erdal', NULL, 'Taşçı', '5362437483', 'EU Bornova / İzmir'),
(9018, 'İsmail', NULL, 'Irmakçı', '5327283273', 'EU Bornova / İzmir'),
(9019, 'Züleyha', 'Akusta', 'Dağdeviren', '5637238283', 'EU Bornova / İzmir'),
(9020, 'Necdet', NULL, 'Budak', '5404423556', 'EU Bornova / İzmir'),
(9021, 'Oylum', NULL, 'Alatlı', '5327363829', 'EU Bornova / İzmir'),
(9022, 'Hatice', NULL, 'Uluer', '5368226383', 'EU Bornova / İzmir'),
(9023, 'Hazal', NULL, 'Türkmen', '5493038282', 'EU Bornova / İzmir'),
(9024, 'Hüseyin', NULL, 'Uyar', '5238374847', 'EU Bornova / İzmir'),
(9025, 'Beste', NULL, 'Kaysı', '5347485757', 'EU Bornova / İzmir'),
(9026, 'Erkan', NULL, 'Yaşar', '5324738374', 'EU Bornova / İzmir'),
(9027, 'Eren', NULL, 'Yıldız', '5345363749', 'EU Bornova / İzmir'),
(9028, 'Zekeriya', 'Anıl', 'Güven', '5348476374', 'EU Bornova / İzmir'),
(9029, 'Ahmet', NULL, 'Gürbüz', '5324547583', 'EU Bornova / İzmir'),
(9030, 'Sezercan', NULL, 'Tanışman', '5348394839', 'EU Bornova / İzmir'),
(9031, 'Ercan', NULL, 'Günbilek', '5352374843', 'EU Bornova / İzmir'),
(9032, 'Ege', 'Erberk', 'Uslu', '5373536374', 'EU Bornova / İzmir'),
(9033, 'İbrahim', NULL, 'Yülüce', '5364748363', 'EU Bornova / İzmir'),
(9034, 'Ulaş', NULL, 'Günay', '5187987038', 'METU Çankaya / Ankara'),
(9035, 'Hale', NULL, 'Düz', '5053755483', 'METU Çankaya / Ankara'),
(9036, 'Adem', NULL, 'Dilek', '5214134401', 'METU Çankaya / Ankara'),
(9037, 'İlker', NULL, 'Demirtaş', '5441008840', 'METU Çankaya / Ankara'),
(9038, 'Erhan', NULL, 'Kurtuluş', '5236773705', 'METU Çankaya / Ankara'),
(9039, 'Faruk', NULL, 'Karpuzoğlu', '5089069580', 'METU Çankaya / Ankara'),
(9040, 'İbrahim', NULL, 'Ergintürk', '5029862560', 'METU Çankaya / Ankara'),
(9041, 'Serkan', NULL, 'Acar', '5042415154', 'METU Çankaya / Ankara'),
(9042, 'Mahmut', NULL, 'Beyoğlu', '5175989741', 'METU Çankaya / Ankara'),
(9043, 'Esat', NULL, 'Sulhan', '5265206574', 'METU Çankaya / Ankara'),
(9044, 'Eray', NULL, 'Arslan', '5024201304', 'METU Çankaya / Ankara'),
(9045, 'Oktay', NULL, 'Nuhveren', '5518985002', 'METU Çankaya / Ankara'),
(9046, 'Deniz', NULL, 'Avcioğlu', '5407411732', 'METU Çankaya / Ankara'),
(9047, 'Osman', NULL, 'Ahiskali', '5133027260', 'METU Çankaya / Ankara'),
(9048, 'İzzet', NULL, 'Asena', '5219384006', 'METU Çankaya / Ankara'),
(9049, 'İhsan', NULL, 'Karacan', '5504327286', 'METU Çankaya / Ankara'),
(9050, 'Ural', NULL, 'Erşekerci', '5178953898', 'METU Çankaya / Ankara'),
(9051, 'Arif', NULL, 'Gölemez', '5044468116', 'METU Çankaya / Ankara'),
(9052, 'Aziz', NULL, 'Yildirim', '5217513587', 'METU Çankaya / Ankara'),
(9053, 'Hakan', NULL, 'Tohumoğlu', '5493209682', 'METU Çankaya / Ankara'),
(9054, 'Muzaffer', NULL, 'Çelik', '5547608212', 'METU Çankaya / Ankara'),
(9055, 'Oğuz', NULL, 'Bozarslan', '5539102540', 'METU Çankaya / Ankara'),
(9056, 'Mahir', NULL, 'Köşker', '5484177705', 'METU Çankaya / Ankara'),
(9057, 'Tayya', 'Alp', 'Çelik', '5444468348', 'METU Çankaya / Ankara'),
(9058, 'Erem', NULL, 'Sül', '5089187461', 'METU Çankaya / Ankara'),
(9059, 'Cihan', NULL, 'Korkmaz', '5543103597', 'METU Çankaya / Ankara'),
(9060, 'Mehmet', NULL, 'Tarkan', '5053892960', 'METU Çankaya / Ankara'),
(9061, 'Ümit', NULL, 'Duman', '5326099097', 'METU Çankaya / Ankara'),
(9062, 'Mehmet', NULL, 'Hodjaoglu', '5205493299', 'METU Çankaya / Ankara'),
(9063, 'Yasemin', NULL, 'Balli', '5084208234', 'METU Çankaya / Ankara'),
(9064, 'Mustafa', 'Verşan', 'Kök', '5102351180', 'METU Çankaya / Ankara'),
(9065, 'Nilay', NULL, 'Önde', '5469131945', 'YTU Esenler / İstanbul'),
(9066, 'Huriye', NULL, 'Lağarli', '5128395799', 'YTU Esenler / İstanbul'),
(9067, 'Merve', NULL, 'Özçay', '5136273062', 'YTU Esenler / İstanbul'),
(9068, 'Şeyma', NULL, 'Arslan', '5331562208', 'YTU Esenler / İstanbul'),
(9069, 'Selahattin', NULL, 'Akdemir', '5466644606', 'YTU Esenler / İstanbul'),
(9070, 'İlker', NULL, 'İçbay', '5495569471', 'YTU Esenler / İstanbul'),
(9071, 'Ömer', NULL, 'Akin', '5072268184', 'YTU Esenler / İstanbul'),
(9072, 'Süleyman', NULL, 'Demiröz', '5201389520', 'YTU Esenler / İstanbul'),
(9073, 'Tayfun', NULL, 'Kuyucu', '5168302981', 'YTU Esenler / İstanbul'),
(9074, 'Eser', NULL, 'Selçuk', '5164051350', 'YTU Esenler / İstanbul'),
(9075, 'Mehmet', NULL, 'İnce', '5074233412', 'YTU Esenler / İstanbul'),
(9076, 'Cihat', NULL, 'Ergülü', '5264104554', 'YTU Esenler / İstanbul'),
(9077, 'İsmail', NULL, 'Eşmen', '5112266022', 'YTU Esenler / İstanbul'),
(9078, 'Abdullah', NULL, 'Gökalp', '5255704431', 'YTU Esenler / İstanbul'),
(9079, 'Murat', NULL, 'Babacan', '5476261247', 'YTU Esenler / İstanbul'),
(9080, 'Mustafa', NULL, 'Ülger', '5248263712', 'YTU Esenler / İstanbul'),
(9081, 'Aydoğan', NULL, 'Ayvaz', '5285063517', 'YTU Esenler / İstanbul'),
(9082, 'Hamdiye', NULL, 'Elverdi', '5217752546', 'YTU Esenler / İstanbul'),
(9083, 'Kerime', NULL, 'Aydin', '5434412546', 'YTU Esenler / İstanbul'),
(9084, 'Melahat', NULL, 'Demirel', '5457997761', 'YTU Esenler / İstanbul'),
(9085, 'Uysan', NULL, 'Cimbek', '5299906366', 'YTU Esenler / İstanbul'),
(9086, 'Emrah', NULL, 'Firat', '5218155619', 'YTU Esenler / İstanbul'),
(9087, 'Hayri', NULL, 'Bahçebaşi', '5305451573', 'YTU Esenler / İstanbul'),
(9088, 'Murat', NULL, 'Dam', '5239483604', 'YTU Esenler / İstanbul'),
(9089, 'Hüseyin', NULL, 'Köroğlu', '5387032783', 'YTU Esenler / İstanbul'),
(9090, 'Selim', NULL, 'Özçelik', '5243483274', 'YTU Esenler / İstanbul'),
(9091, 'Zekeriya', NULL, 'Karaca', '5295014286', 'YTU Esenler / İstanbul'),
(9092, 'Fatih', NULL, 'Seven', '5039875336', 'YTU Esenler / İstanbul'),
(9093, 'Tamer', NULL, 'Yılmaz', '5465262544', 'YTU Esenler / İstanbul'),
(9094, 'Neval', NULL, 'Altun', '5128119764', 'ITU Ayazağa / İstanbul'),
(9095, 'Sezer', NULL, 'Büyüktaş', '5078846239', 'ITU Ayazağa / İstanbul'),
(9096, 'Özge', NULL, 'Sertkaya', '5546789990', 'ITU Ayazağa / İstanbul'),
(9097, 'Hatike', NULL, 'Öven', '5362755977', 'ITU Ayazağa / İstanbul'),
(9098, 'Özgür', NULL, 'Ustaalioğlu', '5317246437', 'ITU Ayazağa / İstanbul'),
(9099, 'Şafak', NULL, 'Yalniz', '5021458295', 'ITU Ayazağa / İstanbul'),
(9100, 'Ahmet', 'Tunç', 'Savaş', '5526088427', 'ITU Ayazağa / İstanbul'),
(9101, 'Özden', NULL, 'Yilmaz', '5073392745', 'ITU Ayazağa / İstanbul'),
(9102, 'Okan', NULL, 'Yalçin', '5325834143', 'ITU Ayazağa / İstanbul'),
(9103, 'Raziye', 'Damla', 'Bereket', '5109636559', 'ITU Ayazağa / İstanbul'),
(9104, 'Mahmut', NULL, 'Kaya', '5533475553', 'ITU Ayazağa / İstanbul'),
(9105, 'Lale', NULL, 'Pekgöz', '5522435749', 'ITU Ayazağa / İstanbul'),
(9106, 'Eyüp', NULL, 'Demir', '5485413388', 'ITU Ayazağa / İstanbul'),
(9107, 'Derya', NULL, 'Olmaz', '5171978436', 'ITU Ayazağa / İstanbul'),
(9108, 'Selahattin', NULL, 'Sevinç', '5084905293', 'ITU Ayazağa / İstanbul'),
(9109, 'Zeki', NULL, 'Merhametsiz', '5421408535', 'ITU Ayazağa / İstanbul'),
(9110, 'Ayhan', NULL, 'Çobanoğlu', '5479487460', 'ITU Ayazağa / İstanbul'),
(9111, 'Serdar', NULL, 'Şimşek', '5321844659', 'ITU Ayazağa / İstanbul'),
(9112, 'Erkan', NULL, 'Binnetoğlu', '5127965621', 'ITU Ayazağa / İstanbul'),
(9113, 'Emrah', NULL, 'Öğütmen', '5148957492', 'ITU Ayazağa / İstanbul'),
(9114, 'Erdal', NULL, 'Koç', '5111053300', 'ITU Ayazağa / İstanbul'),
(9115, 'Rahime', NULL, 'Çinkir', '5354337260', 'ITU Ayazağa / İstanbul'),
(9116, 'Gülden', 'Sinem', 'Camci', '5092562424', 'ITU Ayazağa / İstanbul'),
(9117, 'İhsan', NULL, 'Yazak', '5419816948', 'ITU Ayazağa / İstanbul'),
(9118, 'Abdul', 'Azim', 'Nizam', '5517281528', 'ITU Ayazağa / İstanbul'),
(9119, 'Öztan', NULL, 'Türkoğlu', '5372148126', 'ITU Ayazağa / İstanbul'),
(9120, 'Şenol', NULL, 'Demirkol', '5426507001', 'ITU Ayazağa / İstanbul'),
(9121, 'İsmail', NULL, 'Koyuncu', '5132708833', 'ITU Ayazağa / İstanbul'),
(9122, 'İsmail', 'Şenol', 'Akin', '5413681754', 'HU Altındağ / Ankara'),
(9123, 'Bora', NULL, 'Bozoğlan', '5364372588', 'HU Altındağ / Ankara'),
(9124, 'Hamza', NULL, 'Değirmenci', '5382085695', 'HU Altındağ / Ankara'),
(9125, 'Seda', NULL, 'Ayman', '5425821045', 'HU Altındağ / Ankara'),
(9126, 'Fatih', NULL, 'Saçli', '5336434144', 'HU Altındağ / Ankara'),
(9127, 'Uğur', NULL, 'Karakiliç', '5545124819', 'HU Altındağ / Ankara'),
(9128, 'Kemal', NULL, 'Bakanay', '5053399344', 'HU Altındağ / Ankara'),
(9129, 'Adil', NULL, 'Öztürk', '5438697970', 'HU Altındağ / Ankara'),
(9130, 'Mazlum', NULL, 'Karaköse', '5327465085', 'HU Altındağ / Ankara'),
(9131, 'Cem', 'Atakan', 'Güven', '5241923375', 'HU Altındağ / Ankara'),
(9132, 'Volkan', NULL, 'Meşe', '5183259130', 'HU Altındağ / Ankara'),
(9133, 'Muhammed', NULL, 'Yeşilova', '5203581732', 'HU Altındağ / Ankara'),
(9134, 'Erdem', NULL, 'Eşkazan', '5245004860', 'HU Altındağ / Ankara'),
(9135, 'Fatma', NULL, 'Gerdan', '5529053148', 'HU Altındağ / Ankara'),
(9136, 'Hatice', NULL, 'Mumcuoğlu', '5444216782', 'HU Altındağ / Ankara'),
(9137, 'Mehmet', 'Evren', 'Vatansever', '5141339723', 'HU Altındağ / Ankara'),
(9138, 'Atacan', NULL, 'Paköz', '5234744290', 'HU Altındağ / Ankara'),
(9139, 'Fatma', NULL, 'Atmiş', '5307218310', 'HU Altındağ / Ankara'),
(9140, 'Şadi', NULL, 'Akçali', '5332557158', 'HU Altındağ / Ankara'),
(9141, 'Gülcan', NULL, 'Fakioğlu', '5417254841', 'HU Altındağ / Ankara'),
(9142, 'Meryem', NULL, 'Yenidünya', '5307779536', 'HU Altındağ / Ankara'),
(9143, 'Kamercan', NULL, 'Anik', '5069029418', 'HU Altındağ / Ankara'),
(9144, 'Esra', NULL, 'Köseoğlu', '5418862823', 'HU Altındağ / Ankara'),
(9145, 'Şerife', 'Seçil', 'Sonay', '5427279455', 'HU Altındağ / Ankara'),
(9146, 'Zehra', NULL, 'Çeliker', '5193391529', 'HU Altındağ / Ankara'),
(9147, 'Vazir', 'Akber', 'Özdemirkiran', '5078838852', 'HU Altındağ / Ankara'),
(9148, 'Zeynep', NULL, 'Tatar', '5337733452', 'HU Altındağ / Ankara'),
(9149, 'Ali', 'Said', 'Arslan', '5021416733', 'HU Altındağ / Ankara'),
(9150, 'Murat', NULL, 'Yüce', '5191679865', 'HU Altındağ / Ankara'),
(9151, 'Utku', NULL, 'Tola', '5139135046', 'HU Altındağ / Ankara'),
(9152, 'Said', NULL, 'Güngör', '5212324722', 'HU Altındağ / Ankara'),
(9153, 'İrfan', NULL, 'Karagöz', '5204729232', 'HU Altındağ / Ankara'),
(9154, 'Halime', NULL, 'Altinboğa', '5089405524', 'HU Altındağ / Ankara'),
(9155, 'Şafak', NULL, 'Yeniçeri', '5181088645', 'HU Altındağ / Ankara'),
(9156, 'Betül', NULL, 'Işikalan', '5302399703', 'HU Altındağ / Ankara'),
(9157, 'Başak', NULL, 'Özdemir', '5269945930', 'HU Altındağ / Ankara'),
(9158, 'Zeynep', NULL, 'Gürbüz', '5546302277', 'HU Altındağ / Ankara'),
(9159, 'Ezgi', NULL, 'Kuru', '5178996723', 'HU Altındağ / Ankara'),
(9160, 'Vasfiye', NULL, 'Yurdam', '5125439816', 'HU Altındağ / Ankara'),
(9161, 'Erdem', NULL, 'Kara', '5521815874', 'HU Altındağ / Ankara'),
(9162, 'Mehmet', 'Cahit', 'Güran', '5191774385', 'HU Altındağ / Ankara');

INSERT INTO PROFFESOR (PersonID) VALUES
(9000),
(9001),
(9002),
(9003),
(9004),
(9005),
(9006),
(9007),
(9008),
(9020),
(9033),
(9035),
(9038),
(9041),
(9044),
(9045),
(9049),
(9053),
(9057),
(9064),
(9067),
(9070),
(9071),
(9072),
(9073),
(9076),
(9082),
(9085),
(9086),
(9093),
(9096),
(9097),
(9100),
(9101),
(9106),
(9108),
(9119),
(9121),
(9130),
(9133),
(9134),
(9138),
(9144),
(9146),
(9147),
(9148),
(9149),
(9151),
(9152),
(9162);

INSERT INTO RES_ASSIST (PersonID) VALUES
(9021),
(9022),
(9023),
(9024),
(9025),
(9026),
(9027),
(9028),
(9029),
(9030),
(9031),
(9032),
(9055),
(9056),
(9058),
(9059),
(9060),
(9061),
(9062),
(9063),
(9087),
(9088),
(9089),
(9090),
(9091),
(9092),
(9112),
(9113),
(9114),
(9115),
(9116),
(9117),
(9118),
(9120),
(9153),
(9154),
(9155),
(9156),
(9157),
(9158),
(9159),
(9160),
(9161);

INSERT INTO SECTION (SectionID, Semester, SecYear, CoCode) VALUES
(100000, 0, '2022', 1000),
(100001, 0, '2022', 1001),
(100002, 0, '2022', 1002),
(100003, 0, '2022', 1003),
(100004, 1, '2022', 1004),
(100005, 1, '2022', 1005),
(100006, 1, '2022', 1006),
(100007, 1, '2022', 1007),
(100008, 0, '2022', 1008),
(100009, 0, '2022', 1009),
(100010, 0, '2022', 1010),
(100011, 0, '2022', 1011),
(100012, 0, '2022', 1012),
(100013, 0, '2022', 1013),
(100014, 1, '2022', 1014),
(100015, 1, '2022', 1015),
(100016, 1, '2022', 1016),
(100017, 1, '2022', 1017),
(100018, 1, '2022', 1018),
(100019, 1, '2022', 1019),
(100020, 0, '2022', 1020),
(100021, 0, '2022', 1021),
(100022, 0, '2022', 1022),
(100023, 0, '2022', 1023),
(100024, 0, '2022', 1024),
(100025, 0, '2022', 1025),
(100026, 0, '2022', 1026),
(100027, 0, '2022', 1027),
(100028, 0, '2022', 1028),
(100029, 0, '2022', 1029),
(100030, 1, '2022', 1030),
(100031, 1, '2022', 1031),
(100032, 1, '2022', 1032),
(100033, 1, '2022', 1033),
(100034, 1, '2022', 1034),
(100035, 1, '2022', 1035),
(100036, 1, '2022', 1036),
(100037, 1, '2022', 1037),
(100038, 1, '2022', 1038),
(100039, 0, '2022', 1039),
(100040, 0, '2022', 1040),
(100041, 0, '2022', 1041),
(100042, 0, '2022', 1042),
(100043, 0, '2022', 1043),
(100044, 0, '2022', 1044),
(100045, 0, '2022', 1045),
(100046, 0, '2022', 1046),
(100047, 0, '2022', 1047),
(100048, 0, '2022', 1048),
(100049, 0, '2022', 1049),
(100050, 0, '2022', 1050),
(100051, 0, '2022', 1051),
(100052, 0, '2022', 1052),
(100053, 1, '2022', 1053),
(100054, 1, '2022', 1054),
(100055, 1, '2022', 1055),
(100056, 1, '2022', 1056),
(100057, 1, '2022', 1057),
(100058, 1, '2022', 1058),
(100059, 1, '2022', 1059),
(100060, 1, '2022', 1060),
(100061, 0, '2022', 1061),
(100062, 0, '2022', 1062),
(100063, 0, '2022', 1063),
(100064, 0, '2022', 1064),
(100065, 1, '2022', 1065),
(100066, 1, '2022', 1066),
(100067, 1, '2022', 1067),
(100068, 1, '2022', 1068),
(100069, 0, '2022', 1069),
(100070, 0, '2022', 1070),
(100071, 0, '2022', 1071),
(100072, 0, '2022', 1072),
(100073, 0, '2022', 1073),
(100074, 0, '2022', 1074),
(100075, 1, '2022', 1075),
(100076, 1, '2022', 1076),
(100077, 1, '2022', 1077),
(100078, 1, '2022', 1078),
(100079, 1, '2022', 1079),
(100080, 1, '2022', 1080),
(100081, 0, '2022', 1081),
(100082, 0, '2022', 1082),
(100083, 0, '2022', 1083),
(100084, 0, '2022', 1084),
(100085, 0, '2022', 1085),
(100086, 0, '2022', 1086),
(100087, 0, '2022', 1087),
(100088, 0, '2022', 1088),
(100089, 0, '2022', 1089),
(100090, 0, '2022', 1090),
(100091, 1, '2022', 1091),
(100092, 1, '2022', 1092),
(100093, 1, '2022', 1093),
(100094, 1, '2022', 1094),
(100095, 1, '2022', 1095),
(100096, 1, '2022', 1096),
(100097, 1, '2022', 1097),
(100098, 1, '2022', 1098),
(100099, 1, '2022', 1099),
(100100, 0, '2022', 1100),
(100101, 0, '2022', 1101),
(100102, 0, '2022', 1102),
(100103, 0, '2022', 1103),
(100104, 0, '2022', 1104),
(100105, 0, '2022', 1105),
(100106, 0, '2022', 1106),
(100107, 0, '2022', 1107),
(100108, 0, '2022', 1108),
(100109, 0, '2022', 1109),
(100110, 0, '2022', 1110),
(100111, 0, '2022', 1111),
(100112, 0, '2022', 1112),
(100113, 0, '2022', 1113),
(100114, 1, '2022', 1114),
(100115, 1, '2022', 1115),
(100116, 1, '2022', 1116),
(100117, 1, '2022', 1117),
(100118, 1, '2022', 1118),
(100119, 1, '2022', 1119),
(100120, 1, '2022', 1120),
(100121, 1, '2022', 1121),
(100155, 0, '2022', 1002),
(100156, 1, '2022', 1007),
(100157, 0, '2022', 1010),
(100158, 0, '2022', 1013),
(100159, 1, '2022', 1016),
(100160, 1, '2022', 1018),
(100161, 0, '2022', 1022),
(100162, 0, '2022', 1023),
(100163, 0, '2022', 1063),
(100164, 1, '2022', 1068),
(100165, 0, '2022', 1071),
(100166, 0, '2022', 1074),
(100167, 1, '2022', 1077),
(100168, 1, '2022', 1079),
(100169, 0, '2022', 1082),
(100170, 0, '2022', 1083),
(100171, 0, '2022', 1084);

INSERT INTO STUDENT (PersonID, DOB, DCode) VALUES
(1000, '2001-11-19', 1000),
(1001, '1999-02-23', 1000),
(1002, '1999-09-13', 1000),
(1003, '2002-08-12', 1000),
(1004, '2002-06-20', 1000),
(1005, '2002-04-17', 1000),
(1006, '2003-06-12', 1000),
(1007, '2003-03-18', 1000),
(1008, '2001-11-18', 1000),
(1009, '2003-05-25', 1000),
(1010, '2002-04-03', 1000),
(1011, '2000-03-07', 1000),
(1012, '1998-11-07', 1000),
(1013, '2001-10-10', 1000),
(1014, '2002-02-09', 1000),
(1015, '2001-03-02', 1000),
(1016, '2002-03-06', 1000),
(1017, '1999-05-03', 1000),
(1018, '1998-10-19', 1000),
(1019, '2000-01-22', 1000),
(1020, '2003-11-26', 1000),
(1021, '2001-01-19', 1000),
(1022, '2001-03-07', 1000),
(1023, '2003-07-01', 1000),
(1024, '2000-11-11', 1000),
(1025, '2002-03-27', 1000),
(1026, '2003-11-06', 1000),
(1027, '2002-12-24', 1000),
(1028, '2000-09-16', 1000),
(1029, '2000-03-06', 1000),
(1030, '2003-01-23', 1000),
(1031, '2002-10-18', 1000),
(1032, '2001-05-03', 1000),
(1033, '1998-04-16', 1000),
(1034, '2001-08-27', 1000),
(1035, '2002-05-21', 1000),
(1036, '2001-07-10', 1000),
(1037, '2003-03-18', 1000),
(1038, '1999-06-26', 1000),
(1039, '2002-05-14', 1000),
(1040, '2000-01-13', 1000),
(1041, '2003-08-08', 1000),
(1042, '2003-11-08', 1000),
(1043, '2002-11-23', 1000),
(1044, '2000-09-08', 1000),
(1045, '2000-05-27', 1000),
(1046, '2003-08-01', 1000),
(1047, '1999-05-12', 1000),
(1048, '2003-06-02', 1000),
(1049, '1998-10-07', 1000),
(1050, '2002-04-22', 1000),
(1051, '1998-08-10', 1000),
(1052, '1999-11-05', 1000),
(1053, '1999-10-02', 1000),
(1054, '2000-03-26', 1000),
(1055, '2002-04-25', 1000),
(1056, '2000-09-13', 1000),
(1057, '2003-03-21', 1000),
(1058, '2000-04-26', 1000),
(1059, '2000-01-17', 1000),
(1060, '2002-10-21', 1000),
(1061, '1998-05-09', 1000),
(1062, '1999-05-11', 1000),
(1063, '2000-10-01', 1000),
(1064, '2000-06-05', 1000),
(1065, '2000-11-16', 1000),
(1066, '2000-08-16', 1000),
(1067, '2003-09-04', 1000),
(1068, '2003-08-04', 1000),
(1069, '2003-07-17', 1000),
(1070, '2003-07-27', 1000),
(1071, '2000-06-24', 1000),
(1072, '2001-06-02', 1000),
(1073, '1998-04-11', 1000),
(1074, '1998-01-09', 1000),
(1075, '1998-04-25', 1000),
(1076, '1998-05-21', 1000),
(1077, '2001-02-02', 1000),
(1078, '1999-05-04', 1000),
(1079, '1999-07-15', 1000),
(1080, '2002-06-10', 1000),
(1081, '2002-09-06', 1000),
(1082, '1999-08-04', 1000),
(1083, '1999-09-07', 1000),
(1084, '1998-07-15', 1000),
(1085, '1999-09-08', 1000),
(1086, '1999-05-22', 1000),
(1087, '1999-10-12', 1000),
(1088, '2002-04-15', 1000),
(1089, '1998-01-27', 1000),
(1090, '1998-01-16', 1000),
(1091, '2003-11-20', 1000),
(1092, '1999-06-11', 1000),
(1093, '1998-02-21', 1000),
(1094, '1999-11-26', 1000),
(1095, '2003-09-02', 1000),
(1096, '1998-02-27', 1000),
(1097, '2000-07-18', 1000),
(1098, '1998-10-04', 1000),
(1099, '2001-05-17', 1000),
(1100, '2003-02-15', 1000),
(1101, '1999-07-20', 1000),
(1102, '2002-06-20', 1000),
(1103, '2000-06-14', 1000),
(1104, '2000-07-10', 1000),
(1105, '1998-06-12', 1000),
(1106, '1998-01-01', 1000),
(1107, '1999-05-06', 1000),
(1108, '1999-06-06', 1000),
(1109, '2003-08-23', 1000),
(1110, '2000-01-20', 1000),
(1111, '2000-11-27', 1000),
(1112, '1998-10-14', 1000),
(1113, '1999-06-22', 1000),
(1114, '2002-09-04', 1000),
(1115, '2002-10-18', 1000),
(1116, '1998-01-06', 1000),
(1117, '2003-07-13', 1000),
(1118, '2001-05-01', 1000),
(1119, '2002-02-25', 1000),
(1120, '2002-05-14', 1000),
(1121, '2002-01-02', 1000),
(1122, '2001-01-04', 1000),
(1123, '2000-06-17', 1000),
(1124, '1998-09-06', 1000),
(1125, '2002-05-20', 1000),
(1126, '1999-08-01', 1000),
(1127, '2002-04-08', 1000),
(1128, '2001-05-19', 1001),
(1129, '2003-03-22', 1001),
(1130, '1999-03-11', 1001),
(1131, '2000-09-21', 1001),
(1132, '2002-06-05', 1001),
(1133, '2003-06-18', 1001),
(1134, '1999-01-23', 1001),
(1135, '2003-03-11', 1001),
(1136, '2001-08-03', 1001),
(1137, '2003-08-14', 1002),
(1138, '2000-07-10', 1002),
(1139, '2002-02-20', 1002),
(1140, '2000-07-09', 1002),
(1141, '2001-03-03', 1002),
(1142, '1998-05-15', 1002),
(1143, '1999-03-19', 1003),
(1144, '1998-06-07', 1003),
(1145, '2003-08-02', 1003),
(1146, '2001-06-07', 1003),
(1147, '2003-10-16', 1003),
(1148, '1999-01-09', 1003),
(1149, '2000-11-24', 1003),
(1150, '2000-09-15', 1003),
(1151, '2003-04-07', 1003),
(1152, '1998-08-18', 1003),
(1153, '1999-01-26', 1003),
(1154, '1999-10-16', 1003),
(1155, '2002-04-15', 1003),
(1156, '2000-10-06', 1003),
(1157, '2003-10-11', 1003),
(1158, '2001-11-18', 1003),
(1159, '1998-10-13', 1003),
(1160, '2001-05-24', 1003),
(1161, '2003-08-26', 1003),
(1162, '2002-06-26', 1003),
(1163, '1998-03-03', 1003),
(1164, '1998-04-19', 1003),
(1165, '2002-10-18', 1003),
(1166, '2000-09-22', 1003),
(1167, '2001-07-08', 1004),
(1168, '2003-07-25', 1004),
(1169, '1999-07-19', 1004),
(1170, '2001-02-26', 1004),
(1171, '1999-05-16', 1004),
(1172, '1999-01-24', 1004),
(1173, '1999-01-12', 1004),
(1174, '1999-09-04', 1004),
(1175, '2000-05-18', 1004),
(1176, '2001-10-23', 1004),
(1177, '2003-03-26', 1004),
(1178, '2002-06-11', 1004),
(1179, '2001-11-04', 1004),
(1180, '1998-01-25', 1004),
(1181, '2001-05-08', 1004),
(1182, '2000-04-26', 1004),
(1183, '2003-08-19', 1004),
(1184, '2003-06-15', 1004),
(1185, '2002-04-22', 1004),
(1186, '1999-06-07', 1004),
(1187, '2002-03-01', 1004),
(1188, '1999-10-10', 1004),
(1189, '2000-04-23', 1004),
(1190, '1999-02-07', 1004),
(1191, '2003-09-05', 1004),
(1192, '1999-01-23', 1004),
(1193, '2000-04-01', 1004),
(1194, '1999-03-11', 1004),
(1195, '1999-06-13', 1004),
(1196, '2000-08-03', 1004),
(1197, '2000-01-05', 1004),
(1198, '2003-11-18', 1004),
(1199, '2002-09-08', 1004),
(1200, '2001-11-16', 1004),
(1201, '2000-11-23', 1004),
(1202, '2002-01-08', 1004),
(1203, '2003-07-13', 1004),
(1204, '2001-06-18', 1004),
(1205, '2003-05-15', 1004),
(1206, '2003-11-22', 1004),
(1207, '2001-07-21', 1004),
(1208, '2003-01-14', 1004),
(1209, '2003-04-12', 1004),
(1210, '2002-11-22', 1004),
(1211, '2003-03-02', 1004),
(1212, '1998-09-21', 1004),
(1213, '2002-09-17', 1004),
(1214, '2001-10-13', 1004),
(1215, '2002-02-12', 1004),
(1216, '2002-06-22', 1004),
(1217, '2001-08-10', 1004),
(1218, '2002-06-20', 1004),
(1219, '2003-01-03', 1005),
(1220, '2001-10-02', 1005),
(1221, '1998-03-11', 1005),
(1222, '1998-03-25', 1005),
(1223, '1998-07-27', 1005),
(1224, '2001-02-11', 1005),
(1225, '2003-08-14', 1005),
(1226, '2001-09-19', 1005),
(1227, '1998-06-04', 1005),
(1228, '2003-03-21', 1005),
(1229, '2000-08-24', 1005),
(1230, '2003-10-10', 1005),
(1231, '2001-11-27', 1005),
(1232, '2001-10-22', 1005),
(1233, '1998-08-09', 1005),
(1234, '2003-06-12', 1005),
(1235, '2001-08-03', 1005),
(1236, '2003-04-26', 1005),
(1237, '2002-08-09', 1005),
(1238, '2002-09-23', 1005),
(1239, '2000-07-11', 1005),
(1240, '2001-08-27', 1005),
(1241, '2000-08-22', 1005),
(1242, '2001-07-21', 1005),
(1243, '2000-06-08', 1005),
(1244, '1998-04-05', 1005),
(1245, '2002-05-07', 1005),
(1246, '2001-10-23', 1005),
(1247, '2001-09-01', 1005),
(1248, '2000-07-19', 1005),
(1249, '2001-06-10', 1005),
(1250, '2001-07-21', 1005),
(1251, '1998-05-08', 1005),
(1252, '1999-03-26', 1005),
(1253, '1998-01-11', 1005),
(1254, '1998-07-22', 1005),
(1255, '2003-07-11', 1005),
(1256, '2000-05-12', 1005),
(1257, '2000-08-06', 1005),
(1258, '1998-11-21', 1005),
(1259, '2000-03-19', 1005),
(1260, '2001-05-03', 1005),
(1261, '2000-02-09', 1005),
(1262, '1999-01-17', 1005),
(1263, '2000-04-24', 1005),
(1264, '2003-07-09', 1005),
(1265, '2003-11-22', 1005),
(1266, '1998-10-25', 1005),
(1267, '1998-02-19', 1006),
(1268, '1998-05-12', 1006),
(1269, '2002-10-01', 1006),
(1270, '1998-10-12', 1006),
(1271, '2003-06-12', 1006),
(1272, '2003-08-03', 1006),
(1273, '2001-10-02', 1006),
(1274, '2000-05-07', 1006),
(1275, '2001-02-16', 1006),
(1276, '2001-08-16', 1006),
(1277, '2001-01-14', 1006),
(1278, '1998-06-04', 1006),
(1279, '2002-05-24', 1006),
(1280, '1998-10-13', 1006),
(1281, '2001-05-15', 1006),
(1282, '2003-03-19', 1006),
(1283, '2003-08-04', 1006),
(1284, '2000-04-25', 1006),
(1285, '2002-02-16', 1006),
(1286, '1999-06-21', 1006),
(1287, '2002-11-26', 1006),
(1288, '1998-01-07', 1006),
(1289, '1998-05-17', 1006),
(1290, '2002-02-12', 1006),
(1291, '2003-03-17', 1006),
(1292, '2000-08-16', 1006),
(1293, '1999-05-04', 1006),
(1294, '2001-03-08', 1006),
(1295, '2003-10-10', 1006),
(1296, '1999-04-16', 1006),
(1297, '2002-06-26', 1006),
(1298, '2002-09-24', 1006),
(1299, '2000-04-14', 1006),
(1300, '2001-05-08', 1006),
(1301, '1999-11-18', 1006),
(1302, '2000-08-16', 1006),
(1303, '1999-02-24', 1006),
(1304, '1999-06-17', 1006),
(1305, '1998-01-14', 1006),
(1306, '2003-08-16', 1006),
(1307, '2003-02-12', 1006),
(1308, '2003-07-20', 1006),
(1309, '2000-08-04', 1006),
(1310, '1998-08-18', 1006),
(1311, '1999-09-05', 1006),
(1312, '1999-09-26', 1006),
(1313, '2000-09-27', 1006),
(1314, '2003-02-02', 1006),
(1315, '2003-05-01', 1006),
(1316, '2000-07-17', 1006),
(1317, '2001-01-22', 1006),
(1318, '2000-01-04', 1006),
(1319, '1998-04-24', 1006),
(1320, '2002-05-05', 1007),
(1321, '1998-04-15', 1007),
(1322, '1998-10-21', 1007),
(1323, '2003-03-07', 1007),
(1324, '1998-03-11', 1007),
(1325, '2002-01-07', 1007),
(1326, '1998-06-20', 1007),
(1327, '2003-07-26', 1007),
(1328, '1999-07-20', 1007),
(1329, '1998-11-06', 1007),
(1330, '2002-06-02', 1007),
(1331, '2000-02-01', 1007),
(1332, '2000-07-06', 1007),
(1333, '2002-10-01', 1007),
(1334, '1999-07-17', 1007),
(1335, '2001-06-07', 1007),
(1336, '2003-02-18', 1007),
(1337, '2001-07-04', 1007),
(1338, '2001-11-09', 1007),
(1339, '1998-02-13', 1007),
(1340, '2000-03-16', 1007),
(1341, '1998-06-24', 1007),
(1342, '1999-05-24', 1007),
(1343, '1998-01-25', 1007),
(1344, '2000-07-22', 1007),
(1345, '2002-06-26', 1007),
(1346, '2003-03-27', 1007),
(1347, '2003-08-06', 1007),
(1348, '2001-01-18', 1007),
(1349, '2002-04-20', 1007),
(1350, '1998-03-12', 1007),
(1351, '2000-07-14', 1007),
(1352, '1998-10-01', 1007),
(1353, '2003-11-04', 1007),
(1354, '1998-04-10', 1007),
(1355, '2003-11-01', 1007),
(1356, '2002-01-27', 1007),
(1357, '1999-07-12', 1007),
(1358, '2002-10-27', 1007),
(1359, '2002-02-01', 1007),
(1360, '1999-10-13', 1007),
(1361, '2001-08-22', 1007),
(1362, '2002-04-17', 1007),
(1363, '1998-04-08', 1007),
(1364, '2000-07-16', 1008),
(1365, '1998-10-04', 1008),
(1366, '2002-07-20', 1008),
(1367, '2002-05-07', 1008),
(1368, '1998-08-15', 1008),
(1369, '1999-03-03', 1008),
(1370, '1999-05-24', 1008),
(1371, '1998-06-21', 1008),
(1372, '2000-10-15', 1008),
(1373, '2001-11-06', 1008),
(1374, '2002-07-16', 1008),
(1375, '2001-07-18', 1008),
(1376, '2000-10-20', 1008),
(1377, '2002-02-07', 1008),
(1378, '2000-07-08', 1008),
(1379, '2001-01-06', 1008),
(1380, '2002-08-04', 1008),
(1381, '2001-11-19', 1008),
(1382, '2000-09-26', 1008),
(1383, '2000-09-14', 1008),
(1384, '2002-11-14', 1008),
(1385, '1998-09-02', 1008),
(1386, '2002-09-02', 1008),
(1387, '2002-03-10', 1008),
(1388, '1999-10-08', 1008),
(1389, '2002-08-12', 1008),
(1390, '2003-08-12', 1008),
(1391, '1998-02-12', 1008),
(1392, '1999-06-27', 1008),
(1393, '2003-06-16', 1008),
(1394, '1998-02-21', 1008),
(1395, '2000-01-09', 1008),
(1396, '2001-08-06', 1008),
(1397, '2001-06-13', 1008),
(1398, '1998-07-17', 1008),
(1399, '2000-10-07', 1008);

INSERT INTO STUDIES (PersonID, TheseNo, TheseName, TheseType, PubYear) VALUES
(9000, 100000, 'Machine Learning on Data Models', 'Ph.D.', '2000'),
(9000, 100001, 'Relational Database Models', 'M.Sc.', '1996'),
(9001, 100002, 'Computer Networks and Modern Systems', 'Ph.D.', '1983'),
(9001, 100003, 'Network Conflicts', 'B.Sc.', '1987'),
(9002, 100004, 'Gömülü Sistemler', 'B.Sc.', '1990'),
(9002, 100005, 'Sistem Tasarımı ve IoT', 'B.Sc.', '2009'),
(9003, 100006, 'Software Analysis and Implementation', 'Ph.D.', '1986'),
(9003, 100007, 'Algorithms and Structures', 'B.Sc.', '1991'),
(9004, 100008, 'Dağıtık Sistemler', 'Ph.D.', '1987'),
(9004, 100009, 'Çoklu Ortam Sistemleri', 'B.Sc.', '1995'),
(9005, 100010, 'Yapay Zeka ve Zeki Sistemler', 'Ph.D.', '1999'),
(9005, 100011, 'Metasezgisel Algoritmalar', 'Ph.D.', '1999'),
(9006, 100012, 'Hesaplama Yöntemleri ve Algoritmalar', 'B.Sc.', '2018'),
(9006, 100013, 'Çizge Kuramıyla Algoritma Analizi', 'B.Sc.', '1983'),
(9007, 100014, 'Nesnelerin İnterneti Optimizasyonu', 'Ph.D.', '2013'),
(9007, 100015, 'Büyük Veri Analiz Yöntemleri', 'B.Sc.', '2008'),
(9008, 100016, 'Kablosuz Ağlar', 'Ph.D.', '2001'),
(9008, 100017, 'Dağıtık Sistemler', 'Ph.D.', '2014'),
(9009, 100018, 'Yazılım Etmenleri ve Çok Etmenli Sistemler', 'B.Sc.', '2020'),
(9009, 100019, 'Anlamsal Web ve Bağlı Veri', 'M.Sc.', '2018'),
(9010, 100020, 'Bulut Bilişim', 'B.Sc.', '2015'),
(9010, 100021, 'Paralel Hesaplama', 'M.Sc.', '2017'),
(9011, 100022, 'Veri Gizliliği', 'Ph.D.', '2018'),
(9011, 100023, 'Politika Mühendisliği', 'B.Sc.', '1985'),
(9012, 100024, 'Etmen Tabanlı Benzetim', 'B.Sc.', '1984'),
(9012, 100025, 'Kendini Adapte Eden Sistemler', 'Ph.D.', '1996'),
(9013, 100026, 'Konum Farkında Sistemler', 'Ph.D.', '1989'),
(9013, 100027, 'Multi-agent Sistemler', 'B.Sc.', '2004'),
(9014, 100028, 'Model Tabanlı Yazılım Mühendisliği', 'M.Sc.', '2007'),
(9014, 100029, 'Sağlık Bilgi Sistemleri', 'Ph.D.', '1998'),
(9015, 100030, 'Yeni Nesil IoT', 'M.Sc.', '1989'),
(9015, 100031, 'Eğitimde Yapay Zeka', 'Ph.D.', '2015'),
(9016, 100032, 'Anlamsal Web', 'M.Sc.', '2011'),
(9016, 100033, 'Multithread Systems', 'Ph.D.', '1996'),
(9017, 100034, 'Data Structures and Algorithms', 'B.Sc.', '2020'),
(9017, 100035, 'PAN, WAN and LAN Systems', 'Ph.D.', '2017'),
(9018, 100036, 'Cloud Computing and IoT', 'M.Sc.', '1985'),
(9018, 100037, 'Pattern Recognition', 'B.Sc.', '1989'),
(9019, 100038, 'SaaS, IaaS and Usage Rates', 'M.Sc.', '1984'),
(9019, 100039, 'Elektrik ve Elektronik Devreleri', 'Ph.D.', '1984'),
(9020, 100040, 'Microprocessor and Circuits', 'B.Sc.', '2002'),
(9020, 100041, 'Öneri Sistemleri', 'B.Sc.', '2012'),
(9021, 100042, 'Data Engineering Methods', 'M.Sc.', '1988'),
(9021, 100043, 'Biyoinformatik ve Gen Haritaları', 'B.Sc.', '1991'),
(9022, 100044, 'Videokonferans Sistemleri', 'Ph.D.', '1988'),
(9022, 100045, 'Bilgisayar Destekli Öğrenme', 'Ph.D.', '1983'),
(9023, 100046, 'Paylaşımlı Sistemler', 'M.Sc.', '2004'),
(9023, 100047, 'Web 3.0 ve Kripto Mühendislik', 'M.Sc.', '1988'),
(9024, 100048, 'Robotik Yazılım ile Modern Diller', 'M.Sc.', '1993'),
(9024, 100049, 'Data Structures and Algorithms', 'M.Sc.', '2012'),
(9025, 100050, 'Yazılım Etmenleri ve Çok Etmenli Sistemler', 'M.Sc.', '2003'),
(9025, 100051, 'Nesneye Dayalı Yazılım Geliştirme', 'B.Sc.', '2006'),
(9026, 100052, 'Peer-to-peer Networks', 'B.Sc.', '1996'),
(9026, 100053, 'Etmen Tabanlı Benzetim', 'M.Sc.', '1997'),
(9027, 100054, 'Bulut Bilişim, Nesnelerin İnterneti', 'M.Sc.', '2000'),
(9027, 100055, 'Kural Tabanlı Akıl Yürütme Sistemleri', 'Ph.D.', '2005'),
(9028, 100056, 'Veri Bilimi ve Makine Öğrenmesi', 'M.Sc.', '2004'),
(9028, 100057, 'Model Tabanlı Yazılım Mühendisliği', 'B.Sc.', '1983'),
(9029, 100058, 'Software Agents and Multi Agent Systems', 'Ph.D.', '1990'),
(9029, 100059, 'Görüntü İşleme Sistemleri', 'Ph.D.', '1997'),
(9030, 100060, 'Ontoloji Mühendisliği ve Veri Yönetimi', 'M.Sc.', '2001'),
(9030, 100061, 'Bilgisayar Ağları ve Bulut Bilişim', 'B.Sc.', '2016'),
(9031, 100062, 'Etmen Tabanlı Simülasyon', 'M.Sc.', '2000'),
(9031, 100063, 'Çevik Yazılım Geliştirme', 'M.Sc.', '1990'),
(9032, 100064, ' Model Tabanlı Yazılım Mühendisliği', 'Ph.D.', '2010'),
(9032, 100065, 'İşletim Sistemleri Tasarımı', 'B.Sc.', '2002'),
(9033, 100066, 'Design Patterns and OOP', 'B.Sc.', '2001'),
(9033, 100067, 'Metasezgisel Algoritmalar ve Eniyileme', 'M.Sc.', '1989');

INSERT INTO SUBJECTS (CoCode, Subject) VALUES
(1000, 'Calculations'),
(1000, 'Functions'),
(1000, 'Graphics'),
(1000, 'Maths'),
(1001, 'Calculations'),
(1001, 'Newton'),
(1001, 'Physics'),
(1001, 'Weight'),
(1002, 'Algorithm'),
(1002, 'Programming'),
(1002, 'Python'),
(1002, 'Structure'),
(1003, 'English'),
(1003, 'Industry'),
(1003, 'Talking'),
(1003, 'Technic'),
(1004, 'Calculations'),
(1004, 'Functions'),
(1004, 'Graphics'),
(1004, 'Maths'),
(1005, 'Calculations'),
(1005, 'Newton'),
(1005, 'Physics'),
(1005, 'Weight'),
(1006, 'Discrete'),
(1006, 'Graph'),
(1006, 'Logic'),
(1006, 'Maths'),
(1007, 'Algorithm'),
(1007, 'Java'),
(1007, 'OOP'),
(1007, 'Programming'),
(1008, 'Bits'),
(1008, 'Calculations'),
(1008, 'Computer'),
(1008, 'CS'),
(1009, 'Calculations'),
(1009, 'Differential'),
(1009, 'Functions'),
(1009, 'Maths'),
(1010, 'Circuit'),
(1010, 'Electric'),
(1010, 'Ohm'),
(1010, 'Watt'),
(1011, 'Algorithm'),
(1011, 'Data'),
(1011, 'Model'),
(1011, 'Structure'),
(1012, 'Bayes'),
(1012, 'Calculations'),
(1012, 'Probability'),
(1012, 'Statistics'),
(1013, 'Bits'),
(1013, 'Design'),
(1013, 'Gates'),
(1013, 'Logic'),
(1014, 'Automata'),
(1014, 'Lexical'),
(1014, 'State'),
(1014, 'Transitions'),
(1015, 'Algebra'),
(1015, 'Lineer'),
(1015, 'Method'),
(1015, 'Numeric'),
(1016, 'Circuits'),
(1016, 'Digital'),
(1016, 'Electric'),
(1016, 'Electronic'),
(1017, 'C'),
(1017, 'CPP'),
(1017, 'Programming Language'),
(1017, 'Python'),
(1018, 'Computer'),
(1018, 'Design'),
(1018, 'Digital'),
(1018, 'Logic'),
(1019, 'Bio'),
(1019, 'Biology'),
(1019, 'Cell'),
(1019, 'Organisms'),
(1020, 'Database'),
(1020, 'Normalization'),
(1020, 'Relational Model'),
(1020, 'SQL'),
(1021, 'C#'),
(1021, 'Java'),
(1021, 'OOP'),
(1021, 'Programming'),
(1022, 'Calculations'),
(1022, 'Operating Systems'),
(1022, 'Process'),
(1022, 'Thread'),
(1023, 'Bits'),
(1023, 'Calculations'),
(1023, 'Microcontrollers'),
(1023, 'Microprocessors'),
(1024, 'Internet'),
(1024, 'Network'),
(1024, 'Router'),
(1024, 'Switch'),
(1025, 'CSS'),
(1025, 'Design'),
(1025, 'HTML'),
(1025, 'Web'),
(1026, 'Computer'),
(1026, 'Microsoft'),
(1026, 'Programming'),
(1026, 'Windows'),
(1027, 'Android'),
(1027, 'Cross'),
(1027, 'iOS'),
(1027, 'Mobile'),
(1028, 'Computer'),
(1028, 'Data Privacy'),
(1028, 'Security'),
(1028, 'Structure'),
(1029, 'Innovation'),
(1029, 'News'),
(1029, 'Technology'),
(1029, 'World'),
(1030, 'Analysis'),
(1030, 'Design'),
(1030, 'Implementation'),
(1030, 'Software'),
(1031, 'Embedded'),
(1031, 'Microcontrollers'),
(1031, 'Microprocessors'),
(1031, 'System'),
(1032, 'Algorithms'),
(1032, 'Analysis'),
(1032, 'Calculations'),
(1032, 'Maths'),
(1033, 'Data Science'),
(1033, 'Deep Learning'),
(1033, 'Machine Learning'),
(1033, 'NLP'),
(1034, 'Internet'),
(1034, 'IoT'),
(1034, 'Network'),
(1034, 'Technologies'),
(1035, 'Calculations'),
(1035, 'Data Science'),
(1035, 'Maths'),
(1035, 'Statistics'),
(1036, 'Computer'),
(1036, 'Design'),
(1036, 'Graphics'),
(1036, 'Structure'),
(1037, 'Calculations'),
(1037, 'Computer'),
(1037, 'Data'),
(1037, 'Ontology'),
(1038, 'Entrepreneurship'),
(1038, 'Job'),
(1038, 'Job Plan'),
(1038, 'Plan'),
(1039, 'Algorithms'),
(1039, 'Analysis'),
(1039, 'Engineering'),
(1039, 'Software'),
(1040, 'Job'),
(1040, 'Job Plan'),
(1040, 'Plan'),
(1040, 'Safety'),
(1041, 'AI'),
(1041, 'Data'),
(1041, 'Image'),
(1041, 'Process'),
(1042, 'AI'),
(1042, 'Data'),
(1042, 'Mining'),
(1042, 'Process'),
(1043, 'Computer'),
(1043, 'Graphics'),
(1043, 'Modeling'),
(1043, 'Simulation'),
(1044, 'Info'),
(1044, 'Information'),
(1044, 'Show'),
(1044, 'Technologies'),
(1045, 'Criptology'),
(1045, 'Cyber'),
(1045, 'Privacy'),
(1045, 'Security'),
(1046, 'Cloud'),
(1046, 'Cloud Computing'),
(1046, 'Computing'),
(1046, 'Network'),
(1047, 'Finance'),
(1047, 'Management'),
(1047, 'Sale'),
(1047, 'Sales'),
(1048, 'Knowledge'),
(1048, 'Psychology'),
(1048, 'Social'),
(1048, 'Socials'),
(1049, 'Banking'),
(1049, 'Finance'),
(1049, 'Money'),
(1049, 'Software'),
(1050, 'Entrepreneurship'),
(1050, 'Ethic'),
(1050, 'Ethics'),
(1050, 'Social'),
(1051, 'Culture'),
(1051, 'Knowledge'),
(1051, 'Social'),
(1051, 'Sosyology'),
(1052, 'Communication'),
(1052, 'Community'),
(1052, 'Contact'),
(1052, 'Talk'),
(1053, 'Calculations'),
(1053, 'Data'),
(1053, 'Operations'),
(1053, 'Research'),
(1054, 'Analysis'),
(1054, 'Architecture'),
(1054, 'Computer'),
(1054, 'Software'),
(1055, 'Analysis'),
(1055, 'Design'),
(1055, 'Implementation'),
(1055, 'System'),
(1056, 'Info'),
(1056, 'Knowledge'),
(1056, 'Production'),
(1056, 'System'),
(1057, 'Cloud'),
(1057, 'Cloud Computing'),
(1057, 'Mobile'),
(1057, 'Network'),
(1058, 'Analysis'),
(1058, 'Calculating'),
(1058, 'Evolution'),
(1058, 'Software'),
(1059, 'Architecture'),
(1059, 'Microservices'),
(1059, 'Programming'),
(1059, 'Software'),
(1060, 'Analysis'),
(1060, 'Parallel Programming'),
(1060, 'Programming'),
(1060, 'Software'),
(1061, 'Calculations'),
(1061, 'Functions'),
(1061, 'Graphics'),
(1061, 'Maths'),
(1062, 'Calculations'),
(1062, 'Newton'),
(1062, 'Physics'),
(1062, 'Weight'),
(1063, 'Algorithm'),
(1063, 'Programming'),
(1063, 'Python'),
(1063, 'Structure'),
(1064, 'English'),
(1064, 'Industry'),
(1064, 'Talking'),
(1064, 'Technic'),
(1065, 'Calculations'),
(1065, 'Functions'),
(1065, 'Graphics'),
(1065, 'Maths'),
(1066, 'Calculations'),
(1066, 'Newton'),
(1066, 'Physics'),
(1066, 'Weight'),
(1067, 'Discrete'),
(1067, 'Graph'),
(1067, 'Logic'),
(1067, 'Maths'),
(1068, 'Algorithm'),
(1068, 'Java'),
(1068, 'OOP'),
(1068, 'Programming'),
(1069, 'Bits'),
(1069, 'Calculations'),
(1069, 'Computer'),
(1069, 'CS'),
(1070, 'Calculations'),
(1070, 'Differential'),
(1070, 'Functions'),
(1070, 'Maths'),
(1071, 'Circuit'),
(1071, 'Electric'),
(1071, 'Ohm'),
(1071, 'Watt'),
(1072, 'Algorithm'),
(1072, 'Data'),
(1072, 'Model'),
(1072, 'Structure'),
(1073, 'Bayes'),
(1073, 'Calculations'),
(1073, 'Probability'),
(1073, 'Statistics'),
(1074, 'Bits'),
(1074, 'Design'),
(1074, 'Gates'),
(1074, 'Logic'),
(1075, 'Automata'),
(1075, 'Lexical'),
(1075, 'State'),
(1075, 'Transitions'),
(1076, 'Algebra'),
(1076, 'Lineer'),
(1076, 'Method'),
(1076, 'Numeric'),
(1077, 'Circuits'),
(1077, 'Digital'),
(1077, 'Electric'),
(1077, 'Electronic'),
(1078, 'C'),
(1078, 'CPP'),
(1078, 'Programming Language'),
(1078, 'Python'),
(1079, 'Computer'),
(1079, 'Design'),
(1079, 'Digital'),
(1079, 'Logic'),
(1080, 'Bio'),
(1080, 'Biology'),
(1080, 'Cell'),
(1080, 'Organisms'),
(1081, 'Database'),
(1081, 'Normalization'),
(1081, 'Relational Model'),
(1081, 'SQL'),
(1082, 'C#'),
(1082, 'Java'),
(1082, 'OOP'),
(1082, 'Programming'),
(1083, 'Calculations'),
(1083, 'Operating Systems'),
(1083, 'Process'),
(1083, 'Thread'),
(1084, 'Bits'),
(1084, 'Calculations'),
(1084, 'Microcontrollers'),
(1084, 'Microprocessors'),
(1085, 'Computer Network'),
(1085, 'Network'),
(1085, 'Router'),
(1085, 'Switch'),
(1086, 'CSS'),
(1086, 'Design'),
(1086, 'HTML'),
(1086, 'Web'),
(1087, 'Computer'),
(1087, 'Microsoft'),
(1087, 'Programming'),
(1087, 'Windows'),
(1088, 'Android'),
(1088, 'Cross'),
(1088, 'iOS'),
(1088, 'Mobile'),
(1089, 'Computer'),
(1089, 'Data Privacy'),
(1089, 'Security'),
(1089, 'Structure'),
(1090, 'Innovation'),
(1090, 'News'),
(1090, 'Technology'),
(1090, 'World'),
(1091, 'Analysis'),
(1091, 'Design'),
(1091, 'Implementation'),
(1091, 'Software'),
(1092, 'Embedded'),
(1092, 'Microcontrollers'),
(1092, 'Microprocessors'),
(1092, 'System'),
(1093, 'Algorithms'),
(1093, 'Analysis'),
(1093, 'Calculations'),
(1093, 'Maths'),
(1094, 'Data Science'),
(1094, 'Deep Learning'),
(1094, 'Machine Learning'),
(1094, 'NLP'),
(1095, 'Internet'),
(1095, 'IoT'),
(1095, 'Network'),
(1095, 'Technologies'),
(1096, 'Calculations'),
(1096, 'Data Science'),
(1096, 'Maths'),
(1096, 'Statistics'),
(1097, 'Computer'),
(1097, 'Design'),
(1097, 'Graphics'),
(1097, 'Structure'),
(1098, 'Calculations'),
(1098, 'Computer'),
(1098, 'Data'),
(1098, 'Ontology'),
(1099, 'Entrepreneurship'),
(1099, 'Job'),
(1099, 'Job Plan'),
(1099, 'Plan'),
(1100, 'Algorithms'),
(1100, 'Analysis'),
(1100, 'Engineering'),
(1100, 'Software'),
(1101, 'Job'),
(1101, 'Job Plan'),
(1101, 'Plan'),
(1101, 'Safety'),
(1102, 'AI'),
(1102, 'Data'),
(1102, 'Image'),
(1102, 'Process'),
(1103, 'AI'),
(1103, 'Data'),
(1103, 'Mining'),
(1103, 'Process'),
(1104, 'Computer'),
(1104, 'Graphics'),
(1104, 'Modeling'),
(1104, 'Simulation'),
(1105, 'Info'),
(1105, 'Information'),
(1105, 'Show'),
(1105, 'Technologies'),
(1106, 'Criptology'),
(1106, 'Cyber'),
(1106, 'Privacy'),
(1106, 'Security'),
(1107, 'Cloud'),
(1107, 'Cloud Computing'),
(1107, 'Computing'),
(1107, 'Network'),
(1108, 'Finance'),
(1108, 'Management'),
(1108, 'Sale'),
(1108, 'Sales'),
(1109, 'Knowledge'),
(1109, 'Psychology'),
(1109, 'Social'),
(1109, 'Socials'),
(1110, 'Banking'),
(1110, 'Finance'),
(1110, 'Money'),
(1110, 'Software'),
(1111, 'Entrepreneurship'),
(1111, 'Ethic'),
(1111, 'Ethics'),
(1111, 'Social'),
(1112, 'Culture'),
(1112, 'Knowledge'),
(1112, 'Social'),
(1112, 'Sosyology'),
(1113, 'Communication'),
(1113, 'Community'),
(1113, 'Contact'),
(1113, 'Talk'),
(1114, 'Calculations'),
(1114, 'Data'),
(1114, 'Operations'),
(1114, 'Research'),
(1115, 'Analysis'),
(1115, 'Architecture'),
(1115, 'Computer'),
(1115, 'Software'),
(1116, 'Analysis'),
(1116, 'Design'),
(1116, 'Implementation'),
(1116, 'System'),
(1117, 'Info'),
(1117, 'Knowledge'),
(1117, 'Production'),
(1117, 'System'),
(1118, 'Cloud'),
(1118, 'Cloud Computing'),
(1118, 'Mobile'),
(1118, 'Network'),
(1119, 'Analysis'),
(1119, 'Calculating'),
(1119, 'Evolution'),
(1119, 'Software'),
(1120, 'Architecture'),
(1120, 'Microservices'),
(1120, 'Programming'),
(1120, 'Software'),
(1121, 'Analysis'),
(1121, 'Parallel Programming'),
(1121, 'Programming'),
(1121, 'Software');

INSERT INTO TAKES (PersonID, SectionID, SecPoint) VALUES
(1000, 100004, 53),
(1000, 100059, 47),
(1000, 100064, 62),
(1000, 100074, 79),
(1000, 100079, 95),
(1001, 100035, 53),
(1001, 100040, 66),
(1001, 100056, 91),
(1001, 100065, 41),
(1001, 100099, 82),
(1002, 100008, 24),
(1002, 100033, 89),
(1002, 100040, 7),
(1002, 100067, 70),
(1002, 100113, 17),
(1003, 100009, 95),
(1003, 100020, 33),
(1003, 100092, 27),
(1003, 100095, 30),
(1003, 100110, 62),
(1004, 100036, 42),
(1004, 100075, 45),
(1004, 100085, 93),
(1004, 100103, 97),
(1004, 100118, 39),
(1005, 100013, 70),
(1005, 100068, 47),
(1005, 100079, 69),
(1005, 100094, 77),
(1005, 100107, 77),
(1006, 100026, 35),
(1006, 100045, 38),
(1006, 100057, 91),
(1006, 100102, 64),
(1006, 100117, 8),
(1007, 100012, 69),
(1007, 100049, 77),
(1007, 100071, 47),
(1007, 100077, 63),
(1007, 100087, 37),
(1008, 100036, 93),
(1008, 100070, 57),
(1008, 100102, 0),
(1008, 100107, 98),
(1008, 100116, 44),
(1009, 100020, 30),
(1009, 100030, 55),
(1009, 100086, 24),
(1009, 100088, 5),
(1009, 100096, 77),
(1010, 100024, 63),
(1010, 100041, 74),
(1010, 100075, 18),
(1010, 100081, 11),
(1010, 100092, 33),
(1011, 100013, 46),
(1011, 100065, 36),
(1011, 100073, 21),
(1011, 100085, 8),
(1011, 100087, 75),
(1012, 100035, 100),
(1012, 100052, 69),
(1012, 100068, 11),
(1012, 100095, 37),
(1013, 100000, 4),
(1013, 100056, 89),
(1013, 100060, 59),
(1013, 100107, 6),
(1014, 100009, 18),
(1014, 100010, 66),
(1014, 100027, 5),
(1014, 100034, 89),
(1014, 100057, 74),
(1015, 100030, 86),
(1015, 100082, 13),
(1015, 100097, 35),
(1015, 100109, 92),
(1015, 100117, 97),
(1016, 100025, 13),
(1016, 100049, 32),
(1016, 100084, 30),
(1016, 100085, 96),
(1016, 100108, 36),
(1017, 100016, 12),
(1017, 100029, 44),
(1017, 100062, 100),
(1017, 100096, 35),
(1017, 100101, 82),
(1018, 100027, 48),
(1018, 100044, 64),
(1018, 100050, 53),
(1018, 100078, 87),
(1018, 100112, 55),
(1019, 100019, 88),
(1019, 100045, 60),
(1019, 100047, 43),
(1019, 100059, 56),
(1019, 100111, 42),
(1020, 100006, 58),
(1020, 100008, 56),
(1020, 100035, 38),
(1020, 100109, 9),
(1020, 100113, 65),
(1021, 100080, 31),
(1021, 100083, 17),
(1021, 100105, 12),
(1021, 100115, 96),
(1021, 100117, 55),
(1022, 100017, 36),
(1022, 100053, 58),
(1022, 100066, 70),
(1022, 100082, 84),
(1022, 100088, 32),
(1023, 100064, 89),
(1023, 100074, 33),
(1023, 100097, 70),
(1023, 100112, 3),
(1023, 100117, 85),
(1024, 100027, 97),
(1024, 100028, 64),
(1024, 100032, 8),
(1024, 100062, 57),
(1024, 100072, 14),
(1025, 100012, 22),
(1025, 100035, 28),
(1025, 100041, 39),
(1025, 100112, 59),
(1025, 100119, 99),
(1026, 100049, 33),
(1026, 100052, 1),
(1026, 100065, 30),
(1026, 100068, 13),
(1026, 100076, 34),
(1027, 100016, 3),
(1027, 100025, 23),
(1027, 100042, 57),
(1027, 100043, 63),
(1027, 100111, 62),
(1028, 100016, 100),
(1028, 100040, 70),
(1028, 100053, 47),
(1028, 100085, 89),
(1028, 100098, 0),
(1029, 100032, 74),
(1029, 100054, 99),
(1029, 100076, 91),
(1029, 100107, 94),
(1029, 100121, 23),
(1030, 100031, 96),
(1030, 100032, 6),
(1030, 100066, 62),
(1030, 100096, 30),
(1030, 100108, 75),
(1031, 100016, 84),
(1031, 100064, 77),
(1031, 100068, 99),
(1031, 100100, 13),
(1031, 100115, 2),
(1032, 100008, 70),
(1032, 100009, 0),
(1032, 100066, 38),
(1032, 100105, 24),
(1032, 100116, 83),
(1033, 100004, 73),
(1033, 100010, 35),
(1033, 100015, 7),
(1033, 100087, 14),
(1033, 100098, 24),
(1034, 100002, 66),
(1034, 100092, 34),
(1034, 100100, 85),
(1034, 100114, 74),
(1034, 100120, 81),
(1035, 100017, 37),
(1035, 100066, 47),
(1035, 100085, 42),
(1035, 100089, 91),
(1035, 100104, 65),
(1036, 100041, 90),
(1036, 100042, 76),
(1036, 100064, 81),
(1036, 100088, 53),
(1036, 100118, 24),
(1037, 100016, 7),
(1037, 100028, 80),
(1037, 100036, 69),
(1037, 100058, 22),
(1037, 100083, 25),
(1038, 100039, 32),
(1038, 100059, 88),
(1038, 100067, 70),
(1038, 100079, 93),
(1038, 100102, 45),
(1039, 100043, 23),
(1039, 100062, 88),
(1039, 100063, 7),
(1039, 100081, 0),
(1040, 100008, 32),
(1040, 100014, 80),
(1040, 100024, 38),
(1040, 100026, 92),
(1040, 100103, 41),
(1041, 100018, 3),
(1041, 100026, 22),
(1041, 100098, 84),
(1041, 100107, 55),
(1041, 100113, 50),
(1042, 100010, 97),
(1042, 100012, 32),
(1042, 100047, 88),
(1042, 100060, 20),
(1042, 100082, 70),
(1043, 100042, 87),
(1043, 100077, 84),
(1043, 100088, 15),
(1043, 100109, 88),
(1043, 100111, 20),
(1044, 100045, 99),
(1044, 100067, 49),
(1044, 100081, 75),
(1044, 100110, 69),
(1044, 100111, 12),
(1045, 100013, 87),
(1045, 100035, 33),
(1045, 100040, 60),
(1045, 100102, 9),
(1045, 100116, 73),
(1046, 100034, 79),
(1046, 100091, 89),
(1046, 100108, 48),
(1046, 100119, 18),
(1046, 100121, 15),
(1047, 100009, 8),
(1047, 100021, 65),
(1047, 100069, 20),
(1047, 100094, 38),
(1047, 100116, 5),
(1048, 100020, 66),
(1048, 100034, 22),
(1048, 100052, 74),
(1048, 100104, 24),
(1048, 100114, 14),
(1049, 100039, 22),
(1049, 100059, 42),
(1049, 100064, 17),
(1049, 100110, 44),
(1050, 100004, 74),
(1050, 100017, 74),
(1050, 100020, 92),
(1050, 100031, 97),
(1050, 100092, 65),
(1051, 100030, 97),
(1051, 100035, 21),
(1051, 100092, 12),
(1051, 100099, 89),
(1051, 100115, 28),
(1052, 100033, 45),
(1052, 100038, 66),
(1052, 100044, 16),
(1052, 100083, 2),
(1052, 100113, 73),
(1053, 100000, 35),
(1053, 100033, 78),
(1053, 100038, 54),
(1053, 100056, 43),
(1053, 100100, 62),
(1054, 100010, 20),
(1054, 100022, 24),
(1054, 100046, 65),
(1054, 100048, 13),
(1054, 100076, 87),
(1055, 100006, 40),
(1055, 100033, 33),
(1055, 100067, 28),
(1055, 100069, 50),
(1055, 100121, 58),
(1056, 100008, 22),
(1056, 100021, 19),
(1056, 100038, 74),
(1056, 100092, 49),
(1056, 100111, 26),
(1057, 100005, 76),
(1057, 100031, 32),
(1057, 100046, 43),
(1057, 100051, 75),
(1057, 100068, 13),
(1058, 100031, 6),
(1058, 100070, 16),
(1058, 100076, 79),
(1058, 100109, 89),
(1058, 100111, 50),
(1059, 100008, 64),
(1059, 100018, 11),
(1059, 100053, 46),
(1059, 100070, 93),
(1059, 100073, 55),
(1060, 100056, 29),
(1060, 100058, 80),
(1060, 100068, 92),
(1060, 100081, 3),
(1060, 100101, 32),
(1061, 100048, 90),
(1061, 100065, 68),
(1061, 100101, 85),
(1061, 100104, 82),
(1061, 100119, 22),
(1062, 100034, 40),
(1062, 100047, 40),
(1062, 100056, 69),
(1062, 100091, 15),
(1062, 100115, 31),
(1063, 100033, 40),
(1063, 100044, 67),
(1063, 100076, 12),
(1063, 100115, 22),
(1063, 100121, 8),
(1064, 100043, 51),
(1064, 100050, 36),
(1064, 100086, 71),
(1064, 100093, 89),
(1064, 100099, 72),
(1065, 100030, 20),
(1065, 100034, 53),
(1065, 100050, 60),
(1065, 100053, 63),
(1065, 100106, 75),
(1066, 100019, 26),
(1066, 100022, 18),
(1066, 100090, 62),
(1066, 100110, 97),
(1066, 100120, 76),
(1067, 100044, 65),
(1067, 100052, 47),
(1067, 100064, 84),
(1067, 100107, 100),
(1067, 100119, 12),
(1068, 100026, 68),
(1068, 100041, 50),
(1068, 100060, 21),
(1068, 100090, 2),
(1068, 100107, 26),
(1069, 100055, 14),
(1069, 100064, 88),
(1069, 100090, 22),
(1069, 100114, 4),
(1069, 100120, 48),
(1070, 100003, 82),
(1070, 100039, 5),
(1070, 100048, 89),
(1070, 100063, 0),
(1070, 100075, 97),
(1071, 100031, 46),
(1071, 100045, 67),
(1071, 100075, 89),
(1071, 100080, 92),
(1071, 100098, 61),
(1072, 100007, 74),
(1072, 100047, 94),
(1072, 100072, 71),
(1072, 100111, 7),
(1072, 100113, 93),
(1073, 100049, 52),
(1073, 100080, 60),
(1073, 100083, 16),
(1073, 100102, 79),
(1073, 100107, 44),
(1074, 100010, 91),
(1074, 100068, 36),
(1074, 100082, 25),
(1074, 100097, 7),
(1074, 100118, 97),
(1075, 100031, 60),
(1075, 100063, 39),
(1075, 100070, 27),
(1075, 100103, 97),
(1075, 100112, 1),
(1076, 100041, 45),
(1076, 100043, 91),
(1076, 100062, 78),
(1076, 100066, 35),
(1076, 100069, 21),
(1077, 100064, 71),
(1077, 100098, 51),
(1077, 100099, 22),
(1077, 100109, 17),
(1077, 100114, 99),
(1078, 100003, 85),
(1078, 100048, 11),
(1078, 100052, 28),
(1078, 100056, 0),
(1078, 100058, 7),
(1079, 100011, 39),
(1079, 100022, 8),
(1079, 100074, 32),
(1079, 100084, 36),
(1079, 100103, 58),
(1080, 100007, 33),
(1080, 100029, 64),
(1080, 100065, 76),
(1080, 100076, 34),
(1080, 100113, 8),
(1081, 100027, 7),
(1081, 100059, 40),
(1081, 100098, 23),
(1081, 100110, 63),
(1081, 100121, 11),
(1082, 100005, 29),
(1082, 100011, 45),
(1082, 100030, 25),
(1082, 100079, 57),
(1082, 100109, 100),
(1083, 100005, 73),
(1083, 100016, 65),
(1083, 100024, 7),
(1083, 100036, 76),
(1083, 100068, 92),
(1084, 100002, 8),
(1084, 100044, 21),
(1084, 100046, 43),
(1084, 100076, 85),
(1084, 100101, 60),
(1085, 100013, 40),
(1085, 100031, 19),
(1085, 100034, 4),
(1085, 100038, 85),
(1085, 100055, 82),
(1086, 100019, 16),
(1086, 100057, 87),
(1086, 100104, 25),
(1086, 100110, 19),
(1086, 100117, 16),
(1087, 100008, 84),
(1087, 100069, 7),
(1087, 100075, 2),
(1087, 100088, 79),
(1087, 100116, 71),
(1088, 100004, 42),
(1088, 100020, 38),
(1088, 100040, 63),
(1088, 100099, 50),
(1088, 100116, 47),
(1089, 100011, 77),
(1089, 100014, 16),
(1089, 100017, 35),
(1089, 100030, 90),
(1089, 100070, 44),
(1090, 100024, 97),
(1090, 100029, 95),
(1090, 100033, 57),
(1090, 100106, 16),
(1090, 100110, 67),
(1091, 100001, 100),
(1091, 100005, 0),
(1091, 100025, 86),
(1091, 100070, 87),
(1091, 100097, 64),
(1092, 100014, 58),
(1092, 100057, 90),
(1092, 100090, 56),
(1092, 100118, 98),
(1092, 100120, 83),
(1093, 100008, 88),
(1093, 100014, 84),
(1093, 100047, 91),
(1093, 100078, 58),
(1093, 100109, 39),
(1094, 100000, 8),
(1094, 100012, 53),
(1094, 100045, 95),
(1094, 100067, 39),
(1094, 100068, 54),
(1095, 100044, 60),
(1095, 100076, 65),
(1095, 100102, 49),
(1095, 100105, 16),
(1095, 100113, 32),
(1096, 100025, 55),
(1096, 100068, 66),
(1096, 100099, 2),
(1096, 100108, 54),
(1096, 100121, 19),
(1097, 100045, 39),
(1097, 100061, 57),
(1097, 100093, 4),
(1097, 100101, 29),
(1097, 100121, 33),
(1098, 100010, 26),
(1098, 100014, 85),
(1098, 100025, 40),
(1098, 100063, 63),
(1098, 100087, 74),
(1099, 100053, 36),
(1099, 100064, 8),
(1099, 100088, 23),
(1099, 100103, 20),
(1099, 100120, 37),
(1100, 100002, 8),
(1100, 100030, 70),
(1100, 100036, 96),
(1100, 100084, 9);

INSERT INTO TAKES (PersonID, SectionID, SecPoint) VALUES
(1100, 100099, 60),
(1101, 100001, 1),
(1101, 100021, 56),
(1101, 100046, 29),
(1101, 100049, 82),
(1101, 100088, 48),
(1102, 100052, 80),
(1102, 100056, 3),
(1102, 100090, 71),
(1102, 100091, 24),
(1102, 100105, 86),
(1103, 100007, 72),
(1103, 100041, 8),
(1103, 100056, 75),
(1103, 100090, 91),
(1104, 100007, 98),
(1104, 100034, 24),
(1104, 100045, 89),
(1104, 100054, 25),
(1104, 100096, 10),
(1105, 100012, 9),
(1105, 100027, 0),
(1105, 100081, 18),
(1105, 100086, 99),
(1105, 100089, 69),
(1106, 100040, 98),
(1106, 100042, 33),
(1106, 100057, 48),
(1106, 100077, 66),
(1106, 100078, 60),
(1107, 100018, 31),
(1107, 100047, 21),
(1107, 100054, 3),
(1107, 100112, 43),
(1108, 100020, 73),
(1108, 100023, 78),
(1108, 100061, 7),
(1108, 100064, 81),
(1108, 100094, 45),
(1109, 100033, 5),
(1109, 100038, 44),
(1109, 100059, 98),
(1109, 100065, 14),
(1109, 100118, 9),
(1110, 100042, 90),
(1110, 100061, 27),
(1110, 100081, 10),
(1110, 100104, 8),
(1110, 100121, 89),
(1111, 100030, 12),
(1111, 100047, 34),
(1111, 100085, 52),
(1111, 100100, 58),
(1111, 100106, 57),
(1112, 100004, 95),
(1112, 100084, 77),
(1112, 100090, 96),
(1112, 100104, 3),
(1112, 100109, 3),
(1113, 100000, 84),
(1113, 100036, 49),
(1113, 100047, 40),
(1113, 100048, 92),
(1113, 100067, 28),
(1114, 100017, 80),
(1114, 100037, 5),
(1114, 100093, 25),
(1114, 100110, 88),
(1114, 100111, 40),
(1115, 100029, 68),
(1115, 100031, 67),
(1115, 100047, 91),
(1115, 100061, 29),
(1115, 100102, 62),
(1116, 100026, 30),
(1116, 100039, 32),
(1116, 100069, 73),
(1116, 100077, 25),
(1116, 100105, 9),
(1117, 100037, 78),
(1117, 100042, 72),
(1117, 100052, 82),
(1117, 100084, 14),
(1117, 100117, 91),
(1118, 100011, 56),
(1118, 100041, 27),
(1118, 100047, 49),
(1118, 100049, 92),
(1118, 100070, 66),
(1119, 100015, 4),
(1119, 100030, 97),
(1119, 100074, 57),
(1119, 100097, 93),
(1119, 100101, 77),
(1120, 100025, 1),
(1120, 100029, 77),
(1120, 100062, 53),
(1120, 100063, 68),
(1120, 100112, 27),
(1121, 100017, 65),
(1121, 100056, 2),
(1121, 100061, 36),
(1121, 100067, 95),
(1121, 100103, 15),
(1122, 100001, 80),
(1122, 100026, 32),
(1122, 100084, 79),
(1122, 100105, 84),
(1122, 100107, 19),
(1123, 100033, 7),
(1123, 100038, 79),
(1123, 100042, 5),
(1123, 100084, 25),
(1123, 100112, 20),
(1124, 100018, 81),
(1124, 100023, 98),
(1124, 100040, 2),
(1124, 100069, 54),
(1124, 100078, 61),
(1125, 100046, 78),
(1125, 100058, 5),
(1125, 100069, 84),
(1125, 100070, 89),
(1126, 100007, 94),
(1126, 100008, 79),
(1126, 100029, 97),
(1126, 100057, 65),
(1126, 100079, 43),
(1127, 100025, 98),
(1127, 100056, 73),
(1127, 100077, 19),
(1127, 100086, 70),
(1127, 100119, 75);

INSERT INTO TEACHES (SectionID, InstID) VALUES
(100000, 9006),
(100001, 9004),
(100002, 9007),
(100003, 9003),
(100004, 9006),
(100005, 9004),
(100006, 9006),
(100007, 9009),
(100008, 9012),
(100009, 9006),
(100010, 9015),
(100011, 9005),
(100012, 9008),
(100013, 9016),
(100014, 9009),
(100015, 9019),
(100016, 9015),
(100017, 9014),
(100018, 9015),
(100019, 9003),
(100020, 9000),
(100021, 9013),
(100022, 9010),
(100023, 9011),
(100024, 9001),
(100025, 9013),
(100026, 9000),
(100027, 9013),
(100028, 9012),
(100029, 9012),
(100030, 9003),
(100031, 9011),
(100032, 9003),
(100033, 9000),
(100034, 9001),
(100035, 9005),
(100036, 9018),
(100037, 9000),
(100038, 9018),
(100039, 9017),
(100040, 9018),
(100041, 9005),
(100042, 9000),
(100043, 9019),
(100044, 9004),
(100045, 9009),
(100046, 9008),
(100047, 9012),
(100048, 9017),
(100049, 9011),
(100050, 9004),
(100051, 9018),
(100052, 9019),
(100053, 9006),
(100054, 9016),
(100055, 9003),
(100056, 9018),
(100057, 9013),
(100058, 9014),
(100059, 9011),
(100060, 9009),
(100061, 9006),
(100062, 9004),
(100063, 9007),
(100064, 9003),
(100065, 9006),
(100066, 9004),
(100067, 9006),
(100068, 9009),
(100069, 9012),
(100070, 9006),
(100071, 9015),
(100072, 9005),
(100073, 9008),
(100074, 9016),
(100075, 9009),
(100076, 9019),
(100077, 9015),
(100078, 9014),
(100079, 9015),
(100080, 9003),
(100081, 9000),
(100082, 9013),
(100083, 9010),
(100084, 9011),
(100085, 9001),
(100086, 9013),
(100087, 9000),
(100088, 9013),
(100089, 9012),
(100090, 9012),
(100091, 9003),
(100092, 9011),
(100093, 9003),
(100094, 9000),
(100095, 9001),
(100096, 9005),
(100097, 9018),
(100098, 9000),
(100099, 9018),
(100100, 9017),
(100101, 9018),
(100102, 9005),
(100103, 9000),
(100104, 9019),
(100105, 9004),
(100106, 9009),
(100107, 9008),
(100108, 9012),
(100109, 9017),
(100110, 9011),
(100111, 9004),
(100112, 9018),
(100113, 9019),
(100114, 9006),
(100115, 9016),
(100116, 9003),
(100117, 9018),
(100118, 9013),
(100119, 9014),
(100120, 9011),
(100121, 9009);

INSERT INTO TECHNICAL (CoCode) VALUES
(1025),
(1026),
(1027),
(1028),
(1035),
(1036),
(1037),
(1043),
(1044),
(1045),
(1046),
(1057),
(1058),
(1059),
(1060),
(1086),
(1087),
(1088),
(1089),
(1095),
(1096),
(1097),
(1098),
(1104),
(1105),
(1106),
(1107),
(1117),
(1118),
(1119),
(1120),
(1121);

INSERT INTO THEORETICAL (SectionID, TWeekDays, TBuilding, TRoomNo) VALUES
(100000, '01111', 'Main', 8),
(100001, '10010', 'Main', 7),
(100002, '10110', 'Main', 1),
(100003, '01000', 'Main', 7),
(100004, '11100', 'Main', 1),
(100005, '01010', 'Main', 4),
(100006, '00100', 'Main', 15),
(100007, '00101', 'Main', 9),
(100008, '10000', 'Main', 19),
(100009, '00110', 'Main', 13),
(100010, '10011', 'Main', 8),
(100011, '01111', 'Main', 16),
(100012, '00111', 'Main', 18),
(100013, '10001', 'Main', 12),
(100014, '00111', 'Main', 5),
(100015, '01010', 'Main', 12),
(100016, '01010', 'Main', 9),
(100017, '11001', 'Main', 18),
(100018, '00010', 'Main', 4),
(100019, '11001', 'Main', 5),
(100020, '01001', 'Main', 17),
(100021, '11010', 'Main', 3),
(100022, '10010', 'Main', 18),
(100023, '01110', 'Main', 2),
(100024, '11010', 'Main', 2),
(100025, '00011', 'Main', 2),
(100026, '01111', 'Main', 16),
(100027, '10000', 'Main', 1),
(100028, '01101', 'Main', 1),
(100029, '00011', 'Main', 12),
(100030, '11101', 'Main', 7),
(100031, '00101', 'Main', 14),
(100032, '01000', 'Main', 9),
(100033, '01100', 'Main', 10),
(100034, '10000', 'Main', 15),
(100035, '10111', 'Main', 7),
(100036, '00010', 'Main', 1),
(100037, '10000', 'Main', 19),
(100038, '00100', 'Main', 12),
(100039, '00010', 'Main', 9),
(100040, '01111', 'Main', 5),
(100041, '00001', 'Main', 18),
(100042, '00101', 'Main', 15),
(100043, '10001', 'Main', 11),
(100044, '00100', 'Main', 7),
(100045, '01101', 'Main', 6),
(100046, '00111', 'Main', 13),
(100047, '10100', 'Main', 15),
(100048, '00011', 'Main', 19),
(100049, '01100', 'Main', 2),
(100050, '00100', 'Main', 5),
(100051, '10101', 'Main', 2),
(100052, '10101', 'Main', 8),
(100053, '11001', 'Main', 13),
(100054, '11000', 'Main', 6),
(100055, '01000', 'Main', 9),
(100056, '10010', 'Main', 12),
(100057, '11001', 'Main', 1),
(100058, '01000', 'Main', 5),
(100059, '10000', 'Main', 11),
(100060, '00010', 'Main', 19),
(100061, '10000', 'Main', 16),
(100062, '10110', 'Main', 10),
(100063, '01011', 'Main', 13),
(100064, '10101', 'Main', 16),
(100065, '11010', 'Main', 9),
(100066, '00100', 'Main', 14),
(100067, '10001', 'Main', 2),
(100068, '01001', 'Main', 5),
(100069, '10110', 'Main', 14),
(100070, '10000', 'Main', 9),
(100071, '00100', 'Main', 1),
(100072, '10100', 'Main', 7),
(100073, '00011', 'Main', 9),
(100074, '10111', 'Main', 2),
(100075, '00001', 'Main', 19),
(100076, '10100', 'Main', 16),
(100077, '00011', 'Main', 14),
(100078, '11100', 'Main', 13),
(100079, '11110', 'Main', 4),
(100080, '01101', 'Main', 8),
(100081, '11100', 'Main', 13),
(100082, '10000', 'Main', 12),
(100083, '00100', 'Main', 8),
(100084, '10001', 'Main', 5),
(100085, '10101', 'Main', 4),
(100086, '11110', 'Main', 16),
(100087, '11101', 'Main', 16),
(100088, '11001', 'Main', 19),
(100089, '00110', 'Main', 10),
(100090, '01000', 'Main', 13),
(100091, '11101', 'Main', 4),
(100092, '11010', 'Main', 19),
(100093, '00011', 'Main', 5),
(100094, '01001', 'Main', 6),
(100095, '01101', 'Main', 18),
(100096, '10000', 'Main', 8),
(100097, '01111', 'Main', 16),
(100098, '01010', 'Main', 18),
(100099, '10001', 'Main', 19),
(100100, '01011', 'Main', 15),
(100101, '10100', 'Main', 4),
(100102, '01110', 'Main', 14),
(100103, '00110', 'Main', 7),
(100104, '10010', 'Main', 3),
(100105, '11000', 'Main', 14),
(100106, '10100', 'Main', 8),
(100107, '11100', 'Main', 9),
(100108, '01011', 'Main', 16),
(100109, '00001', 'Main', 10),
(100110, '01011', 'Main', 17),
(100111, '00100', 'Main', 3),
(100112, '10111', 'Main', 14),
(100113, '00111', 'Main', 6),
(100114, '11011', 'Main', 14),
(100115, '00110', 'Main', 13),
(100116, '11100', 'Main', 19),
(100117, '11001', 'Main', 14),
(100118, '00010', 'Main', 5),
(100119, '01100', 'Main', 14),
(100120, '10101', 'Main', 12),
(100121, '10101', 'Main', 7);