diff options
| author | mo khan <mo.khan@gmail.com> | 2020-03-28 15:36:19 -0600 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-03-28 15:36:19 -0600 |
| commit | 799e06f9c00d99796b667bbf2ae3f7cc572dbafc (patch) | |
| tree | 8a15531bbb0b70a96458908f669d602f0868d524 | |
| parent | 9bba30c898697f31d0288436b46343cb02a24401 (diff) | |
Update sample data
| -rw-r--r-- | assignments/final/README.md | 60 |
1 files changed, 41 insertions, 19 deletions
diff --git a/assignments/final/README.md b/assignments/final/README.md index 0504404..84c81d2 100644 --- a/assignments/final/README.md +++ b/assignments/final/README.md @@ -466,13 +466,25 @@ ALTER TABLE Nurses ADD CONSTRAINT care_centres_fk FOREIGN KEY (care_centre_id) R ```sql INSERT INTO Care_centres VALUES(1, 'Intensive Care Unit', 'MT-M'); + INSERT INTO Nurses VALUES (1, 'Sharp', 1, 'birth', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (2, 'Barton', 1, 'RN', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (3, 'Nightingale', 1, 'birth', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (4, 'Seacole', 1, 'RN', '111-222-3333', 50000); +INSERT INTO Nurses VALUES (5, 'Dix', 1, 'birth', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (6, 'Mahoney', 1, 'birth', '111-222-3333', 50000); +INSERT INTO Nurses VALUES (7, 'Wald', 1, 'birth', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (8, 'Sanger', 1, 'RN', '111-222-3333', 100000); +INSERT INTO Nurses VALUES (9, 'Breckinridge', 1, 'birth', '111-222-3333', 50000); +INSERT INTO Nurses VALUES (10, 'Teresa', 1, 'birth', '111-222-3333', 0); +INSERT INTO Nurses VALUES (11, 'Bertschinger', 1, 'RN', '111-222-3333', 50); + 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. nini', '555-555-0003', 'back pain', 10000000); +INSERT INTO Physicians VALUES (1, 'dr. mo', '555-555-5555', 'love', 250000); +INSERT INTO Physicians VALUES (2, 'dr. allison', '555-555-0001', 'head aches', 250000); +INSERT INTO Physicians VALUES (3, 'dr. didi', '555-555-0002', 'foot pain', 200000); +INSERT INTO Physicians VALUES (4, 'dr. nini', '555-555-0003', 'back pain', 200000); 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); @@ -491,22 +503,32 @@ SELECT * FROM Treatments; 1 | Intensive Care Unit | MT-M | 1 (1 row) - - nid | name | care_centre_id | certificate_type | telephone | salary ------+-------+----------------+------------------+--------------+-------- - 1 | Sharp | 1 | birth | 111-222-3333 | 100000 -(1 row) - - - phid | name | pager_number | specialization | salary -------+-------------+--------------+----------------+---------- - 1 | dr. mo | 555-555-5555 | love | 10000000 - 2 | dr. allison | 555-555-0001 | head aches | 10000000 - 3 | dr. didi | 555-555-0002 | foot pain | 10000000 - 4 | dr. nini | 555-555-0003 | back pain | 10000000 +Time: 0.122 ms + nid | name | care_centre_id | certificate_type | telephone | salary +-----+--------------+----------------+------------------+--------------+-------- + 1 | Sharp | 1 | birth | 111-222-3333 | 100000 + 2 | Barton | 1 | RN | 111-222-3333 | 100000 + 3 | Nightingale | 1 | birth | 111-222-3333 | 100000 + 4 | Seacole | 1 | RN | 111-222-3333 | 50000 + 5 | Dix | 1 | birth | 111-222-3333 | 100000 + 6 | Mahoney | 1 | birth | 111-222-3333 | 50000 + 7 | Wald | 1 | birth | 111-222-3333 | 100000 + 8 | Sanger | 1 | RN | 111-222-3333 | 100000 + 9 | Breckinridge | 1 | birth | 111-222-3333 | 50000 + 10 | Teresa | 1 | birth | 111-222-3333 | 0 + 11 | Bertschinger | 1 | RN | 111-222-3333 | 50 +(11 rows) + +Time: 0.113 ms + phid | name | pager_number | specialization | salary +------+-------------+--------------+----------------+-------- + 1 | dr. mo | 555-555-5555 | love | 250000 + 2 | dr. allison | 555-555-0001 | head aches | 250000 + 3 | dr. didi | 555-555-0002 | foot pain | 200000 + 4 | dr. nini | 555-555-0003 | back pain | 200000 (4 rows) - +Time: 0.077 ms pid | name | address | telephone | care_centre_id -----+--------------+---------------+--------------+---------------- 1 | moe sislack | 123 street nw | 777-777-7777 | 1 @@ -514,7 +536,7 @@ SELECT * FROM Treatments; 3 | didi kong | 345 street nw | 999-999-9999 | 1 (3 rows) - +Time: 0.083 ms tid | patient_id | physician_id | treatment_name | date -----+------------+--------------+----------------+--------------------- 1 | 1 | 1 | Surgery | 2020-03-01 00:00:00 |