diff options
| -rw-r--r-- | assignments/1/README.md | 3 | ||||
| -rw-r--r-- | assignments/1/associative-entity.png | bin | 10257 -> 10257 bytes | |||
| -rw-r--r-- | assignments/1/course-administration.png | bin | 88229 -> 88228 bytes | |||
| -rw-r--r-- | assignments/1/question-5-after.png | bin | 15146 -> 19983 bytes | |||
| -rw-r--r-- | assignments/1/question-5-after.uml | 1 | ||||
| -rw-r--r-- | assignments/1/question-5-before.png | bin | 5153 -> 5152 bytes | |||
| -rw-r--r-- | assignments/1/unary-relationship.png | bin | 5601 -> 5598 bytes | |||
| -rw-r--r-- | assignments/1/weak-entity.png | bin | 7060 -> 7060 bytes |
8 files changed, 1 insertions, 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 Binary files differindex aff6ce7..b663ee1 100644 --- a/assignments/1/associative-entity.png +++ b/assignments/1/associative-entity.png diff --git a/assignments/1/course-administration.png b/assignments/1/course-administration.png Binary files differindex cf01ed9..7370fe9 100644 --- a/assignments/1/course-administration.png +++ b/assignments/1/course-administration.png diff --git a/assignments/1/question-5-after.png b/assignments/1/question-5-after.png Binary files differindex 15bc50c..79fd909 100644 --- a/assignments/1/question-5-after.png +++ b/assignments/1/question-5-after.png 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 Binary files differindex 52ec36b..901ec91 100644 --- a/assignments/1/question-5-before.png +++ b/assignments/1/question-5-before.png diff --git a/assignments/1/unary-relationship.png b/assignments/1/unary-relationship.png Binary files differindex 378b903..5f1d695 100644 --- a/assignments/1/unary-relationship.png +++ b/assignments/1/unary-relationship.png diff --git a/assignments/1/weak-entity.png b/assignments/1/weak-entity.png Binary files differindex 39d4c7c..0ec5190 100644 --- a/assignments/1/weak-entity.png +++ b/assignments/1/weak-entity.png |
