1

2 INSERT INTO DEPARTMENT VALUES

3 (NULL,'Emergency');
4 INSERT INTO DEPARTMENT VALUES
5 (NULL,'Oncology');
6 INSERT INTO DEPARTMENT VALUES
7 (NULL,'Cardiology');
8 INSERT INTO DEPARTMENT VALUES
9 (NULL,'Orthopedic');
10
11 INSERT INTO EMPLOYEE VALUES
12 (NULL, 'D','John', 'Wing','222-455-1916', 'jwing@hospital.com', '1122 Pink Flower Ln',
NULL, 'San Jose', 'CA', '95111'
13 );
14 INSERT INTO EMPLOYEE VALUES
15 (NULL, 'D','Stuart', 'Woodman', '222-455-1917', 'swoodman@hospital.com', '2098 Happy
Willow Dr.',NULL, 'San Jose', 'CA', '95112'
16 );
17 INSERT INTO EMPLOYEE VALUES
18 (NULL,'D', 'Kristin', 'Dautzenberg', '222-455-1918', 'kdautzenberg@hospital.com', '1122
Pink Flower Ln',NULL, 'San Jose', 'CA', '95111'
19 );
20 INSERT INTO EMPLOYEE VALUES
21 (NULL, 'N', 'Emily', 'Nguyen', '222-455-1919', 'enguyen@hospital.com', '1538 Ginger Tea
ln', NULL,'San Jose', 'CA', '95112'
22 );
23 INSERT INTO EMPLOYEE VALUES
24 (NULL, 'N', 'Chris', 'Diaz', '222-455-1920', 'cdiaz@hospital.com', '675 Green Willow
Dr', NULL, 'San Jose', 'CA', '95221'
25 );
26 INSERT INTO EMPLOYEE VALUES
27 (NULL, 'D','Paul', 'Ginger', '222-455-1921', 'pginger@hospital.com', '212 River Bed
Rd', 'Apt # 88', 'Santa Clara', 'CA', '95050'
28 );
29 INSERT INTO EMPLOYEE VALUES
30 (NULL, 'D','Daniel', 'Smith', '222-455-1922', 'dsmith@hospital.com', '871 Lookout Bend
Ct', NULL, 'San Jose', 'CA', '95120'
31 );
32 INSERT INTO EMPLOYEE VALUES
33 (NULL, 'N','Timothy', 'Brown', '222-455-1923', 'tbrown@hospital.com', 'Big Falls
Dr',NULL, 'Milpitas', 'CA', '95309'
34 );
35 INSERT INTO EMPLOYEE VALUES
36 (NULL,'D', 'Edward', 'Johnson', '222-455-1924', 'ejohnson@hospital.com', '4365
Silveraado Pl',NULL, 'San Jose', 'CA', '95111'
37 );
38 INSERT INTO EMPLOYEE VALUES
39 (NULL,'N', 'Richard', 'Davis', '222-455-1925', 'rdavis@hospital.com', '890 Trevino
Terrace', NULL, 'San Jose', 'CA', '95111'
40 );
41 INSERT INTO EMPLOYEE VALUES
42 (NULL,'N', 'Elizabeth', 'Dautzenberg', '222-455-1926', 'eDautzenberg@hospital.com',
'907 Crystal Cove Dr', 'Apartment # 202', 'San Jose', 'CA', '95131'
43 );
44 INSERT INTO EMPLOYEE VALUES
45 (NULL, 'D','Andy', 'Diaz', '222-455-1927', 'adiaz@hospital.com', '7089 Millbrook Ct',
NULL, 'San Jose', 'CA', '95131'
46 );
47
48 INSERT INTO DOCTOR VALUES
49 (1, 'D',1);
50 INSERT INTO DOCTOR VALUES
51 (2,'D',1);
52 INSERT INTO DOCTOR VALUES
53 (3,'D',2);
54 INSERT INTO DOCTOR VALUES
 55 (6,'D',3);
