Handcraft Marketplace

Short description:

This database system will manage all operations for a multi-vendor e-commerce marketplace specializing in handmade crafts. The database will store comprehensive information about multiple independent stores, their products (including automatically generated codes, prices, inventory levels, dimensions, available colors, and production time), customer reviews, and cross-store analytics. It will also maintain personnel records with store-specific permission systems, customer profiles with marketplace-wide order history, and comprehensive business intelligence for both store owners and marketplace administrators. If we proceed with this project, we would develop a full-stack web application that allows customers to browse and purchase handmade items from various stores, store personnel to manage their inventory and customer interactions, store owners to monitor their business performance, and marketplace administrators to oversee platform operations and analytics.

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)	Completed
P2 Phase2	Logical and Physical Design, DB Creation (DDL)	In progress
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

---