Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This question uses the same database schema as the previous SQL question:database schema Note that the attribute Dept is a foreign key in ST ,

This question uses the same database schema as the previous SQL question:database schema
Note that the attribute "Dept" is a foreign key in ST, PR, and CR table; attribute "P_ID" and "C_ID" EACH is a foreign key in SE table. Attribute "S_ID" is a foreign key in EN table, and the composite attribute "C_ID, Sec_ID" is also a foreign key in EN table.
We assume that each professor teaches zero or more courses, each course has one or more sections, each student enrolls in one or more courses, each section has one or more students. Each department has one or more students, and one or more professors, and offers zero or more courses. We also assume that the department offering the course is the same as the department of the teacher(s) for the course. A professor can teach more than one sections of the same course, whereas a student can NOT enroll in more than one sections of the same course.
Your task: upload a file containing your Hand-DRAWN E-R diagram for this database. To simplify matter, you can omit the attributes in the entity sets; but the attribute(s) associated with a relationship set (if any) should be drawn. Please write your name on the page. Two points will be deducted if your diagram is not hand-drawn, and one point is taken off if your name is missing.

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

Step: 3

blur-text-image

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

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

The numbers of participants in the study.

Answered: 1 week ago