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

Project Phases

Phase	Description	Wiki Page	Status
P0	Project Definition	About	Completed
P1	Conceptual Model (ER)	ERModel	Completed
P2	Logical & Physical DB Design	RelationalDesign	Completed
P3	Application Scenarios (SQL)	UseCaseModel	Completed
P4	First Application Prototype	PrototypeImplementation	Completed
P4	Build Instructions	BuildInstructions	Completed
P5	Normalization	Normalization	Completed
P6	Complex DB Reports / Procedures	AdvancedReports	Completed
P7	Advanced DB Development	AdvancedDatabaseDevelopment	Completed
P8	Advanced Application Development	AdvancedApplicationDevelopment	Completed
P9	Performance & Security Analysis	OtherTopics	Completed