Question: Q ) Create an entity - relationship diagram ( ERD ) using min - max notation based on the following data requirements of the University
Q Create an entityrelationship diagram ERD using minmax notation based on the following data requirements of the University database:
The university is organized into colleges, and each college has a unique number, unique name, and a particular faculty member who is the dean of the college. Each college administers a number of academic departments.
Each department has a unique name, a unique code number, and a particular faculty member who chairs the department. We need to keep track of the start date when that faculty member began chairing the department. In addition, each department may have several faculties and must be administered by one college.
A department offers several courses, each of which has a unique course name, a unique code number, a course level Level: this can be coded as for freshman level, for sophomore, for junior, for senior, for MS level, and for PhD level a course credit hour, and a course description.
The database also keeps track of faculties instructors and each faculty has a unique identifier ID name, and rank. In addition, each faculty must work for one academic department.
The database will keep student data and store each student's name composed of first name, middle name, last name student id unique address, phone, major, age, and date of birth.
A student must be assigned to one academic department. A department must have at least one student.
Courses are offered as sections. Each section has a unique identifier ID a section number this is coded as dots for multiple sections offered during the same semesteryear semester, year, classroom building code and room number within the building and daystimes
Each section must be related to a single course and taught by a single faculty. Each faculty can teach several sections each semester.
The students can enroll in various sections. A section must have at least ten students. In addition, it is required to keep track of the student's grades in each section the student has completed.
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
