Insertions.sql

use PostGradOffice
go


--Postgrads

INSERT INTO PostGradUser (email,password) VALUES ('essam.elhalawany@guc.edu.eg','strongP12')
INSERT INTO Admin VALUES (1)
INSERT INTO PostGradUser (email,password) VALUES ('mohamed.salah@guc.edu.eg','mo_091223')
INSERT INTO NonGucianStudent VALUES (2,'Mohamed','Salah','Mst','MET','12,heli street',0.7)
INSERT INTO PostGradUser (email,password) VALUES ('ahmed.metwally@guc.egu.eg','mido123')
INSERT INTO GucianStudent VALUES (3,'Ahmed','Metwally','Mst','IET','12 Abdelmonem riyad',1.3,0198)
INSERT INTO PostGradUser (email,password) VALUES ('marwan.fathallah@guc.edu.eg','sayadlayly')
INSERT INTO Supervisor VALUES (4,'Marwan Fathallah','MET')

INSERT INTO PostGradUser (email,password) VALUES ('kirollos.wageeh@guc.edu.eg','floh67')
INSERT INTO Admin VALUES (5)
INSERT INTO PostGradUser (email,password) VALUES ('amir.serag@guc.edu.eg','miroo980')
INSERT INTO NonGucianStudent VALUES (6,'Amir','Serag','Mst','IET','9,kafr abdo',0.9)
INSERT INTO PostGradUser (email,password) VALUES ('gamal.kamal@guc.egu.eg','mido123')
INSERT INTO GucianStudent VALUES (7,'Gamal','Kamal','PHD','Civil','12 mosaddak',1.7,0148)
INSERT INTO PostGradUser (email,password) VALUES ('mahmoud.kotry@guc.edu.eg','rizokfc123')
INSERT INTO Supervisor VALUES (8,'Mahmoud Kotry','Civil')

INSERT INTO PostGradUser (email,password) VALUES ('nayer.atallah@guc.edu.eg','sn0wflake')
INSERT INTO Admin VALUES (9)
INSERT INTO PostGradUser (email,password) VALUES ('riyadh.mahrez@guc.edu.eg','mo_091223')
INSERT INTO NonGucianStudent VALUES (10,'Riyadh','Mahrez','PHD','MET','46 Garden City',0.79)
INSERT INTO PostGradUser (email,password) VALUES ('farah.abdelwahab@guc.egu.eg','foffa123')
INSERT INTO GucianStudent VALUES (11,'Farah','Abdelwahab','Mst','IET','12 lebanon',1.66,6578)
INSERT INTO PostGradUser (email,password) VALUES ('hania.omar@guc.edu.eg','kilolobya123')
INSERT INTO Supervisor VALUES (12,'Hania Omar','MET')

INSERT INTO PostGradUser (email,password) VALUES ('reham.haggag@guc.edu.eg','remoiju')
INSERT INTO Admin VALUES (13)
INSERT INTO PostGradUser (email,password) VALUES ('lamis.ahmed@guc.edu.eg','mo_091223')
INSERT INTO NonGucianStudent VALUES (14,'Lamis','Ahmed','Mst','Architecture','18 helioplis',1.21)
INSERT INTO PostGradUser (email,password) VALUES ('ahmed.gamal@guc.egu.eg','ag_091245')
INSERT INTO GucianStudent VALUES (15,'Ahmed','Gamal','PHD','IET','34 newgiza',1.13,43-7612)
INSERT INTO PostGradUser (email,password) VALUES ('marwan.shehab@guc.edu.eg','sayadlayly')
INSERT INTO Supervisor VALUES (16,'Marwan Shehab','MET')

INSERT INTO PostGradUser (email,password) VALUES ('shmeedan.elhalawany@guc.edu.eg','strongP12')
INSERT INTO Admin VALUES (17)
INSERT INTO PostGradUser (email,password) VALUES ('youssef.salah@guc.edu.eg','MMM000')
INSERT INTO NonGucianStudent VALUES (18,'Youssef','Salah','Mst','MET','20 heli street',0.9)
INSERT INTO PostGradUser (email,password) VALUES ('omar.metwally@guc.egu.eg','mido123')
INSERT INTO GucianStudent VALUES (19,'Omar','Metwally','Mst','IET','18 Abdelmonem riyad',1.7,9999)
INSERT INTO PostGradUser (email,password) VALUES ('mahmoud.fathallah@guc.edu.eg','sayajilo')
INSERT INTO Supervisor VALUES (20,'Mahmoud Fathallah','BI')

