Question
2) a) For the following scenario, draw an E-R Diagram and convert to table. An instructor (ssn, name, dept) teaches at least one section (offering)
2) a) For the following scenario, draw an E-R Diagram and convert to table. An instructor (ssn, name, dept) teaches at least one section (offering) of a course and at most four sections. Each section is taught at a different day/time. A course (course number, course name, number of credits) may have at most three section (offering). A student (ssn, name, gpa) may not be registered in any courses and may register for at most 5 courses. A course needs at least 2 students registered. An instructor, may be a computer science, math or a music instructor. If he/she is a computer science instructor, we need to track the officeNum and the name of his/her thesis area that they supervise. For Math instructor, we need to track the level of math classes they teach (intro or advance). For music instructor, we need to track their primary instrument and secondary instrument.
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