Handcraft Store

Short description:

This database system will manage all operations for an e-commerce platform specializing in handmade crafts. The database will store comprehensive information about products including automatically generated codes, prices, inventory levels, dimensions, available colors, production time, and customer reviews. It will also maintain employee records with detailed permission systems, customer profiles with order history and preferences, and comprehensive sales analytics. If we proceed with this project, we would develop a full-stack web application that allows customers to browse and purchase handmade items, employees to manage inventory and customer interactions, and managers to monitor business performance through detailed analytics dashboards.

Team members:

• Klimentina Efremova 235018

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	Completed
P1 Phase1	Conceptual Model (ERD)	In Progress
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

---