INSERT INTO PostGradUser (email,password) VALUES ('essam.osman@guc.edu.eg','essamelnemr')
INSERT INTO Admin VALUES (21)
INSERT INTO PostGradUser (email,password) VALUES ('ahmed.zidane@guc.edu.eg','mzizo6532')
INSERT INTO NonGucianStudent VALUES (22,'Ahmed','Zidane','Mst','Law','67 manial',0.97)
INSERT INTO PostGradUser (email,password) VALUES ('mohamed.metwally@guc.egu.eg','shabjdeed23')
INSERT INTO GucianStudent VALUES (23,'Mohamed','Metwally','PHD','Management','14 ekhsheed',1.54,9213)
INSERT INTO PostGradUser (email,password) VALUES ('laura.gamal@guc.edu.eg','Loly123')
INSERT INTO Supervisor VALUES (24,'Laura Gamal','BI')

INSERT INTO PostGradUser (email,password) VALUES ('mariam.assaad@guc.edu.eg','Nayory')
INSERT INTO Admin VALUES (25)
INSERT INTO PostGradUser (email,password) VALUES ('Mortada.mansour@guc.edu.eg','MMM000')
INSERT INTO NonGucianStudent VALUES (26,'Mortada','Mansour','Mst','MET','40 Mossadak street',0.9)
INSERT INTO PostGradUser (email,password) VALUES ('johnny.spenser@guc.egu.eg','minakov')
INSERT INTO GucianStudent VALUES (27,'Johnny','Spenser','Mst','IET','12 Makkah Street',4.0,6969) 
INSERT INTO PostGradUser (email,password) VALUES ('ayman.tamer@guc.edu.eg','taymoor')
INSERT INTO Supervisor VALUES (28,'Ayman Tamer','MET')

INSERT INTO PostGradUser (email,password) VALUES ('moses.hady@guc.edu.eg','kiro93487')
INSERT INTO Admin VALUES (29)
INSERT INTO PostGradUser (email,password) VALUES ('lama.hesham@guc.edu.eg','lamloma')
INSERT INTO NonGucianStudent VALUES (30,'Lama','Hesham','PHD','Civil','87 kafr abdo',0.83)
INSERT INTO PostGradUser (email,password) VALUES ('omar.shawky@guc.egu.eg','mora654')
INSERT INTO GucianStudent VALUES (31,'Omar','Shawky','Mst','Law','12 Michael Bakhoum',1.29,3421)
INSERT INTO PostGradUser (email,password) VALUES ('joudy.akmal@guc.edu.eg','jojo123')
INSERT INTO Supervisor VALUES (32,'Joudy Akmal','BI')

INSERT INTO PostGradUser (email,password) VALUES ('karim.nagy@guc.edu.eg','kimoyassa')
INSERT INTO Admin VALUES (33)
INSERT INTO PostGradUser (email,password) VALUES ('mohanad.eldeeb@guc.edu.eg','darasicecream')
INSERT INTO NonGucianStudent VALUES (34,'Mohanad','Eldeeb','PHD','Architecture','89 Giza',0.77)
INSERT INTO PostGradUser (email,password) VALUES ('omar.khedr@guc.egu.eg','omar2309')
INSERT INTO GucianStudent VALUES (35,'Omar','Khedr','Mst','Law','67 mokattam',1.13,8234)
INSERT INTO PostGradUser (email,password) VALUES ('Layla.gad@guc.edu.eg','mimolilo')
INSERT INTO Supervisor VALUES (36,'Laila Gad','Civil')

INSERT INTO PostGradUser (email,password) VALUES ('youstina.amr@guc.edu.eg','TT789')
INSERT INTO Admin VALUES (37)
INSERT INTO PostGradUser (email,password) VALUES ('mohamed.mamdouh@guc.edu.eg','KKKK')
INSERT INTO NonGucianStudent VALUES (38,'Mohamed','Mamdouh','PHD','BI','40 Abbas street',1.9)
INSERT INTO PostGradUser (email,password) VALUES ('hany.ramsis@guc.egu.eg','Yoyo')
INSERT INTO GucianStudent VALUES (39,'Hany','Ramsis','Mst','IET','12 Bassem Street',2.0,7069)
INSERT INTO PostGradUser (email,password) VALUES ('eyad.tamer@guc.edu.eg','taymoor')
INSERT INTO Supervisor VALUES (40,'Eyad Tamer','MET')

INSERT INTO PostGradUser (email,password) VALUES ('ahmed.aysar@guc.edu.eg','yassergalal')
INSERT INTO Admin VALUES (41)
INSERT INTO PostGradUser (email,password) VALUES ('youssef.mahdy@guc.edu.eg','leoo123')
INSERT INTO NonGucianStudent VALUES (42,'Youssef','Mahdy','Mst','MET','40 Nady elseid street',0.78)
INSERT INTO PostGradUser (email,password) VALUES ('slim.abdennahder@guc.egu.eg','polymorphism')
INSERT INTO GucianStudent VALUES (43,'Slim','Abdennahder','PHD','MET','12 Tunisia',0.7,652)
INSERT INTO PostGradUser (email,password) VALUES ('ayman.ashraf@guc.edu.eg','profayman12')
INSERT INTO Supervisor VALUES (44,'Ayman Ashraf','Law')

INSERT INTO PostGradUser (email,password) VALUES ('essam.tamer@guc.edu.eg','strongTamoor')
INSERT INTO Admin VALUES (45)
INSERT INTO PostGradUser (email,password) VALUES ('lionel.messi@guc.edu.eg','leobaba12')
INSERT INTO NonGucianStudent VALUES (46,'Lionel','Messi','Mst','MET','12 jaddah',0.89)
INSERT INTO PostGradUser (email,password) VALUES ('ahmed.shamy@guc.egu.eg','mido123_012')
INSERT INTO GucianStudent VALUES (47,'Ahmed','Shamy','PHD','MET','16 Abdelmonem riyad',1.42,6523)
INSERT INTO PostGradUser (email,password) VALUES ('marwan.omar@guc.edu.eg','samiraboelneel')
INSERT INTO Supervisor VALUES (48,'Marwan Omar','Civil')

INSERT INTO PostGradUser (email,password) VALUES ('kamal.sobhy@guc.edu.eg','PwdStrong')
INSERT INTO Admin VALUES (49)
INSERT INTO PostGradUser (email,password) VALUES ('mohamed.semeda@guc.edu.eg','ziadebny123')
INSERT INTO NonGucianStudent VALUES (50,'Mohamed','Semeda','PHD','IET','14 mokattam',0.91)
INSERT INTO PostGradUser (email,password) VALUES ('ahmed.assar@guc.egu.eg','mido12345')
INSERT INTO GucianStudent VALUES (51,'Ahmed','Assar','Mst','Management','16 shehab',1.38,7927)
INSERT INTO PostGradUser (email,password) VALUES ('marwan.abdeen@guc.edu.eg','abdyyy123')
INSERT INTO Supervisor VALUES (52,'Marwan Abdeen','IET')

--Examiner
 insert into PostGradUser VALUES('marwanabdalla659@guc.edu.eg','MarwanMahmoud')
Insert into Examiner VALUES(53,'Marwan Abdalla', 'BI', 1)


insert into PostGradUser VALUES('youssefnasser@guc.edu.eg','yn0000')
Insert into Examiner VALUES(54,'Youssef Nasser', 'MET', 0)


insert into PostGradUser VALUES('mahmoudfathy@guc.edu.eg','Mahmoudxxx')
Insert into Examiner VALUES(55,'Mahmoud Fathy', 'Mechatronics', 0)

insert into PostGradUser VALUES('ahmedkhedr@guc.edu.eg','Mahmoudxxx')
Insert into Examiner VALUES (56,'Ahmed Khedr', 'Mechatronics', 0)

insert into PostGradUser VALUES('kunaguero@guc.edu.eg','zenchenko')
insert into Examiner VALUES(57,'Kun Aguero','BI', 1)


insert into PostGradUser VALUES('tylerbelvins@guc.edu.eg','YOYO123')
insert into Examiner VALUES(58,'Tyler Belvins','MET', 0)

insert into PostGradUser VALUES ('turnerrfue@guc.edu.eg','PAPPY000')
insert into Examiner VALUES(59,'Turner Tfue','MET', 1)


insert into PostGradUser VALUES('markzuckerbeg@guc.edu.eg','FB69')
insert into Examiner VALUES(60,'Mark Zuckerberg','MET', 1)

