= The ChapterX

**Short description**:

This database system will manage all operations for an AI-powered creative writing platform that integrates AI writing assistance, collaborative tools, and social networking. The database will store information about users, their stories (here will be stored info about the whole story lifecycle and all the states they can be in), and as part of the story, there will be chapters that will store information about when they were published, word count, and how many people have viewed them. To identify different stories, there will be filtering by genres. Also, people can leave comments on the stories, so comments will also be stored in the database, as well as likes. There will be analytics for the profile, like how many followers users have gained, and AI suggestions to improve the writing and profile, so notifications will be used. Writers can collaborate, so for each story, there will be permissions and user management for who created it and who can join in the management of the story. As a final function, there will be a reading list. For this platform, the final product is expected to be a full-stack application that will help writers be productive and enhance their productivity.

**Team members**:
* Kristina Srbinoska 211099

**Course**: Databases in 2025/2026/Winter  
Under the supervision of: Prof. Dr. Vangel V. Ajanovski

**Content**:

||=Phase=||=Phase Name=||=Status=||
||=P0=||[wiki:About Project Definition]||  [[span(style=color: green, Approved )]]  ||
||=P1=||[wiki:ERModel Conceptual Design - ER Diagram and Data Requirements]||  [[span(style=color: green, Approved )]]  ||
||=P2=||[wiki:RelationalDesign Logical and Physical Design - Database Creation (SQL DDL)]||  [[span(style=color: green, Approved )]]  ||
||=P3=||[wiki:UseCaseModel Application Design - Use Cases and Scenarios for Database Access]||  [[span(style=color: green, Approved )]]  ||
||=P4=||[wiki:PrototypeImplementation Prototype Application]||  [[span(style=color: green, Approved )]]  ||
||=M1=||[wiki:M1 First Prototype Public Presentation]||  [[span(style=color: green, Approved )]]  ||
||=P5=||[wiki:Normalization Normalization]||  [[span(style=color: green, Approved )]]  ||
||=P6=||[wiki:AdvancedReports Complex Database Reports]||  [[span(style=color: green, Approved )]]  ||
||=P7=||[wiki:AdvancedDatabaseDevelopment Advanced Database Development]||  [[span(style=color: green, Approved )]]  ||
||=P8=||[wiki:AdvancedApplicationDevelopment Advanced Application Development]||  [[span(style=color: green, Approved )]]  ||
||=P9=||[wiki:OtherTopics Other Topics]||  [[span(style=color: green, Approved )]]  ||
||=M2=||[wiki:M2 Final Presentation]||  [[span(style=color: green, Approved )]]  ||