Scholaris – Academic Information Management System

Short description

Scholaris is a backend-oriented database project intended for managing basic academic data within a university environment. The database is designed to store information related to an academic institution such as a university or faculty, students, professors, courses, and their relationships, such as which students are enrolled in which courses and which professors are responsible for teaching them. The goal of the project is to model a realistic academic structure and organize the data in a clear and consistent way.

If the project is further developed, it could serve as the core of an academic information system used for administrative and organizational purposes. The current implementation focuses mainly on defining the core entities and their relationships, as well as structuring the backend application in a clean and understandable way. The system is organized using a layered architecture with separate controller, service, and data access layers, and uses a MySQL database for storing the data.

At this stage, the project does not aim to provide advanced functionality, but rather to establish a solid foundation for managing educational data and to demonstrate proper database design and backend organization in the context of an academic system.

Team members:

• Elena Markovska 216009

Course: Databases in 2025/2026/Winter

Under the supervision of: ​Prof. Dr. Vangel V. Ajanovski

Content:

Phase	Link	Status
P0	About	Completed
P1	!ERModel	Planned
P2	LogicalModel	Planned
P3	!DDL	Planned
P4	!Constraints	Planned
P5	!Queries	Planned
P6	!Views	Planned
P7	!Indexes	Planned
P8	!Security	Planned
P9	!Final	Planned