Insert into PostGradUser values ('diaa.elsherif@guc.edu.eg','Dd12345')
Insert into PostGradUser values ('assem.elsherif@guc.edu.eg','Aa12345')
Insert into PostGradUser values ('ngolo.kante@guc.edu.eg','Nn12345')
Insert into PostGradUser values ('emad.meteb@guc.edu.eg','Em12345')
Insert into PostGradUser values ('ahmed.zizo@guc.edu.eg','Az12345')
Insert into PostGradUser values ('sherif.hafez@guc.edu.eg','Ss12345')
Insert into PostGradUser values ('gerard.Pique@guc.edu.eg','Gp12345')

Insert into examiner values (61,'Diaa elsherif','BI',1)
Insert into examiner values (62,'Assem elsherif','MET',1)
Insert into examiner values (63,'Ngolo Kante','Iet',0)
Insert into examiner values (64,'Emad Meteeb','Management',1)
Insert into examiner values (65,'Ahmed Zizo','BI',0)
Insert into examiner values (66,'Sherif Hafez','BI',0)
Insert into examiner values (67,'Gerard Pique','MET',1)



--Payment 

insert into Payment values(10000,3,20.23)
insert into payment values(20000,4,31.43) 
insert into payment values(15000,2,50.23) 
insert into Payment values(20000,1,67.34)
insert into payment values(30000,4,34.23) 
insert into payment values(32000,3,0) 
insert into Payment values(10000,4,25)
insert into payment values(20000,2,99) 
insert into payment values(55500,5,10) 
insert into Payment values(21432,2,40)
insert into payment values(31345,5,0) 
insert into payment values(20000,2,0) 
insert into Payment values(20000,1,12)
insert into payment values(20000,8,35) 
insert into payment values(15000,7,51) 
Insert into payment values (10000.0,3,12.0)
Insert into payment values (12000.0,4,17.0)
Insert into payment values (19500.0,4,18.3)
Insert into payment values (11230.0,5,12.0)
Insert into payment values (13560.5,5,12.1)
Insert into payment values (19345.0,3,18.6)
Insert into payment values (26345.3,3,12.9)
Insert into payment values (12343.0,8,18.3)
Insert into payment values (1722.9,3,28.3)
Insert into payment values (30889.0,2,16.6)
Insert into payment values (10090.0,3,21.7)
Insert into payment values (10252.0,3,12.0)
Insert into payment values (10789.0,3,12.0)
insert into Payment values(12000,2,24.23)
insert into payment values(20000,4,31.43) 
insert into payment values(20000,5,31.43) 
insert into payment values(20000,10,31.43) 
--Installment

insert into Installment values ('11/12/2020',1,12000,1)
insert into Installment values('01/10/2021',2,40000,1)
insert into Installment values('03/06/2017',3,13000,0)
insert into Installment values('04/02/2013',4,42000,1)
insert into Installment values('07/05/2022',5,5000,0)
insert into Installment values ('05/05/2021',6,2000,0)
insert into Installment values('07/02/2021',7,62000,1)
insert into Installment values('01/01/2020',8,72000,0)
insert into Installment values('03/15/2022',9,7000,1)
insert into Installment values('07/07/2021',10,54000,0)
insert into Installment values ('2/2/2020',11,72000,1)
insert into Installment values('3/5/2021',12,13000,1)
insert into Installment values('6/12/2017',13,1000,0)
insert into Installment values('2/15/2020',14,26000,0)
insert into Installment values('8/8/2020',15,72000,1)
insert into Installment values ('10/10/2021',16,82000,0)
insert into Installment values('3/2/2020',17,52000,0)
insert into Installment values('1/15/2020',18,42600,0)
insert into Installment values('9/2/2021',19,22500,0)
insert into Installment values('4/4/2021',20,12345,1)
insert into Installment values ('7/23/2019',21,1253,0)
insert into Installment values('1/1/2021',22,10999,0)
insert into Installment values('2/2/2022',23,99999,1)
insert into Installment values('1/20/2021',24,74678,0)
insert into Installment values('3/4/2021',25,5000,0)
insert into Installment values ('5/7/2021',24,12000,1)
insert into Installment values('3/10/2022',25,10000,0)
insert into Installment values('4/6/2022',26,40000,0)
insert into Installment values('5/1/2021',27,8000,0)
insert into Installment values('6/10/2020',28,9000,0)
insert into Installment values ('5/7/2021',29,4000,1)
insert into Installment values('3/10/2022',30,9000,0)
insert into Installment values('4/6/2022',1,23000,1)
insert into Installment values('5/1/2021',2,6000,0)
insert into Installment values('8/10/2020',4,2000,0)
insert into Installment values ('1/8/2021',24,5000,1)
insert into Installment values('2/10/2022',25,7000,0)
insert into Installment values('9/9/2022',26,3000,1)
insert into Installment values('1/1/2021',27,12000,0)
insert into Installment values('3/5/2020',28,11000,1)

