As an independent consultant, you have a contract with the local University to develop an application to support course administration. Read the following detailed description of this application, and complete the tasks listed below.

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.

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.