This project presents the potential design and implementation of a student registration database system for Southeast Technological University (SETU) Waterford. It would serve SETU Waterford's three campuses. The system addresses operational inefficiencies and student welfare requirements.
I believe that there is a need for a database system that accurately stores medical records. Additionaly, because there are three Waterford campuses, scheduling conflicts occur between them leading to operational inefficiencies. Finally, health information exists in disparate systems without proper integration. The benefits of my proposed system include
- Mandatory next of kin documentation
- Integrated medical alert system which is visible to authorised personnel
- Unified student profiles across all campuses
- Location-aware scheduling to prevent location conflicts
- Automated timetable synchronisation
- Eliminating data duplication through normalisation
It has the following tables
- LOCATION
- PERSON (Superclass)
- STUDENT (Subclass)
- ACADEMIC_STAFF (Subclass)
- MEDICAL (Composition with STUDENT)
- NOK - NEXT OF KIN (Composition with student)
- FACULTY
- DEPARTMENT (Aggregation with FACULTY and LOCATION)
- COURSE
- MODULE (Taught by ACADEMIC_STAFF, part of COURSE)
- REGISTRATION (Composition with STUDENT and COURSE)
- REG_INVOICE
- PAYMENT
- RECEIPT (Composition with PAYMENT)
I populated the tables by myself. After that, I queried the data