diff options
Diffstat (limited to 'assignments/final/run.sql')
| -rw-r--r-- | assignments/final/run.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/assignments/final/run.sql b/assignments/final/run.sql index f4a6525..acdf15d 100644 --- a/assignments/final/run.sql +++ b/assignments/final/run.sql @@ -264,11 +264,12 @@ ALTER TABLE Nurses ADD CONSTRAINT care_centres_fk FOREIGN KEY (care_centre_id) R INSERT INTO Care_centres VALUES(1, 'Intensive Care Unit', 'MT-M'); INSERT INTO Nurses VALUES (1, 'Sharp', 1, 'birth', '111-222-3333', 100000); +UPDATE Care_centres SET nurse_charge_id = 1 where cid = 1; INSERT INTO Physicians VALUES (1, 'dr. mo', '555-555-5555', 'love', 10000000); INSERT INTO Physicians VALUES (2, 'dr. allison', '555-555-0001', 'head aches', 10000000); INSERT INTO Physicians VALUES (3, 'dr. didi', '555-555-0002', 'foot pain', 10000000); -INSERT INTO Physicians VALUES (4, 'dr. didi', '555-555-0003', 'back pain', 10000000); +INSERT INTO Physicians VALUES (4, 'dr. nini', '555-555-0003', 'back pain', 10000000); INSERT INTO Patients VALUES (1, 'moe sislack', '123 street nw', '777-777-7777', 1); INSERT INTO Patients VALUES (2, 'mose allison', '234 street nw', '888-888-8888', 1); |