Answered step by step
Verified Expert Solution
Link Copied!

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 E-R Diagram that satisfies the 3rd Normal Form given the following:
1. Each student has a SID, a name and an address.
2. 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."
3. Each course has a number, a name, a credit hour number, an offering department, a classroom, a maximum enrollment, and an actual enrollment.
4. The actual enrollment must be no more than the maximum enrollment.
5. Each department has an ID and a unique name.
6. Each student enrolls in a certain number of courses in this semester.
7. Each course, after assigned, is fully handled by one professor only.
8. A course can have multiple pre-requisites. A course can be a pre-requisite for multiple other courses. However, a course cannot be a pre-requisite for itself.
9. A student enrolled in a course must have enrolled in all pre-requisites.
10. More than one professor can teach a course.
There should be ONE additional table (5 total) that links Course, Student, and Professor so that there is no many-to - many relationships

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

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions