insert into patient2 values(0000000001,"database@yahoo.com,"flo",'01-apr-16',"15","3","irbid",'06-jan-18',"a+","F","good");
insert into patient2 values(0000000002,"data@yahoo.com,"canser",'15-mar-95',"10","3","irbid",'08-mar-18',"a+","F","not good");
insert into patient2 values(0000000003,"base@yahoo.com,"food poisoning",'29-nov-95',"60","3","irbid",'11-oct-18',"a+","F","very good");
insert into patient2 values(0000000004,"dabas@yahoo.com,"heat rash",'07-dec-18',"15","25","irbid",'25-nov-18',"a+","F","bad");
insert into patient2 values(0000000005,"dataase@yahoo.com,"headache",'09-oct-01',"15","78","irbid",'12-dec-18',"a+","F","good");

insert into inpatient values('y',0000000001);
insert into inpatient values('y',0000000002);
insert into outpatient values('N',0000000003);
insert into outpatient values('N',0000000004);
insert into outpatient values('N',0000000005);

insert into phonenumber values(00962790179802,0000000001);
insert into phonenumber values(00962779969396,0000000002);
insert into phonenumber values(00962770121004,0000000003);
insert into phonenumber values(00962775110610,0000000004);
insert into phonenumber values(00962790179801,0000000005);


insert into servises values(12345,20);
insert into servises values(12344,50);
insert into servises values(12341,100);
insert into servises values(12343,203);
insert into servises values(12342,110);

insert into ser_type values("opservation",12345);
insert into ser_type values("x_ray",12344);
insert into ser_type values("lab test",12341);
insert into ser_type values("surgery",12343);
insert into ser_type values("opservation2",12342);

inset into patient_services values(12345,0000000001);
inset into patient_services values(12344,0000000002);
inset into patient_services values(12341,0000000003);
inset into patient_services values(12343,0000000004);
inset into patient_services values(12342,0000000001);

insert into medicine values("pandol",'100gm',001);
insert into medicine values("x",'5ml',25);
insert into medicine values("f",'500gm',40);

insert into patient_medicine values("panadol",0000000001);
insert into patient_medicine values("x",0000000002);

insert into test values("blood",12);

insert into patient_test values("idont now what to write",0000000001,"blood");
insert into patient_test values("idont now what to write",0000000002,"blood");
insert into patient_test values("idont now what to write",0000000003,"blood");
insert into patient_test values("idont now what to write",0000000004,"blood");
insert into patient_test values("idont now what to write",0000000005,"blood");


insert into room values(11111,300,"icu",null);

insert into emergency_contact values("reem",0000000001,00962779969396,"sister");
insert into emergency_contact values("rand",0000000002,00962790179802,"mother");

insert into employe2 values("20160173003",'F',03-mar-88,"ali","r","alali",sysdate);
insert into employe2 values("20160173013",'F',01-apr-85,"ahmad","m","marashdeh",12-mar-17);
insert into employe2 values("20160173023",'F',05-oct-81,"omar","n","agha",3-oct-15);
insert into employe2 values("20160173033",'F',07-mar-87,"mohammad","w","megdady",6-apr-01);

insert into doctor values("20160173003",0000000001,"phd");
insert into doctor values("20160173013",0000000002,"phd");

insert into nurse values("20160173023","master");
insert into nurse values("20160173033","master");

insert into patient_doctor values("20160173003",0000000001);
insert into patient_doctor values("20160173013",0000000002);

insert into patient_nurse values("20160173023",0000000003);
insert into patient_nurse values("20160173033",0000000005);

insert into department values();





update patient2 set gender="34" where ssn=00000000001;
update room set cost=500 where number=11111;
update medicine set dosage='20ml' where name="pandol";
update emergency_contact set  phone-num=0779983472 where name="rand";
update services set  cost=50 where number=12345,




delete from employe2 where fname="ali";





















insert into patient2 values(0000000001,"database@yahoo.com,"flo",'01-apr-16',"15","3","irbid",'06-jan-18',"a+","F","good");
insert into patient2 values(0000000002,"data@yahoo.com,"canser",'15-mar-95',"10","3","irbid",'08-mar-18',"a+","F","not good");
insert into patient2 values(0000000003,"base@yahoo.com,"food poisoning",'29-nov-95',"60","3","irbid",'11-oct-18',"a+","F","very good");
insert into patient2 values(0000000004,"dabas@yahoo.com,"heat rash",'07-dec-18',"15","25","irbid",'25-nov-18',"a+","F","bad");
insert into patient2 values(0000000005,"dataase@yahoo.com,"headache",'09-oct-01',"15","78","irbid",'12-dec-18',"a+","F","good");

insert into inpatient values('y',0000000001);
insert into inpatient values('y',0000000002);
insert into outpatient values('N',0000000003);
insert into outpatient values('N',0000000004);
insert into outpatient values('N',0000000005);

insert into phonenumber values(00962790179802,0000000001);
insert into phonenumber values(00962779969396,0000000002);
insert into phonenumber values(00962770121004,0000000003);
insert into phonenumber values(00962775110610,0000000004);
insert into phonenumber values(00962790179801,0000000005);


insert into servises values(12345,20);
insert into servises values(12344,50);
insert into servises values(12341,100);
insert into servises values(12343,203);
insert into servises values(12342,110);

insert into ser_type values("opservation",12345);
insert into ser_type values("x_ray",12344);
insert into ser_type values("lab test",12341);
insert into ser_type values("surgery",12343);
insert into ser_type values("opservation2",12342);

inset into patient_services values(12345,0000000001);
inset into patient_services values(12344,0000000002);
inset into patient_services values(12341,0000000003);
inset into patient_services values(12343,0000000004);
inset into patient_services values(12342,0000000001);

insert into medicine values("pandol",'100gm',001);
insert into medicine values("x",'5ml',25);
insert into medicine values("f",'500gm',40);

insert into patient_medicine values("panadol",0000000001);
insert into patient_medicine values("x",0000000002);

insert into test values("blood",12);

insert into patient_test values("idont now what to write",0000000001,"blood");
insert into patient_test values("idont now what to write",0000000002,"blood");
insert into patient_test values("idont now what to write",0000000003,"blood");
insert into patient_test values("idont now what to write",0000000004,"blood");
insert into patient_test values("idont now what to write",0000000005,"blood");


insert into room values(11111,300,"icu",null);

insert into emergency_contact values("reem",0000000001,00962779969396,"sister");
insert into emergency_contact values("rand",0000000002,00962790179802,"mother");

insert into employe2 values("20160173003",'F',03-mar-88,"ali","r","alali",sysdate);
insert into employe2 values("20160173013",'F',01-apr-85,"ahmad","m","marashdeh",12-mar-17);
insert into employe2 values("20160173023",'F',05-oct-81,"omar","n","agha",3-oct-15);
insert into employe2 values("20160173033",'F',07-mar-87,"mohammad","w","megdady",6-apr-01);

insert into doctor values("20160173003",0000000001,"phd");
insert into doctor values("20160173013",0000000002,"phd");

insert into nurse values("20160173023","master");
insert into nurse values("20160173033","master");

insert into patient_doctor values("20160173003",0000000001);
insert into patient_doctor values("20160173013",0000000002);

insert into patient_nurse values("20160173023",0000000003);
insert into patient_nurse values("20160173033",0000000005);

insert into department values();





update patient2 set gender="34" where ssn=00000000001;
update room set cost=500 where number=11111;
update medicine set dosage='20ml' where name="pandol";
update emergency_contact set  phone-num=0779983472 where name="rand";
update services set  cost=50 where number=12345,




delete from employe2 where fname="ali";