populate table and select data

2 files changed, 56 insertions, 1 deletions

diff --git a/assignments/final/README.md b/assignments/final/README.md
index 8a0dd0e..c8f9d58 100644
--- a/assignments/final/README.md
+++ b/assignments/final/README.md
@@ -465,6 +465,60 @@ ALTER TABLE Nurses ADD CONSTRAINT care_centres_fk FOREIGN KEY (care_centre_id) R
 **Populate these tables with some sample data, and write SQL queries that show the content of each table after entering the data. (6 marks)**
 
 ```sql
+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. 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);
+INSERT INTO Patients VALUES (3, 'didi kong', '345 street nw', '999-999-9999', 1);
+
+INSERT INTO Treatments VALUES(1, 1, 1, 'Surgery', '2020-03-01');
+
+SELECT * FROM Care_centres;
+SELECT * FROM Nurses;
+SELECT * FROM Physicians;
+SELECT * FROM Patients;
+SELECT * FROM Treatments;
+
+ cid |        name         | location | nurse_charge_id
+-----+---------------------+----------+-----------------
+   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
+(4 rows)
+
+
+ pid |     name     |    address    |  telephone   | care_centre_id
+-----+--------------+---------------+--------------+----------------
+   1 | moe sislack  | 123 street nw | 777-777-7777 |              1
+   2 | mose allison | 234 street nw | 888-888-8888 |              1
+   3 | didi kong    | 345 street nw | 999-999-9999 |              1
+(3 rows)
+
+
+ tid | patient_id | physician_id | treatment_name |        date
+-----+------------+--------------+----------------+---------------------
+   1 |          1 |            1 | Surgery        | 2020-03-01 00:00:00
+(1 row)
 ```
 
 
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);