From ab40d13b5e6c2ceec1cb98f98823dfb7ce2eb183 Mon Sep 17 00:00:00 2001 From: mo khan Date: Sun, 12 Jan 2020 15:21:32 -0700 Subject: Regenerate UML --- assignments/1/README.md | 3 --- assignments/1/associative-entity.png | Bin 10257 -> 10257 bytes assignments/1/course-administration.png | Bin 88229 -> 88228 bytes assignments/1/question-5-after.png | Bin 15146 -> 19983 bytes assignments/1/question-5-after.uml | 1 + assignments/1/question-5-before.png | Bin 5153 -> 5152 bytes assignments/1/unary-relationship.png | Bin 5601 -> 5598 bytes assignments/1/weak-entity.png | Bin 7060 -> 7060 bytes 8 files changed, 1 insertion(+), 3 deletions(-) diff --git a/assignments/1/README.md b/assignments/1/README.md index d49b516..cb859a2 100644 --- a/assignments/1/README.md +++ b/assignments/1/README.md @@ -234,9 +234,6 @@ Transform this relation into 3NF. Justify any decomposition. * 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)`. -```SQL -``` - ### Question 6 (15 marks) Consider the following relations: diff --git a/assignments/1/associative-entity.png b/assignments/1/associative-entity.png index aff6ce7..b663ee1 100644 Binary files a/assignments/1/associative-entity.png and b/assignments/1/associative-entity.png differ diff --git a/assignments/1/course-administration.png b/assignments/1/course-administration.png index cf01ed9..7370fe9 100644 Binary files a/assignments/1/course-administration.png and b/assignments/1/course-administration.png differ diff --git a/assignments/1/question-5-after.png b/assignments/1/question-5-after.png index 15bc50c..79fd909 100644 Binary files a/assignments/1/question-5-after.png and b/assignments/1/question-5-after.png differ diff --git a/assignments/1/question-5-after.uml b/assignments/1/question-5-after.uml index 8c6575d..83e0894 100644 --- a/assignments/1/question-5-after.uml +++ b/assignments/1/question-5-after.uml @@ -34,6 +34,7 @@ Table(projects, "project") { } employees --> departments : "belongs to" +employees --> projects : "works on" projects --> departments : "belongs to" departments --> employees : "has one manager" @enduml diff --git a/assignments/1/question-5-before.png b/assignments/1/question-5-before.png index 52ec36b..901ec91 100644 Binary files a/assignments/1/question-5-before.png and b/assignments/1/question-5-before.png differ diff --git a/assignments/1/unary-relationship.png b/assignments/1/unary-relationship.png index 378b903..5f1d695 100644 Binary files a/assignments/1/unary-relationship.png and b/assignments/1/unary-relationship.png differ diff --git a/assignments/1/weak-entity.png b/assignments/1/weak-entity.png index 39d4c7c..0ec5190 100644 Binary files a/assignments/1/weak-entity.png and b/assignments/1/weak-entity.png differ -- cgit v1.2.3