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 PostgreSQL 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 & Physical DB Design	LogicalModel	Completed
P3	Application Scenarios (SQL)	Queries	Completed
P4	First Application Prototype	Prototype	Completed
P5	Normalization	Normalization	Planned
P6	Complex DB Reports / Procedures	Reports	Planned
P7	Advanced DB Development	AdvancedDB	Planned
P8	Advanced Application Development	Architecture	Planned
P9	Performance & Security Analysis	Final	Planned