--Thesis

insert into Thesis  values ('CS','PHD','AI in cars','2021-12-11', '2023-10-11', '2022-9-11',91,1,3)
insert into Thesis  values ('Mechatronics','Mst','Robotic Arm','2020-10-09', '2025-11-10', '2021-1-05',75,2,4)
insert into Thesis  values ('IET','Mst','Designing CPU','03/26/2015','04/06/2017','12/13/2016',84.32,3,1)
insert into Thesis  values ('BI','Mst','Company IOT','02/10/2021','02/10/2022','10/10/2021',70.43,4,0)
insert into Thesis  values ('CS','PHD','Game design','02/04/2018','02/04/2020','02/04/2019',50,4,0)
insert into Thesis  values ('Civil','PHD','New capital','03/05/2017','11/25/2019','11/25/2018',64.52,5,0)
insert into Thesis  values ('Mechatronics','PHD','Factories','06/01/2020','06/01/2024','03/05/2021',87.32,6,1)
insert into Thesis  values ('BI','Mst','Technology in companies','10/24/2021','10/24/2024','11/03/2022',64.24,7,3)
insert into Thesis  values ('IET','PHD','Hardware design','10/12/2019','10/13/2025','12/03/2021',57.34,8,4)
insert into Thesis  values ('CS','PHD','Plane controls','12/12/2020','1/1/2026','2/1/2024',69.69,9,3)
insert into Thesis  Values ( 'BI', 'PHD', 'Data Mining','5/1/2020','5/1/2021', '4/1/2020', 88,10,3)
insert into Thesis  Values ( 'BI', 'Mst', 'Data Analaysis','9/14/2020','7/1/2021', '4/20/2020', 72,11,2)
insert into Thesis  Values ( 'MET', 'Mst', 'Text Mining Analytics ','3/10/2020','7/1/2021', '9/20/2020', 90,12,2)
insert into Thesis  Values ( 'MET', 'Mst', 'Digital Mining','2/27/2020','7/1/2021', '8/11/2020', 55,13,2)
insert into Thesis  Values ( 'MET', 'PHD', 'AI in Business','3/9/2020','7/1/2021', '4/12/2020', 99,14,2)
insert into Thesis  Values ( 'Mechantronics', 'Mst', '10. Cloud Application for Business Analytics','3/9/2020','7/10/2021', '6/18/2020', 70,15,2)
insert into Thesis  Values ( 'Mechantronics', 'PHD', 'RFID Based Security System with GSM technology','1/9/2020','7/13/2021', '4/18/2020', 70,16,2)
insert into Thesis  Values ( 'BI', 'Mst', 'Touchscreen Point of Sale Application','2/9/2020','7/19/2021', '5/18/2020', 80,17,3)
insert into Thesis  Values ( 'BI', 'PHD', 'Information Kiosk for School Campus','6/9/2020','7/12/2021', '7/18/2020', 80,18,3)
insert into Thesis  Values ( 'Mechantronics', 'Mst', 'Coin Operated Printing Kiosk','4/9/2020','7/14/2021', '8/18/2020', 80,19,3)
INSERT INTO Thesis  values ('BI','PHD','mechanics','11/29/2019','1/1/2020','5/1/2020',71.2,20,4)
INSERT INTO thesis  values ('engineering','Mst','civil','9/13/2020','1/1/2021','5/1/2021',95.0,21,2)
INSERT INTO thesis  values ('management','PHD','economics','11/11/2018','1/1/2019','5/1/2021',83.50,22,6)
INSERT INTO thesis  values ('management','Mst','accounting','11/29/2015','1/1/2016','5/1/2017',95.0,23,3)
INSERT INTO thesis  values ('engineering','PHD','computer science','11/29/2012','1/1/2013','5/1/2013',98.50,24,7)
INSERT INTO thesis  values ('Law','Mst','Lawyer101','11/29/2011','1/1/2012','5/1/2012',90.0,25,2)
INSERT INTO thesis  values ('BI','PHD','information technology','11/29/2015','1/1/2016','5/1/2017',92.80,26,4)
INSERT INTO thesis  values ('management','PHD','entrepreneurship','11/29/2019','1/1/2019','5/1/2020',96.80,27,6)
INSERT INTO thesis  values ('engineering','Mst','petroleum','11/29/2015','1/1/2016','5/1/2017',60.80,28,4)
INSERT INTO thesis  values ('BI','PHD','information technology','11/29/2012','1/1/2013','5/1/2015',88.0,29,8)
INSERT INTO thesis  values ('MET','Mst','Computer science stuff','05/29/2013','1/1/2018','5/1/2014',89.0,30,2)


--Courses:

INSERT INTO Course (fees,creditHours,code)VALUES(10000.00,8,'MATH303')
INSERT INTO Course (fees,creditHours,code)VALUES(12499.99,6,'CSEN301')
INSERT INTO Course (fees,creditHours,code)VALUES(6700.00,4,'DMET901')
INSERT INTO Course (fees,creditHours,code)VALUES(11567.99,6,'CSEN902')
INSERT INTO Course (fees,creditHours,code)VALUES(9000.00,8,'CSEN901')
INSERT INTO Course (fees,creditHours,code)VALUES(13400.00,5,'CSEN402')
INSERT INTO Course (fees,creditHours,code)VALUES(11000.00,8,'CIV901')
INSERT INTO Course (fees,creditHours,code)VALUES(7600.67,4,'ARCH802')
INSERT INTO Course (fees,creditHours,code)VALUES(8763.00,6,'CSIS902')
INSERT INTO Course (fees,creditHours,code)VALUES(10000.00,8,'CSIS901')

--Non Gucian take course

INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(2,1)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(6,5)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(6,2)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(10,3)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(10,7)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(14,8)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(18,10)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(18,3)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(22,2)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(26,1)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(26,9)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(30,7)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(34,4)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(38,5)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(38,8)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(38,1)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(42,6)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(46,10)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(46,3)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(50,2)
INSERT INTO NonGucianStudentTakeCourse (sid,cid)VALUES(50,7)


--defense


insert into defense values (1,'9/11/2022','cairo',91.0)
insert into defense values (2,'1/5/2021','giza',75.0)
insert into defense values (3,'9/9/2022','cairo',84.1)
insert into defense values (4,'3/11/2023','london',94.7)
insert into defense values (5,'7/18/2015','barcelona',91.4)
insert into defense values (6,'5/11/2013','cairo',87.9)
insert into defense values (7,'9/11/2022','cairo',98.0)
insert into defense values (8,'12/15/2016','cairo',91.6)
insert into defense values (9,'6/11/2023','madrid',96.8)
insert into defense values (10,'9/11/2016','cairo',91.9)
insert into defense values (11,'1/11/2022','cairo',88.0)
insert into defense values (12,'3/11/2012','alexandria',97.0)
insert into defense values (13,'6/11/2018','pamplona',71.0)
insert into defense values (14,'8/11/2021','new york',61.0)
insert into defense values (15,'9/11/2022','cairo',91.0)
insert into defense values (16,'9/11/2022','giza',91.0)
insert into defense values (17,'9/11/2022','cairo',90.0)
insert into defense values (18,'9/11/2022','cairo',51.0)
insert into defense values (19,'2/14/2023','cairo',93.0)
insert into defense values (20,'2/19/2022','cairo',92.9)
insert into defense values (21,'6/20/2022','bilbao',91.9)
insert into defense values (22,'9/11/2010','cairo',91.3)
insert into defense values (23,'12/19/2022','cairo',60.0)
insert into defense values (24,'3/11/2018','cairo',67.0)
insert into defense values (25,'4/11/2019','hurghada',91.0)
insert into defense values (26,'6/11/2022','cairo',87.1)
insert into defense values (27,'2/11/2022','cairo',77.4)
insert into defense values (28,'2/11/2016','salzburg',78.0)
insert into defense values (29,'9/11/2022','cairo',91.0)
insert into defense values (30,'2/11/2021','bilbao',91.0)