56 INSERT INTO DOCTOR VALUES
57 (7,'D',4);
58 INSERT INTO DOCTOR VALUES
59 (9,'D',3);
60 INSERT INTO DOCTOR VALUES
61 (12,'D',4);
62
63 INSERT INTO NURSE VALUES
64 (4,'N', '11:00:00', '05:00:00');
65 INSERT INTO NURSE VALUES
66 (5,'N','05:00:00','11:00:00');
67 INSERT INTO NURSE VALUES
68 (8, 'N','23:00:00','16:00:00');
69 INSERT INTO NURSE VALUES
70 (10, 'N', '14:00:00','20:00:00');
71 INSERT INTO NURSE VALUES
72 (11,'N','04:00:00','10:00:00');
73
74 INSERT INTO rooms
75 VALUES(1,null);
76 INSERT INTO rooms
77 VALUES(2,null);
78 INSERT INTO rooms
79 VALUES(3,null);
80 INSERT INTO rooms
81 VALUES(4,null);
82 INSERT INTO rooms
83 VALUES(5,null);
84 INSERT INTO rooms
85 VALUES(6,null);
86 INSERT INTO rooms
87 VALUES(7,null);
88 INSERT INTO rooms
89 VALUES(8,null);
90
91 INSERT INTO nursegovernsroom
92 VALUES (4, 1);
93 INSERT INTO nursegovernsroom
94 VALUES (4, 2);
95 INSERT INTO nursegovernsroom
96 VALUES (5, 3);
97 INSERT INTO nursegovernsroom
98 VALUES (5, 4);
99 INSERT INTO nursegovernsroom
100 VALUES (8, 5);
101 INSERT INTO nursegovernsroom
102 VALUES (8, 6);
103 INSERT INTO nursegovernsroom
104 VALUES (10, 7);
105 INSERT INTO nursegovernsroom
106 VALUES (10, 6);
107 INSERT INTO nursegovernsroom
108 VALUES (11, 8);
109 INSERT INTO nursegovernsroom
110 VALUES (11, 4);
111
112 INSERT INTO patient VALUES
113 (NULL,'Anna', 'Jung', 'F', '1122 Baxter Ct', NULL,'San Jose', 'CA',
'95120','222-455-1958', 'ajung@domain.com'
114 );
115 INSERT INTO patient VALUES
116 (NULL,'Amy', 'Scudero', 'F', '768 Magnolia dr', NULL,'San Jose', 'CA',
'95119','222-455-1959', 'ascudero@domain.com'
117 );
118 INSERT INTO patient VALUES
119 (NULL,'Rita', 'Shah', 'F', '1907 Green Lake cir', NULL,'San Jose', 'CA',
'95111','222-455-1960', 'rshah@domain.com'
120 );
121 INSERT INTO patient VALUES
122 (NULL,'Caden', 'Clark', 'M', '1806 Midnight dr', NULL,'San Jose', 'CA',
'95120','222-455-1961', 'cclark@hospital.com'
123 );
124 INSERT INTO patient VALUES
125 (NULL,'Lucas', 'Martin','M', '176 White Horse ct', NULL,'San Jose', 'CA', '95121',
'222-455-1962', 'lmartin@domain.com'
126 );
127 INSERT INTO patient VALUES
128 (NULL,'Emma', 'King', 'F','607 Montego st', NULL,'San Jose', 'CA', '95131',
'222-455-1963', 'eKing@domain.com'
129 );
130 INSERT INTO patient VALUES
131 (NULL,'Mia', 'Taylor', 'F', '907 Green Meadow way', NULL, 'Milpitas', 'CA', '95111',
'222-455-1964', 'mtaylor@domain.com'
132 );
133 INSERT INTO patient VALUES
134 (NULL,'Aria', 'Garg', 'M', '987 Crington cir', NULL, 'San Jose', 'CA', '95111',
'222-455-1965', 'agarg@domain.com'
135 );
136 INSERT INTO patient VALUES
137 (NULL,'Yalda', 'Samardi','F', '907 Green Meadow cir', NULL, 'San Jose', 'CA', '95111',
'222-455-1966', 'ysamardi@domain.com'
138 );
139 INSERT INTO patient VALUES
140 (NULL,'Calista', 'Berg', 'F', '7654 Rudger Dr', NULL, 'San Jose', 'CA', '95101',
'222-455-1967', 'cbergo@domain.com'
141 );
142 INSERT INTO patient VALUES
143 (NULL,'George', 'Castillo', 'M', '907 Green Meadow cir', NULL, 'San Jose', 'CA',
'95111','222-455-1968', 'ecastillo@domain.com'
144 );
145 INSERT INTO patient VALUES
146 (NULL,'John', 'Sandman', 'M', '435 Windriver dr', NULL,'Mountain View', 'CA', '94043',
'222-455-1969', 'jsandmano@domain.com'
147 );
148 INSERT INTO patient VALUES
149 (NULL,'Robyn', 'Hernandez', 'F', '891 Lazy River Rd', NULL, 'Gilroy', 'CA', '95021',
'222-455-1970', 'rhernandez@domain.com'
150 );
151 INSERT INTO patient VALUES
152 (NULL,'Dan', 'Miller','M', '6754 Hot Springs Ln', NULL, 'Gilroy', 'CA', '95025',
'222-455-1971', 'bmiller@domain.com'
153 );
154 INSERT INTO patient VALUES
155 (NULL,'Amba', 'Kirk', 'F', '9087 Starfire way', NULL,'San Jose', 'CA',
'95117','222-455-1972', 'akirk@domain.com'
156 );
157
158 INSERT INTO patientinvoice
159 VALUES (NULL, 1, '2015-10-30',850,200);
160 INSERT INTO patientinvoice
161 VALUES (NULL, 2, '2018-01-02',2550,2550);
162 INSERT INTO patientinvoice
163 VALUES (NULL, 3, '2016-08-30',1100,800);
164 INSERT INTO patientinvoice
165 VALUES (NULL, 4, '2017-06-28',1850,1200);
166 INSERT INTO patientinvoice
167 VALUES (NULL, 5, '2017-11-25',1200,1200);
168 INSERT INTO patientinvoice
169 VALUES (NULL, 6, '2015-10-30',3500,3000);
170 INSERT INTO patientinvoice
171 VALUES (NULL, 6, '2015-10-30',850,200);
172 INSERT INTO patientinvoice
173 VALUES (NULL, 7, '2012-10-30',1700,1700);
174 INSERT INTO patientinvoice
175 VALUES (NULL, 6, '2013-11-30',50,50);
176 INSERT INTO patientinvoice
177 VALUES (NULL, 8, '2018-1-30',850,850);
178 INSERT INTO patientinvoice
179 VALUES (NULL, 9, '2014-09-12',2578,2000);
180 INSERT INTO patientinvoice
181 VALUES (NULL, 10, '2012-02-22',8000,2500);
182 INSERT INTO patientinvoice
183 VALUES (NULL, 11, '2011-10-30',350,200);
184 INSERT INTO patientinvoice
185 VALUES (NULL, 12, '2017-08-06',3000,3000);
186 INSERT INTO patientinvoice
187 VALUES (NULL, 13, '2018-03-18',1500,1500);
188 INSERT INTO patientinvoice
189 VALUES (NULL, 14, '2017-04-05',489,150);
190 INSERT INTO patientinvoice
191 VALUES (NULL, 15, '2017-06-24',1650,1650);
192
193
194 INSERT INTO patientrecord
195 VALUES (NULL, 1, '2015-10-30','2015-11-06');
196 INSERT INTO patientrecord
197 VALUES (NULL, 2, '2018-01-02','2018-01-04');
198 INSERT INTO patientrecord
199 VALUES (NULL, 3, '2016-08-30','2016-09-04');
200 INSERT INTO patientrecord
201 VALUES (NULL, 4, '2017-06-28','2017-06-30');
202 INSERT INTO patientrecord
203 VALUES (NULL, 5, '2017-11-25','2017-12-02');
204 INSERT INTO patientrecord
205 VALUES (NULL, 6, '2015-10-30','2015-11-10');
206 INSERT INTO patientrecord
207 VALUES (NULL, 6, '2016-03-14','2016-03-18');
208 INSERT INTO patientrecord
209 VALUES (NULL, 7, '2012-05-18','2012-05-19');
210 INSERT INTO patientrecord
211 VALUES (NULL, 6, '2013-11-30','2013-12-09');
212 INSERT INTO patientrecord
213 VALUES (NULL, 8, '2018-01-30','2018-02-05');
214 INSERT INTO patientrecord
215 VALUES (NULL, 9, '2014-09-12','2014-09-16');
216 INSERT INTO patientrecord
217 VALUES (NULL, 10, '2012-02-22','2012-02-25');
218 INSERT INTO patientrecord
219 VALUES (NULL, 11, '2011-10-30','2011-11-03');
220 INSERT INTO patientrecord
221 VALUES (NULL, 12, '2017-08-06','2017-08-08');
222 INSERT INTO patientrecord
223 VALUES (NULL, 13, '2018-03-18','2018-03-20');
224 INSERT INTO patientrecord
225 VALUES (NULL, 14, '2017-04-05','2017-04-07');
226 INSERT INTO patientrecord
227 VALUES (NULL, 15, '2017-06-24','2017-06-26');
228
229
230 INSERT INTO patient_has_doctor
231 VALUES (1,2);
232 INSERT INTO patient_has_doctor
233 VALUES (2,2);
234 INSERT INTO patient_has_doctor
235 VALUES (3,1);
236 INSERT INTO patient_has_doctor
237 VALUES (4,3);
238 INSERT INTO patient_has_doctor
239 VALUES (5,6);
240 INSERT INTO patient_has_doctor
241 VALUES (6,7);
242 INSERT INTO patient_has_doctor
243 VALUES (8,7);
244 INSERT INTO patient_has_doctor
245 VALUES (9,12);
246 INSERT INTO patient_has_doctor
247 VALUES (10,12);
248 INSERT INTO patient_has_doctor
249 VALUES (11,2);
250 INSERT INTO patient_has_doctor
251 VALUES (12,3);
252 INSERT INTO patient_has_doctor
253 VALUES (13,9);
254 INSERT INTO patient_has_doctor
255 VALUES (14,7);
256 INSERT INTO patient_has_doctor
257 VALUES (15,2);
258
259 UPDATE ROOMS
260 SET patientID=15
261 WHERE RoomNumber=1;
262 UPDATE ROOMS
263 SET patientID=12
264 WHERE RoomNumber=2;
265 UPDATE ROOMS
266 SET patientID=1
267 WHERE RoomNumber=8;
268 UPDATE ROOMS
269 SET patientID=8
270 WHERE RoomNumber=4;
271
272
273 INSERT INTO EmergencyContact VALUES
274 ('12', 'Curtis', 'Wolfer', '775 Presidente Dr.Wy.', NULL, 'Morgan Hill', 'CA', '96317',
'510-179-7972', 'C.Wolfer@gmail.com');
275
276 INSERT INTO EmergencyContact VALUES
277 ('5', 'Deeann', 'Nonaka', '2287 Silverside Blvd.', NULL, 'Morgan Hill', 'CA', '96777',
'510-541-9141', 'D.Nonaka@yahoo.com');
278
279 INSERT INTO EmergencyContact VALUES
280 ('2', 'Basilia', 'Macie', '2250 La para Blvd.', NULL, 'Sunnvale', 'CA', '95560',
'408-900-2751', 'B.Macie@yahoo.com');
281
282 INSERT INTO EmergencyContact VALUES
283 ('3', 'Wilson', 'Stritzinger', '1528 Lennon Rd.', NULL, 'Gilroy', 'CA', '95831',
'510-142-8785', 'W.Stritzinger@yahoo.com');
284
285 INSERT INTO EmergencyContact VALUES
286 ('10', 'Selena', 'Hayner', '3154 Rucker Rd.', NULL, 'Gilroy', 'CA', '96402',
'408-326-2332', 'S.Hayner@gmail.com');
287
288 INSERT INTO EmergencyContact VALUES
289 ('15', 'Boyd', 'Remily', '1207 Lucerne Rd.', NULL, 'Milpitas', 'CA', '96208',
'408-827-8918', 'B.Remily@yahoo.com');
290
291 INSERT INTO EmergencyContact VALUES
292 ('1', 'Hanh', 'Dieter', '2581 Heflin Rd.', NULL, 'Los Gatos', 'CA', '95339',
'510-386-1835', 'H.Dieter@gmail.com');
293
294 INSERT INTO EmergencyContact VALUES
295 ('6', 'Fallon', 'Tarwater', '2528 Kilauea Pkwy.', NULL, 'Santa Clara', 'CA', '95219',
'408-436-3275', 'F.Tarwater@gmail.com');
296
297 INSERT INTO EmergencyContact VALUES
298 ('4', 'Lennie', 'Sysak', '1382 Port Rowan St.', NULL, 'Morgan Hill', 'CA', '95836',
'510-714-2656', 'L.Sysak@gmail.com');
299
300 INSERT INTO EmergencyContact VALUES
301 ('11', 'Pa', 'Ports', '4051 Smithwood Pkwy.', NULL, 'Gilroy', 'CA', '95708',
'510-593-3263', 'P.Ports@yahoo.com');
302
303 INSERT INTO EmergencyContact VALUES
304 ('13', 'Scarlett', 'Honegger', '2890 Altamont Creek Rd.', NULL, 'Gilroy', 'CA',
'96277', '408-132-5948', 'S.Honegger@yahoo.com');
305
306 INSERT INTO EmergencyContact VALUES
307 ('7', 'Josiah', 'Lotzer', '2087 Scarborough Blvd.', NULL, 'Santa Clara', 'CA', '95865',
'408-551-7726', 'J.Lotzer@yahoo.com');
308
309 INSERT INTO EmergencyContact VALUES
310 ('9', 'Marcel', 'Scibilia', '3565 Andrea Ave.', NULL, 'Cuptertino', 'CA', '96049',
'510-611-2227', 'M.Scibilia@yahoo.com');
311
312 INSERT INTO EmergencyContact VALUES
313 ('8', 'Ena', 'Humburg', '2718 Bastia Ave.', NULL, 'Morgan Hill', 'CA', '95325',
'510-269-8267', 'E.Humburg@yahoo.com');
314
315 INSERT INTO EmergencyContact VALUES
316 ('14', 'Audria', 'Cowherd', '965 Garwood Glen Blvd.', NULL, 'Morgan Hill', 'CA',
'95518', '510-874-2458', 'A.Cowherd@gmail.com');
317