Draw up an Enhanced Entity Relationship Diagram (EERD) for the following scenario A University is seeking IT support for the development of its enterprise system which will be used by the students, registrars office and office of student services This enterprise information system will have a single shared database The system will be used to manage certain processes in the university The three processes are enrollment, admission and dormitory management Staff are from the Student Services and from Registrars office Staff details need to be stored including the staff identification number, name, gender, address, contact number, email and password Student details that need to be stored including student identification number, name, gender, address, contact number, email and password Details about units offered also need to be kept, including the code, name and description Each unit has multiple offerings An offering refers to when a particular unit is offered For example, IS303 is a unit It is offered in Semester 1, 2015 Semester 1, 2016, etc Information about enrollment need to be kept, including the mark and grading scored by the student in a particular unit offering he she has enrolled in Students can only enroll in four offerings per semester Information about dormitories that students are allocated need to be kept Dormitories have names Each dormitory can have multiple floors, which also has multiple rooms When a student is accepted into the university, the students account is created and he or she is provided with an identification number, email and password The email and password will be used by the student to log onto the system At the beginning of the semester, the students will use the system to enroll into the units they will be studying during the semester The students can only enroll in four offerings per semester When a new staff member is recruited, his her account is created and provided with an identification number, email and password, which are required to log onto the system

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 15, 2024

Draw up an Enhanced Entity Relationship Diagram (EERD) for the following scenario: A University is seeking IT support for the development of its enterprise system

Draw up an Enhanced Entity Relationship Diagram (EERD) for the following scenario:

A University is seeking IT support for the development of its enterprise system which will be used by the students, registrars office and office of student services. This enterprise information system will have a single shared database. The system will be used to manage certain processes in the university. The three processes are enrollment, admission and dormitory management. Staff are from the Student Services and from Registrars office.

Staff details need to be stored including the staff identification number, name, gender, address, contact number, email and password.

Student details that need to be stored including student identification number, name, gender, address, contact number, email and password.

Details about units offered also need to be kept, including the code, name and description.

Each unit has multiple offerings. An offering refers to when a particular unit is offered. For example, IS303 is a unit. It is offered in Semester 1, 2015; Semester 1, 2016, etc.

Information about enrollment need to be kept, including the mark and grading scored by the student in a particular unit offering he/she has enrolled in. Students can only enroll in four offerings per semester.

Information about dormitories that students are allocated need to be kept. Dormitories have names. Each dormitory can have multiple floors, which also has multiple rooms.

When a student is accepted into the university, the students account is created and he or she is provided with an identification number, email and password. The email and password will be used by the student to log onto the system. At the beginning of the semester, the students will use the system to enroll into the units they will be studying during the semester. The students can only enroll in four offerings per semester. When a new staff member is recruited, his/her account is created and provided with an identification number, email and password, which are required to log onto the system.