Question
The main goal in this assignment is modelling databases. You are required to complete the following requirements for the Case University Classes in section 2
The main goal in this assignment is modelling databases. You are required to complete the following requirements for the Case University Classes in section 2 below. Keep in mind that an ERD cannot model all aspects of a database application. Read the entire document first. Then, model all the related Entities and relationships. For each entity, you should indicate its attributes, primary key (simple or composite), and foreign key(s). Develop the following three items: Item-1: Dependency Diagrams for each entity type (show that there are no partial or transitive dependencies); Item-2: a completed E-R diagram that satisfies the 3rd Normal Form, along with its corresponding Transformed Flat Tables; Item-3: a completed Data Dictionary.
2. SCENARIO: UNIVERSITY CLASSES This scenario models the courses, students, professors, departments, and the like at a single university in a single semester. Based on the following scenario, you are expected to figure out an associative entity, a self-recursive relationship, and the aspects that cannot be reflected in your ERD.
(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 its pre-requisites. (10) At this university, more than one professor can teach a course
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