מטלה בSQL

INSERT INTO Patient VALUES
(31625777, 'Barak', 'Gotesman','male', '01/24/1996'),
(31225757, 'Herman', 'Grant','male', '09/03/1980'),
(31625007, 'Elissa', 'Beaumont','female', '03/01/1996'),
(32325177, 'Myron', 'Reese','female', '06/11/1992'),
(21225757, 'Walter', 'Holland','male', '11/10/1976');

INSERT INTO Dept VALUES (1, 'dept a'),(2, 'dept b'),(3, 'dept c'),(4, 'dept d'),(5, 'dept e');

INSERT INTO Room VALUES(1, 'Critical care', 3, 'nice room', 1),
(2, 'Regular', 7, 'big room', 2),
(3, 'Critical care', 10, 'bad room', 3),
(4, 'Regular', 6, 'hello room', 4),
(5, 'Critical care', 9, 'very nice room', 5)

INSERT INTO Disease VALUES('Chest pain'),('CoronaVirus'),('Dehydration'),('Dementia'),('Depression'),('Malaria');

INSERT INTO DiseasesSymptoms VALUES
('Fever',1),('Sleepy',1),
('Blindness',2),('heartburn',2),
('anxiety',3),('Chills',3),
('alopecia',4),('confusion',4),
('Sweaty',5),('dry mouth',5);

INSERT INTO Diagnoses VALUES
('11/24/2020',31625777,1),
('09/14/2020',31225757,2),
('08/13/2020',31625007,3),
('10/12/2020',32325177,4),
('11/11/2020',21225757,5);

INSERT INTO Doctor VALUES
(316571363,'david', 'bkamdd' ,1,3),
(326571363,'mor', 'bkamdd' ,2,3),
(316574363,'moria', 'ebmurmad' ,5,2),
(316771303,'david', 'david' ,4,3),
(116571323,'rotem', 'gotesman' ,1,4),

(435464532,'Leighton', 'Mercado',2,5),
(235642489, 'Rosina', 'Curtis', 2, 1),
(357620597, 'Maureen', 'Wilks',1, 4),
(343674354, 'Anees', 'Hines',1,2),
(246629555, 'Mikey', 'Peck', 1,5);

INSERT INTO Intern VALUES
(316571363),
(326571363),
(435464532),
(235642489),
(357620597);


INSERT INTO CertifiedDoctors VALUES
(543240, 316574363),
(263146, 316771303),
(563216, 116571323),
(246732, 343674354),
(123566, 246629555);

INSERT INTO Expertise VALUES
(3255,'Cancer'),
(3155,'Plastics'),
(3153,'Ear, Nose and Throat'),
(3516,'Urologic'),
(35713,'Eye and Vision');

INSERT INTO HasExpertise VALUES
('rambam', '01/24/1996', 3255, 316571363 ),
('Mgdal hamak', '01/22/1996', 3155, 316571363 ),
('Nahariya hositpel', '03/24/2000', 3153, 326571363 ),
('Zvulon', '01/22/2010', 3155, 326571363 ),
('tel hasomer', '03/30/2001', 35713, 316574363 ),
('rambam', '01/11/2010', 3516, 316574363 ),
('rambam', '03/30/2011', 35713, 316771303 ),
('rambam', '01/11/2019', 3155, 316771303 );

INSERT INTO Cares VALUES
(316571363, 1,31625777 ),
(326571363, 2,31225757 ),
(316574363, 3,31625007 ),
(316771303, 4,32325177 ),
(116571323, 5,21225757 );

INSERT INTO Hosted VALUES
('01/24/2020','01/26/2020','',1,1,31625777),
('02/24/2020','02/26/2020','',2,2,31225757),
('03/24/2020','03/26/2020','',3,3,31225757),
('04/24/2020','04/26/2020','',4,4,31625007),
('05/24/2020','05/26/2020','',5,5,31225757);

INSERT INTO Medicine VALUES
(2341,'Kadcyla'),
(1341,'Wellbutrin XR'),
(5321,'Bamyxin'),
(5301,'Abacavir'),
(2440,'Acamol');

INSERT INTO MedicineConflicts VALUES
(2341,1341),
(2341,5321),
(1341,5321),
(1341,5301),
(1341,2440),
(2341,5301),
(2341,2440),
(2440,5321);

INSERT INTO Perscribes VALUES
(1, 2341, 316571363, 31625777, '01/24/2020', 3),
(2, 2341, 326571363, 31225757, '02/24/2020', 2),
(3, 1341, 316574363, 31625007, '01/24/2020', 1),
(4, 2341, 316571363, 32325177, '05/24/2020', 5),
(5, 2341, 316574363, 21225757, '12/11/2020', 1),
(6, 1341, 316571363, 31625777, '01/24/2020', 3),
(7, 2440, 316771303, 21225757, '06/23/2020', 2),
(8, 5321, 316571363, 31625777, '02/04/2020', 2);