Question: 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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
