Database Design Exercise for University Enrollment Systems.

Scenario: Prestige University is looking to upgrade their enrollment system in order to accommodate an increasing student body and ensure an efficient registration process. Offering various undergraduate and postgraduate programs across faculties, their administration hopes to establish a single database system which captures all enrollment data in one central location.

Specific requirements for a database system:

Student Profiles: Acquire attributes such as StudentID, Full Name, Date of Birth, Address, Email and Program Enrolled for every student enrolled. Courses: Each course has an unique CourseID, Name, Credits and Faculty designation. Enrollment Records: Track which students have registered in which courses as well as their enrollment dates.

Faculty Details: Information on each faculty, such as FacultyID, Name and Courses Offered.

Course Prerequisites: Some courses at Prestige University require students to have taken other specific classes before enrolling. Furthermore, Prestige University strives to:

Maintain data integrity and avoid redundancy with ease, facilitate easy querying for student profiles, their enrolled courses, faculty$-$specific course details and manage and update prerequisites efficiently.

Assignment:

Your goal is to design a database for Prestige University's enrollment system. An Entity$-$Relationship diagram should be drawn that illustrates all entities, their relationships, and any related attributes.

Instructions: Based on the provided scenario, identify and define entities according to its terms.

Establish relationships among them while considering appropriate cardinalities for cardinalities between entities. Integrate necessary attributes into each entity considering both primary and foreign keys as necessary.

Create an ER diagram, either digitally or using pen and paper, that represents your system's structure in detail. Also include a detailed explanation of why certain design choices were chosen with an emphasis on maintaining data integrity while decreasing redundancies and simplifying querying capabilities.

Submit your ER diagram and its explanation for evaluation, making sure it satisfies all of the scenario requirements and displays an understanding of database design principles $($LO$1,$ LO$2,$ LO$3,$ LO$4,$ and LO$5).$