Insert into ExaminerEvaluateDefense values('2022-09-11',1,53,'poor')
Insert into ExaminerEvaluateDefense values('2021-01-05',2,54,'good')
Insert into ExaminerEvaluateDefense values('2015-07-18',5,55,'poor')
Insert into ExaminerEvaluateDefense values('2013-05-11',6,56,'fair')
Insert into ExaminerEvaluateDefense values('2016-09-11',10,57,'excellent')
Insert into ExaminerEvaluateDefense values('2022-01-11',11,58,'fair')


-- GucianRegisterThesis

insert into GUCianStudentRegisterThesis Values (3,4,1)
insert into GUCianStudentRegisterThesis Values (7,8, 2)
insert into GUCianStudentRegisterThesis Values (11,8,3)
insert into GUCianStudentRegisterThesis Values (15,16,4)
insert into GUCianStudentRegisterThesis Values (19,24,5)
insert into GUCianStudentRegisterThesis Values (23,4,6)
insert into GUCianStudentRegisterThesis Values (27,20,7)
insert into GUCianStudentRegisterThesis Values (31,40,8)
insert into GUCianStudentRegisterThesis Values (35,36,9)
insert into GUCianStudentRegisterThesis Values (39,28,10)
insert into GUCianStudentRegisterThesis Values (43,4,11)
insert into GUCianStudentRegisterThesis Values (47,12,12)
insert into GUCianStudentRegisterThesis Values (51,20,13)
insert into GUCianStudentRegisterThesis Values (31,12,14)
insert into GUCianStudentRegisterThesis Values (19,8,15)

-- NonGucianRegisterThesis

Insert into NonGUCianStudentRegisterThesis values (2,4,16)
Insert into NonGUCianStudentRegisterThesis values (6,8,17)
Insert into NonGUCianStudentRegisterThesis values (10,12,18)
Insert into NonGUCianStudentRegisterThesis values (14,16,19)
Insert into NonGUCianStudentRegisterThesis values (18,20,20)
Insert into NonGUCianStudentRegisterThesis values (22,24,21)
Insert into NonGUCianStudentRegisterThesis values (26,28,22)
Insert into NonGUCianStudentRegisterThesis values (30,32,23)
Insert into NonGUCianStudentRegisterThesis values (34,36,24)
Insert into NonGUCianStudentRegisterThesis values (38,40,25)
Insert into NonGUCianStudentRegisterThesis values (42,44,26)
Insert into NonGUCianStudentRegisterThesis values (46,48,27)
Insert into NonGUCianStudentRegisterThesis values (50,52,28)
Insert into NonGUCianStudentRegisterThesis values (38,20,29)
Insert into NonGUCianStudentRegisterThesis values (26,12,30)

-- GucianProgressReport
select * from Thesis
insert into GUCianProgressReport Values (3,1,'1/1/2022',2,9,null,1,4)
insert into GUCianProgressReport Values (7,1,'11/1/2021',3,8,null,2,8)
insert into GUCianProgressReport Values (11,1,'1/1/2016',0,0,null,3,8)
insert into GUCianProgressReport Values (15,1,'1/1/2022',2, 0,null,4,16)
insert into GUCianProgressReport Values (19,1,'1/1/2021', 0,3,null,15,8)
insert into GUCianProgressReport Values (23,1,'1/1/2016', 2,8,null,6,4)
insert into GUCianProgressReport Values (27,1,'1/1/2018', 2,9,null,7,20)
insert into GUCianProgressReport Values (31,1,'1/1/2021', 0,9,null,14,12)
insert into GUCianProgressReport Values (31,2,'1/1/2020', 2,5,null,8,40)
insert into GUCianProgressReport Values (35,1,'1/1/2022', 1,5,null,9,36)
insert into GUCianProgressReport Values (39,1,'1/1/2024', 3,2,null,10,28)
insert into GUCianProgressReport Values (43,1,'1/1/2021', 1,4,null,11,4)
insert into GUCianProgressReport Values (47,1,'1/1/2021', 2,9,null,12,12)
insert into GUCianProgressReport Values (51,1,'1/1/2020', 2,9,null,13,20)
insert into GUCianProgressReport Values (19,2,'1/1/2019', 1,3,null,5,24)

-- NonGucianProgressReport

