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	Project Definition	Approved
P1	Conceptual Design - ER Diagram and Data Requirements	Approved
P2	Logical and Physical Design - Database Creation (SQL DDL)	Approved
P3	Application Design - Use Cases and Scenarios for Database Access	Approved
P4	Prototype Application	Approved
M1	[M1 First Prototype Public Presentation]	Approved
P5	Normalization	DONE
P6	Complex Database Reports	Approved
P7	Advanced Database Development	Approved
P8	Advanced Application Development	Approved
P9	Other Topics	Approved
M2	[Final Presentation]	DONE