Tidy up assignment 1

1 files changed, 21 insertions, 4 deletions

diff --git a/assignments/1/README.md b/assignments/1/README.md
index ec410dc..c39845c 100644
--- a/assignments/1/README.md
+++ b/assignments/1/README.md
@@ -18,7 +18,7 @@ Answer the following questions (250 words max/question).
 
 * Briefly contrast and compare the following development approaches: the systems development life cycle and the prototyping methodology.
 
-The `systemd development life cycle` is a set of steps that include the following phases:
+The `system development life cycle` is a set of steps that include the following phases:
 
 * planning: gain understanding of the problem to solve and the benefit of solving the problem.
 * analysis: analyze the problem thoroughly to determine requirements.
@@ -30,8 +30,7 @@ The `prototyping methodology` is an iterative process that allows realizing valu
 
 1. identify problem
 1. design prototype
-1. implement prototype
-  * iterate on prototype
+1. implement prototype (iterate on prototype)
 1. push to production and release to users.
 
 * Discuss the difference between entity type and entity instance.
@@ -54,8 +53,10 @@ b. Weak entity
   A strong entity is a type of entity that exists independent of any other entity types.
   A weak entity is a type of entity that exists when some other type exists so it is dependent on an identifying owner.
 
+```text
   Customer (id, name)
   Address(id, customer_id, street, city, country)
+```
 
   Customer --<- Dependent
 
@@ -113,7 +114,7 @@ course administration. Read the following detailed description of this applicati
     * Networking
     * Distributed Systems
 
->> Hint: For each relation without a unique attribute or combination of attributes, introducing an artificial primary key might be a good idea.
+> Hint: For each relation without a unique attribute or combination of attributes, introducing an artificial primary key might be a good idea.
 
 Design an ER diagram for this course administration system.
 Draw the complete ER diagrams, including all aspects discussed in the course.
@@ -121,6 +122,22 @@ Clearly state any further assumptions made, but note that you must not override
 
   ![course administration ERD](./course-administration.png)
 
+Assumptions:
+
+* An instructor can also be a student.
+
+Rationale:
+
+* A discipline represents an area of interest.
+* A discipline can be a child of another discipline. (Represented as a unary relationship)
+* Each course can have 0 or more disciplines through the `course_disciplines` relation. (Represented as an Associative entity.)
+* A term represents a duration of time where courses can be offered.
+* A course may or may not be offered during a term.
+* Each student and instructor has a profile record. (Represented as a weak entity)
+* An instructor can also be a student. This would yield a instructor record, student record and a single shared profile record.
+* A scheduled course is a Associative entity that represents the offering of a course during a specific term.
+* Different instructors can teach a course but not for the same term.
+
 ### Question 4 (15 marks)
 
 For each of the following relations, identify the Normal Form(s) each relation satisfies, and transform it into 3NF.