Question 1     
    As an independent consultant you have a contract with Pures College 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 Information Systems Business Analysis. 
     Each course has an instructor, at least one teaching assistant, an online 
     conference whiteboard, a time (interval), and a capacity (maximum number of students). A course 
     need not be offered each term, but the challenge option is open the entire year. A course 
     can have prerequisite courses. Students are not allowed to register for a course if they have not 
     received credit for the prerequisites, or a course equivalent to the prerequisites. A student who would like to challenge a course 
     should also have received credit for the course prerequisites, or have an authorization from the course's instructor . 

•    An instructor has a first name, last name, email address, phone and fax numbers, and has acquired 
     several areas of expertise.  Note that two different instructors may have the same (first or last) 
     names, and/or share the same fax number 

•    A student is given a unique student number. For each student, we want to record first and last 
     name, email address, phone number, mailing address, and GPA. Again, the same names may belong to 
     two different individuals. Each term, a student may be enrolled in several courses. For each enrolment, 
     we want to record the grade. We have two types of students: graduate and undergraduate. 
     Undergraduate students have a study major, while graduate students have a specialization and a thesis topic. 
•    A teaching assistant is a graduate student, and we need to record their first and last name, year of study, 
     GPA, and the number of courses (including the current one) the teaching assistant has taught. 
     
•     A research assistant is a student for whom we want to record the usual basic information, as well as the 
     number of years of work experience. The research assistant provides lab support for students, 
     manages the conference whiteboard, and does some programming tasks. 
     
•    An area of Information Systems Business Analysis is described by its name. An area may be divided into several sub-areas. 
     Each area is used to categorize the instructors, as well as the courses. For example, the area of Multimedia consists 
     of the sub-areas of 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. 

          Tasks 1. 
 
     Design and draw a complete E-R diagram for this course administration application, including all aspects discussed in IN2203. Clearly state any additional assumptions you made, but note