The Student Enrollment Management System (SEMS) is a database application developed to streamline and enhance the student enrollment process at XYZ University. This documentation outlines the project proposal, including problem statement, proposed database solution, and an Entity-Relationship Diagram (ERD) for the system.

The manual student enrollment process at XYZ University is error-prone, leads to scheduling conflicts, and causes delays in providing essential services. These challenges necessitate the development of a robust SEMS to address the following issues:

· Lack of a centralized system for student registration.

· Scheduling conflicts due to manual enrollment.

· Inaccurate course management leading to credit-hour discrepancies.

· Limited reporting capabilities for administrators.

To solve the aforementioned issues, we propose the development of a comprehensive SEMS database application that includes the following classes/entities:

a. Student: To manage student information.

b. Subject: To represent the main subject areas, each containing multiple courses.

c. Instructor: To maintain information about instructors.

d. Assignment: To track instructor assignments to courses.

e. Enrollment: To record student enrollments in subjects.

f. Courses: To represent individual courses within a subject, including credit hours.

Student

· StudentID (Primary Key, Autoincrement, Integer)

· FirstName (Text)

· LastName (Text)

· DateOfBirth (Date)

· PhoneNumber (Text)

· Email (Text)

Instructor

· InstructorID (Primary Key, Autoincrement, Integer)

· FirstName (Text)

· LastName (Text)

· PhoneNumber (Text)

· Email (Text)

Course

· CourseID (Primary Key, Autoincrement, Integer)

· CourseTitle (Text)

· Description (Text)

· CreditHours (Integer)

· SubjectID (Foreign Key, Integer)

Enrollment

· EnrollmentID (Primary Key, Autoincrement, Integer)

· StudentID (Foreign Key, Integer)

· CourseID (Foreign Key, Integer)

· EnrollmentDate (Date)

Business Rule 1: Each student can enroll in multiple courses.

Business Rule 2: A course must have at least one enrolled student.

Business Rule 3: An instructor can teach multiple courses.

Business Rule 4: Enrollment dates must be within the academic calendar.

The ERD for SEMS is as follows:

Explanations of Relationships:

1. Student – Enrolment (One-to-Many):

· One student can have multiple enrollments.

· This relationship allows tracking of multiple enrollments by a single student.

2. Courses – Enrolments (One-to-Many):

· One course can have multiple student enrollments.

· This relationship allows you to associate multiple students with a single course.

3. Instructor – Assignment (One-to-Many):

· One instructor can have multiple teaching assignments.

· Instructors are assigned to courses.

4. Assignment – Courses (Many-to-One):

· Many assignments are associated with one course.

· This relationship links instructors' assignments to specific courses.

5. Courses – Subject (Many-to-One):

· Many courses belong to one subject.

· This relationship organizes courses into subject categories.

These relationships define how data is related and interconnected within the SEMS database. They facilitate the management of student enrolments, courses, instructors, assignments, and the organization of courses within subjects.

Top of Form

Based on feedback and further analysis, the project proposal has been enhanced with the following improvements:

· Refined problem statement.

· Improved database solution.

· Updated and refined ERD.

The prototype of the SEMS application includes the following functionalities:

· Student registration with unique Student IDs.

· Course and subject management with instructor assignments.

· Student enrollment process with conflict resolution.

The Student Enrollment Management Functionalities:

· Users can register and log in.

· Students can enroll in courses.

· Instructors can assign courses to students.

· Generate reports on enrollment data.

· Manage student and instructor information.

The final database application includes the following components:

· Development of the complete database structure.

· Creation of tables with actual student, subject, course, and instructor data.

The SEMS provides a wide range of query functionalities, including:

· Student and instructor data retrieval.

· Scheduling conflict checks.

· Enrollment history reporting.

· Credit-hour tracking.

In conclusion, the proposed Student Enrollment Management System will address critical data management challenges in educational institutions. By efficiently managing student enrollments, courses, and instructors, the system will enhance the educational experience and administrative processes.