Question: (50 points) Question2. Consider the university system described below: A course has a unique id, credits, title, and syllabus. Each course can have zero or

 (50 points) Question2. Consider the university system described below: A course

(50 points) Question2. Consider the university system described below: A course has a unique id, credits, title, and syllabus. Each course can have zero or several courses as pre-requisites. A student has a unique id, name, GPA. A student can be graduate or under- or grad students we store advisor and program. For under-grad students we store year. A student can have several email addresses and each email belongs to one student. Students can enroll in several courses in a semester. A grad student can be the TA of at most one course. A course can have several TAs. A. Design an ER model to capture the above information. B. Change the ER model to include the following: a. Instructors have id-number, name, department, and title. b. Store information about class-sections of a course. We store section- number, year, semester, schedule, and classroom for each class- section. c. Each class-section belongs to only one course, and can be taught by only one instructor. Every course can have zero or several class- sections. Students enroll in class-sections and grades that they received must be stored

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!