Question
For the following scenario, draw an E-R Diagram . An instructor (ssn, name, dept) teaches at least one section (offering) of a course and at
For the following scenario, draw an E-R Diagram . 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. b) Convert to tables (just fill in the blanks with table columns and attributes, including PK and Fk. Table Name Column Names
b) Convert to tables (PK and Fk.)
Table Name | Column Names |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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