Q) Create an entity-relationship diagram (ERD) using min-max notation based on the following data requirements of the University database: 1. 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. 2. 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. 3. 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 1 for freshman level, 2 for sophomore, 3 for junior, 4 for senior, 5 for MS level, and 6 for Ph.D. level), a course credit hour, and a course description. 4. 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. 5. 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. 6. A student must be assigned to one academic department. A department must have at least one student. 7. Courses are offered as sections. Each section has a unique identifier (ID), a section number (this is coded as 1, 2, 3, . . . for multiple sections offered during the same semester/year), semester, year, classroom (building code and room number within the building), and days/times. 8. Each section must be related to a single course and taught by a single faculty. Each faculty can teach several sections each semester. 9. 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
Make an Entity relationship diagram and use the Erdplus and apply these requirments
Using the Erdplus(use it to make this diagram, the answer should be as a Diagram)
Q) Create an entity-relationship diagram (ERD) using min-max notation based on the following data
requirements of the University
1. 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.
2. 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.
3. 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 1 for freshman level, 2 for sophomore, 3 for junior, 4 for senior, 5 for MS level,
and 6 for Ph.D. level), a course credit hour, and a course description.
4. 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.
5. 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.
6. A student must be assigned to one academic department. A department must have at least one student.
7. Courses are offered as sections. Each section has a unique identifier (ID), a section number (this is coded as 1, 2,
3, . . . for multiple sections offered during the same semester/year), semester, year, classroom (building code
and room number within the building), and days/times.
8. Each section must be related to a single course and taught by a single faculty. Each faculty can teach several
sections each semester.
9. 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
Solved in 3 steps with 2 images
