Group project made for Databases course at Jagiellonian University which implements a database for managing high school systems. The project aims to implement the basic functions of the database used to manage the school. It collects data about
Data such as first name, last name and telephone number. It is also worth adding that each person inherits from the Account entity which assigns a password and login to each user
A student grade management system that includes:
- Grades from exams
- Grades from additional activities
- F Grades for bad behaviour
Database includes a functioning school library system in which each student can borrow and return books. The database keeps track of the number of available books and charges the appropriate penalty when the borrowing date is exceeded
The database has been divided into tables of courses, classes and lessons, which allows you to create plans for each class separately
You can find more detailed project description in opis_projektu.pdf (in polish)