Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make an E - R Diagram that satisfies the 3 rd Normal Form given the following: 1 . Each student has a SID, a name
Make an ER Diagram that satisfies the rd Normal Form given the following:
Each student has a SID, a name and an address.
A professor has a PID, a name, and belongs to a department. The age of a professor can be one of "old", "very old", and "still alive."
Each course has a number, a name, a credit hour number, an offering department, a classroom, a maximum enrollment, and an actual enrollment.
The actual enrollment must be no more than the maximum enrollment.
Each department has an ID and a unique name.
Each student enrolls in a certain number of courses in this semester.
Each course, after assigned, is fully handled by one professor only.
A course can have multiple prerequisites. A course can be a prerequisite for multiple other courses. However, a course cannot be a prerequisite for itself.
A student enrolled in a course must have enrolled in all prerequisites.
More than one professor can teach a course.
There should be ONE additional table total that links Course, Student, and Professor so that there is no manyto many relationships
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