From 063c8562ae6b5d618dbce54e1dfc06849bbd4f40 Mon Sep 17 00:00:00 2001
From: mo khan <mo.khan@gmail.com>
Date: Sat, 4 Apr 2020 10:43:53 -0600
Subject: Bring back the original diagrams

---
 assignments/final/README.md     |   5 ++---
 assignments/final/erd.png       | Bin 66955 -> 66955 bytes
 assignments/final/module-1.png  | Bin 28944 -> 28945 bytes
 assignments/final/module-2.png  | Bin 60565 -> 65427 bytes
 assignments/final/module-2.puml |  17 ++++++++++++-----
 5 files changed, 14 insertions(+), 8 deletions(-)

diff --git a/assignments/final/README.md b/assignments/final/README.md
index 61db522..2a489d1 100644
--- a/assignments/final/README.md
+++ b/assignments/final/README.md
@@ -118,7 +118,7 @@ requiring an associated outpatient owner entity.
 
 **Draw an EER diagram to accurately represent this set of requirements. State any assumption you had to make in developing the diagram.**
 
-  <!--![EER](./module-1.png)-->
+  ![EER](./module-1.png)
   ![ERD](./erd.png)
 
 I have chosen to model the different types of staff as subclasses of a `Staff` class.
@@ -153,8 +153,7 @@ care that they need.
 
 **Map the EER diagram to a relational schema, and transform the relation into 3NF**
 
-  <!--![relational schema](./module-2.png)-->
-  <!--![ERD](./erd.png)-->
+  ![relational schema](./module-2.png)
 
 ```sql
 CREATE TABLE accounts (
diff --git a/assignments/final/erd.png b/assignments/final/erd.png
index 55c345f..4ed5189 100644
Binary files a/assignments/final/erd.png and b/assignments/final/erd.png differ
diff --git a/assignments/final/module-1.png b/assignments/final/module-1.png
index de765e9..55a88d8 100644
Binary files a/assignments/final/module-1.png and b/assignments/final/module-1.png differ
diff --git a/assignments/final/module-2.png b/assignments/final/module-2.png
index c33e622..d806832 100644
Binary files a/assignments/final/module-2.png and b/assignments/final/module-2.png differ
diff --git a/assignments/final/module-2.puml b/assignments/final/module-2.puml
index e987a31..da483e7 100644
--- a/assignments/final/module-2.puml
+++ b/assignments/final/module-2.puml
@@ -19,17 +19,17 @@ Table(accounts, "accounts") {
 
 Table(beds, "beds") {
   primary_key(id)
-  foreign_key(care_centre_id)
-  foreign_key(patient_id)
   bed_number
   room_number
+  foreign_key(care_centre_id)
+  foreign_key(patient_id)
   created_at
   updated_at
 }
 
 Table(care_centres, "care_centres") {
   primary_key(id)
-  foreign_key(employee_id)
+  foreign_key(nurse_id)
   name
   location
   created_at
@@ -39,7 +39,6 @@ Table(care_centres, "care_centres") {
 Table(consumptions, "consumptions") {
   primary_key(id)
   foreign_key(patient_id)
-  foreign_key(employee_id)
   foreign_key(item_id)
   consumed_at
   quantity
@@ -98,7 +97,6 @@ Table(staff, "staff") {
 
 Table(treatments, "treatments") {
   primary_key(id)
-  foreign_key(physician_id)
   foreign_key(patient_id)
   name
   number
@@ -117,6 +115,14 @@ Table(visits, "visits") {
   updated_at
 }
 
+Table(volunteers, "volunteers") {
+  primary_key(id)
+  foreign_key(account_id)
+  skill
+  created_at
+  updated_at
+}
+
 beds --> care_centres : "belongs to"
 beds --> patients : "belongs to"
 
@@ -126,6 +132,7 @@ consumptions --> staff : "belongs to"
 
 patients --> accounts : "belongs to"
 patients --> staff : "belongs to"
+volunteers --> accounts : "belongs to"
 
 shifts --> care_centres : "belongs to"
 shifts --> staff : "belongs to"
-- 
cgit v1.2.3