Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started