Courses Management System

Short description:

The Courses Management System (CMS) is a relational database platform designed to support the full academic lifecycle of a higher-education institution. The database contains data about members (students and teachers), academic programs, courses and their editions, semester enrollments, exercises and exam assessments, grades, lecture materials, announcements, direct messaging between members, and surveys. The system consolidates these concerns into a single, coherent data model. Two security mechanisms are built into the design: member passwords are stored as SCRAM-SHA-256 hashes, and semester enrollment records are protected by a blockchain-inspired SHA-256 hash chain that makes retroactive tampering detectable. The intended application is a web-based course management platform serving a higher-education institution, with roles for students, teachers, and administrators.

Team members:

• Viktor Petrovski 231150

• Aleksandar Nikoloski 231082

• Martin Mitevski 231112

Course:

Advanced Databases in 2025/2026/Summer

Under the supervision of: Prof. Dr. Vangel V. Ajanovski and Assistant Nenad Anchev.

Content:

Phase	Link	Status	Date
P0	AboutProject	completed	20.04.2026
P1	RelationalModel	completed	21.04.2026
P2	DatabaseCreation
P3	QueryOptimization
P4	DatabaseProgramming
P5	AdvancedTopic