= Online Learning Platform Management System (OLPMS) =

'''Start:''' December 2025  
'''Mentor:''' prof. dr. Vangel V. Ajanovski  

'''Team members:'''
 * Malek Alavi – 221296 – coordinator
 * Dalia Alavi – 221283

----

== Short Project Description ==

The project aims to develop an Online Learning Platform Management System that allows students and beginners to browse, purchase, and follow programming-related courses such as Structured Programming, Object-Oriented Programming, Algorithms, and Operating Systems.

The platform will provide instructors with functionality to upload and manage course materials, create modules and quizzes, and track student progress. Students will be able to enroll in courses, access lessons, track their progress, complete assessments, and obtain certificates upon successful completion.

The system will encompass various entities, including users, instructors, students, courses, lessons, categories, quizzes, enrollments, payments, progress tracking, and certificates. The goal is to design a scalable and well-structured relational database that supports a functional prototype in later stages of the project.

----

== Project Documentation ==

|| '''Phase''' || '''Phase Name''' || '''Status''' || '''Date''' ||
|| P0 || [wiki:ProjectVision Project Definition] || In progress || |
|| P1 || [wiki:ConceptualModel Conceptual Design – ER Diagram] || Not started || |
|| P2 || [wiki:LogicalPhysicalDesign Logical & Physical Design (DDL)] || Not started || |
|| P3 || [wiki:ApplicationScenarios Application Scenarios & SQL Queries] || Not started || |
|| P4 || [wiki:Prototype Application Prototype] || Not started || |
|| P5 || [wiki:Normalization Normalization] || Not started || |
|| P6 || [wiki:ComplexReports Complex Database Reports] || Not started || |
|| P7 || [wiki:AdvancedDB Advanced Database Features] || Not started || |
|| P8 || [wiki:AdvancedApplication Advanced Application Development] || Not started || |
|| P9 || [wiki:OtherDevelopments Other Developments] || Not started || |

== Conceptual Design – ER Diagram ==

The following figure presents the conceptual Entity–Relationship (ER) diagram of the Online Learning Platform Management System (OLPMS).  
It illustrates the main entities, their attributes, and the relationships between users, courses, enrollments, payments, and learning content.

[[Image(Untitled Diagram.drawio.png)]]