summaryrefslogtreecommitdiff
path: root/assignments/1
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-01-07 18:10:38 -0700
committermo khan <mo.khan@gmail.com>2020-01-07 18:10:38 -0700
commit9c0c2fea0ff582fcec486a2b841be0ccaf2e1de7 (patch)
tree6b031fd95fa95f2a4adc96063cb444a5740b7555 /assignments/1
parent389f2762959f2ce2c6b0da298b4aa442e21a2761 (diff)
Format question for readability
Diffstat (limited to 'assignments/1')
-rw-r--r--assignments/1/README.md62
1 files changed, 37 insertions, 25 deletions
diff --git a/assignments/1/README.md b/assignments/1/README.md
index a4f9405..60e71df 100644
--- a/assignments/1/README.md
+++ b/assignments/1/README.md
@@ -78,34 +78,46 @@ course administration. Read the following detailed description of this applicati
* A course has a unique course number and title, and is assigned to one or more areas of the Computer Science program.
* Each course has an instructor, at least one teaching or research assistant, an online conference whiteboard, a time (interval), and a capacity (maximum number of participants).
* A course need not be offered each term, but the challenge option is open throughout the entire year.
-* A course may have some prerequisite courses, and a student is not allowed to register for a course if s/he has not
-fulfilled the prerequisites or their equivalent. In addition, a student who would like to challenge a course
-should have the course prerequisites or authorization from the course instructor.
-* An instructor has a first name, last name, email address, phone number, fax number, and is assigned to
-several areas of expertise. Note that two different instructors might have the same (first and last)
-names, and they might share the same fax number.
-* A student is given a unique student number. For each student, we want to record first name and last
-name, email address, phone number, postal address, and GPA. Again, the same names may belong to
-two different individuals. A student may be enrolled in several courses each term. For each enrolment,
-we want to record the grade. There are two types of student: graduate and undergraduate.
-Undergraduate students have a study major, while graduate students have both a specialization and a
-thesis topic.
-* A teaching assistant is a graduate student, and we need to record his/her first name, last name, year,
-and GPA, as well as how many courses (including the current one) the teaching assistant has already
-taught.
-* A research assistant is a student for whom we want to record the usual basic information, plus the
-number of years of work experience. The research assistant provides laboratory support for students,
-manages the conference whiteboard, and does some programming tasks.
-* An area of study is described by its name. An area may be divided into several sub-areas. These areas are
-used to categorize instructors, as well as courses. For example, the area of game development consists
-of sub-areas such as Graphics, Networking, and Human-Computer Interaction; the area of E-Services
-Technology consists of Artificial Intelligence, Networking, and Distributed Systems.
+* A course may have some prerequisite courses, and
+* a student is not allowed to register for a course if s/he has not fulfilled the prerequisites or their equivalent.
+* In addition, a student who would like to challenge a course should have the course prerequisites or authorization from the course instructor.
+* An instructor has a first name, last name, email address, phone number, fax number, and is assigned to several areas of expertise.
+* Note that two different instructors might have the same (first and last) names, and they might share the same fax number.
+* A student is given a unique student number.
+* For each student, we want to record first name and last name, email address, phone number, postal address, and GPA.
+* Again, the same names may belong to two different individuals.
+* A student may be enrolled in several courses each term.
+* For each enrolment, we want to record the grade.
+* There are two types of student:
+ * graduate
+ * graduate students have both a specialization and a thesis topic.
+ * undergraduate
+ * Undergraduate students have a study major
+* A teaching assistant is a graduate student, and we need to record his/her
+ * first name
+ * last name
+ * year
+ * GPA
+ * as well as how many courses (including the current one) the teaching assistant has already taught.
+* A research assistant is a student for whom we want to record the usual basic information, plus the number of years of work experience.
+* The research assistant provides laboratory support for students, manages the conference whiteboard, and does some programming tasks.
+* An area of study is described by its name.
+* An area may be divided into several sub-areas.
+* These areas are used to categorize instructors, as well as courses.
+ * the area of game development consists of sub-areas such as
+ * Graphics
+ * Networking
+ * Human-Computer Interaction
+ * E-Services Technology consists of
+ * Artificial Intelligence
+ * 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.
-Design an ER diagram for this course administration system. Draw the complete ER diagrams, including all aspects
-discussed in the course. Clearly state any further assumptions made, but note that you must not override the
-specifications above.
+Design an ER diagram for this course administration system.
+Draw the complete ER diagrams, including all aspects discussed in the course.
+Clearly state any further assumptions made, but note that you must not override the specifications above.
```text
courses(