An open-source website and desktop application designed to manage a school DB with an e-learning website for students and teachers.
This project was developed as part of the Introduction to Database Systems course at Cairo University, Faculty of Engineering. The goal of the project was to create a database system for a school, which would be used by the school's administration and the students. The system is divided into two parts: a website and a desktop application. The desktop application is used by the school's administration to manage the database, while the website is used by the students and teachers.
The database is designed using the Entity-Relationship model, and the system is implemented using PHP, HTML, CSS, JavaScript, Bootstrap, jQuery, C# .NET Framework, and MS SQL Server. The website is hosted on a local server, while the desktop application is a standalone application. The system is designed to be secure, and it uses the latest web technologies to provide a smooth user experience.
The relations included in the database are:
- Student
- Graduated Students
- Teacher
- Department
- Staff
- Room
- Bus
- Subject
- Parent
- Enrollment
- Subject Time-Locations
- Announcement
- Posts
- The Website
- Student view
- View grades/transcript
- View courses
- View schedule
- View announcements
- View course statistics
- Contact the administration/teacher
- Teacher view
- Download class list
- Add/Update grades
- View courses
- Post content to the course
- View schedule
- View/Post announcements
- View course statistics
- Contact the administration
- Student view
- The Desktop Application
- Administration view
- View students
- View teachers
- View courses
- Contact the students/teachers
- Add/Update/Delete students
- Add/Update/Delete teachers
- Add/Update/Delete courses
- Add/Update/Delete buses
- Add/Update/Delete classrooms
- View statistics/analysis
- HR view
- Accountant view
- Administration view
Distributed under the MIT License. See LICENSE for more information.