Insert into NonGUCianProgressReport values (2,1,'11/20/2020',1,8,null,16,4)
Insert into NonGUCianProgressReport values (6,1,'11/25/2021',1,6,null,17,8)
Insert into NonGUCianProgressReport values (10,1,'1/20/2021',2,8,null,18,12)
Insert into NonGUCianProgressReport values (14,1,'11/20/2021',3,10,null,19,16)
Insert into NonGUCianProgressReport values (18,1,'3/27/2020',2,8,null,20,20)
Insert into NonGUCianProgressReport values (22,1,'2/28/2019',1,5,null,21,24)
Insert into NonGUCianProgressReport values (26,1,'11/20/2020',3,8,null,30,12)
Insert into NonGUCianProgressReport values (26,2,'12/12/2017',1,5,null,22,28)
Insert into NonGUCianProgressReport values (30,1,'11/20/2016',3,8,null,23,32)
Insert into NonGUCianProgressReport values (34,1,'11/20/2021',2,9,null,24,36)
Insert into NonGUCianProgressReport values (38,1,'8/24/2020',1,5,null,29,20)
Insert into NonGUCianProgressReport values (38,2,'11/20/2018',0,3,null,25,40)
Insert into NonGUCianProgressReport values (42,1,'11/20/2021',0,5,null,26,44)
Insert into NonGUCianProgressReport values (46,1,'5/20/2018',3,10,null,27,48)
Insert into NonGUCianProgressReport values (50,1,'10/31/2021',1,5,null,28,52)

-- Publication

Insert into publication values('BI','12/1/2021','cairo',1,'information technology department')
Insert into publication values('BI','11/20/2021','cairo',0,'information technology department')
Insert into publication values('MET','11/1/2020','Alexandria',1,'Engineering department')
Insert into publication values('MET','3/11/2020','Cario',0,'Engineering department')
Insert into publication values('DMET','8/1/2020','Cairo',1,'Engineering department')
Insert into publication values('Law','12/1/2021','cairo',1,'Law department')
Insert into publication values('Accounting','11/1/2020','cairo',0,'Accounting department')
Insert into publication values('Business','4/4/2021','cairo',1,'Management department')
Insert into publication values('Civil','1/10/2021','Cairo',1,'Engineering')
Insert into publication values('mechatronics','1/10/2021','Cairo',1,'Engineering')
Insert into publication values('IET','1/20/2021','Cairo',1,'Engineering')
Insert into publication values('BI','1/13/2019','Cairo',1,'Information technology')

-- ThesisHasPublication

Insert into ThesisHasPublication values (1,5)
Insert into ThesisHasPublication values (2,10)
Insert into ThesisHasPublication values (3,11)
Insert into ThesisHasPublication values (4,1)
Insert into ThesisHasPublication values (5,3)
Insert into ThesisHasPublication values (6,9)
Insert into ThesisHasPublication values (7,10)
Insert into ThesisHasPublication values (8,2)
Insert into ThesisHasPublication values (9,11)
Insert into ThesisHasPublication values (10,4)
Insert into ThesisHasPublication values (11,1)
Insert into ThesisHasPublication values (12,2)
Insert into ThesisHasPublication values (13,3)
Insert into ThesisHasPublication values (14,4)
Insert into ThesisHasPublication values (15,5)
Insert into ThesisHasPublication values (16,10)
Insert into ThesisHasPublication values (17,10)
Insert into ThesisHasPublication values (18,2)
Insert into ThesisHasPublication values (19,1)
Insert into ThesisHasPublication values (20,4)
Insert into ThesisHasPublication values (21,12)
Insert into ThesisHasPublication values (22,3)
Insert into ThesisHasPublication values (23,8)
Insert into ThesisHasPublication values (24,7)
Insert into ThesisHasPublication values (25,4)
Insert into ThesisHasPublication values (26,6)
Insert into ThesisHasPublication values (27,12)
Insert into ThesisHasPublication values (28,7)
Insert into ThesisHasPublication values (29,11)
Insert into ThesisHasPublication values (30,11)


select * from PostGradUser
select * from GucianStudent
select * from NonGucianStudent
select * from Supervisor
select * from Admin
select * from Examiner
select * from Course
select * from NonGucianStudentTakeCourse
select * from Thesis
select * from payment
select * from Installment
select * from Defense
select * from ExaminerEvaluateDefense