The course enrollment database is designed to help organizations manage the course enrollment process each semester. The system allows students to browse and select courses, tutors to view which courses they would teach, and administrators to manage course information, student information, and tutor information.
The minimum viable product (MVP) for the course enrollment system includes the following features:
- Sign up and log in system
- Student information management
- Tutor information management
- Course enrollment for students every semester
- The view of timetable
- Course information management - Assign tutors for different courses
The database includes 7 tables with the following structure:
Student table
| Column name | Data type |
|---|---|
| StudentID (PK) | Auto |
| StudentFName | VARCHAR(50) |
| StudentLName | VARCHAR(50) |
| Gender | CHAR(1) |
| VARCHAR(50) | |
| PhoneNumber | VARCHAR(20) |
| DateOfBirth | DATE |
| ProgrammeCode (FK) | VARCHAR(10) |
CourseEnrollment table
| Column name | Data type |
|---|---|
| CourseEnrollmentID (PK) | Auto |
| Year | INT |
| Semester | CHAR(2) |
| StudentID (FK) | INT |
| CourseID (FK) | VARCHAR(10) |
| TutorID (FK) | INT |
Course table
| Column name | Data type |
|---|---|
| CourseID (PK) | VARCHAR(10) |
| CourseName | VARCHAR(65) |
| Credits | INT |
Tutor table
| Column name | Data type |
|---|---|
| TutorID (PK) | Auto |
| TutorFName | VARCHAR(50) |
| TutorLName | VARCHAR(50) |
| Gender | CHAR(1) |
| VARCHAR(50) | |
| DepartmentID (FK) | INT |
Programme table
| Column name | Data type |
|---|---|
| ProgrammeCode (PK) | VARCHAR(10) |
| ProgrammeName | VARCHAR(65) |
CourseTimetable table
| Column name | Data type |
|---|---|
| CourseTimetableID (PK) | Auto |
| Weekday | VARCHAR(10) |
| StartTime | TIME |
| EndTime | TIME |
| Classroom | VARCHAR(10) |
| CourseID (FK) | VARCHAR(10) |
Department table
| Column name | Data type |
|---|---|
| DepartmentID (PK) | Auto |
| DepartmentName | VARCHAR(65) |
| PhoneNum | VARCHAR(20) |
| Location | VARCHAR(65) |
- Clone the repository
- Set up a local SQL Server instance
- Open the project in SQL Server Management Studio (SSMS)
- Run the scripts in this repository to create the database and tables
- Use the SSMS GUI or run SQL queries to interact with the course enrollment database
Thank you for visiting, and I hope student enrollment database repository is helpful to you! If you have any questions about this repository, please ask me without hesitation.