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	Description	Wiki Page	Status
P0	Project Definition	About	Completed
P1	Conceptual Model (ER)	ERModel	Completed
P2	Logical Model	LogicalModel	Completed
P3	DDL Scripts	DDL	Planned
P4	Constraints	Constraints	Planned
P5	SQL Queries	Queries	Planned
P6	Views	Views	Planned
P7	Indexes	Indexes	Planned
P8	Security	Security	Planned
P9	Final Documentation	Final	Planned