Answered step by step
Verified Expert Solution
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 PID and CID EACH is a foreign key in SE table. Attribute SID is a foreign key in EN table, and the composite attribute CID SecID 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 teachers 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 HandDRAWN ER diagram for this database. To simplify matter, you can omit the attributes in the entity sets; but the attributes 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 handdrawn, and one point is taken off if your name is missing.
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