Justify decomposition

1 files changed, 8 insertions, 2 deletions

diff --git a/assignments/1/README.md b/assignments/1/README.md
index cb859a2..a237bcc 100644
--- a/assignments/1/README.md
+++ b/assignments/1/README.md
@@ -231,8 +231,14 @@ Transform this relation into 3NF. Justify any decomposition.
 
   ![one-relation](./question-5-after.png)
 
-* Each employee belongs to a single department
-* Each department can only have a single manager. To enforce this a unique constraint can be applied on `employees(department_id, manager = 1)`.
+* A separate projects relation has a surrogate key with a foreign key to the departments relation to ensure that a project can only be own by one department.
+* A phone and office relation can use the number as the primary key to ensure that the number is unique and not null.
+* Each employee relation has a surrogate key used to identify the employee.
+* Each employee relation has a foreign key reference to the department they work for.
+* The employee relation includes a foreign key to the project that they are currently working on.
+* Each department has a foreign key to the employees table to specify the single manager of the department.
+* Primary keys ensures global uniqueness within the relation and not null values.
+* Foreign key constraints ensure that a valid corresponding relation must exist in the relation that the foreign key references.
 
 ### Question 6 (15 marks)