diff options
| author | mo khan <mo.khan@gmail.com> | 2020-01-07 18:10:38 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-01-07 18:10:38 -0700 |
| commit | 9c0c2fea0ff582fcec486a2b841be0ccaf2e1de7 (patch) | |
| tree | 6b031fd95fa95f2a4adc96063cb444a5740b7555 /assignments | |
| parent | 389f2762959f2ce2c6b0da298b4aa442e21a2761 (diff) | |
Format question for readability
Diffstat (limited to 'assignments')
| -rw-r--r-- | assignments/1/README.md | 62 |
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( |
