Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions