diff options
| author | mo khan <mo.khan@gmail.com> | 2020-03-28 15:14:34 -0600 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-03-28 15:14:34 -0600 |
| commit | ebcb525d09d96759c083a227ae77a02e0c20386c (patch) | |
| tree | 1149a532b5ee3d1be9488c84a573307fa6195ccc /assignments/final/run.sql | |
| parent | d4f7bc4fcc5c2bdf2e7c07141109e6b330fa3242 (diff) | |
populate table and select data
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); |