Database Design Exercise for University Enrollment Systems.
Scenario: Prestige University is looking to upgrade its enrollment system 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 that 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 a 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, and 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 their 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 (LO1, LO2, LO3, LO4, and LO5).
Essential Activities:
- Reading Chapters 12-13 will assist you with the exercise.
- Watching the video “Database Design Process” will assist you with the exercise.
Notes:
- This paper must be formatted in APA Style 7th edition.
- This paper should have a properly formatted title page, introduction, content body, conclusion, and references.
Requirements: Explaination + Screesnshots
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.