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	Link to Wiki page	Status
P0 Phase0	Project Definition	Waiting for approval
P1 Phase1	Conceptual Model (ERD)	Waiting for approval
P2 Phase2	Logical and Physical Design, DB Creation (DDL)	Not started
P3 Phase3	Application Scenarios for DB Access (SQL)	Not started
P4 Phase4	First Application Prototype	Not started
M1 Milestone1	First Prototype Public Presentation	Not started
P5 Phase5	Normalization	Not started
P6 Phase6	Complex DB Reports	Not started
P7 Phase7	Advanced Database Development	Not started
P8 Phase8	Advanced Application Development	Not started
P9 Phase9	Other Topics	Not started
M2 Milestone2	Final Presentation	Not started

---