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

---

About: Handcraft Store

Team members:

• Klimentina Efremova 235018

Short description:

This database will contain comprehensive information about handmade craft products, employees with hierarchical permission systems, customer profiles with order history, and business analytics. If we continue developing this project, we would create a full e-commerce platform that enables seamless online shopping for handmade items, efficient inventory management for store employees, and detailed business intelligence for managers. The system will manage product catalogs, customer relationships, employee permissions, and sales analytics to provide a complete solution for a handmade crafts retailer.

Detailed description of the project:

Our project aims to create a comprehensive database system for a handmade crafts e-commerce business. The system will handle product management with automatic coding, inventory tracking, customer reviews, and production timelines. It will implement a sophisticated employee management system with different permission levels (store managers, regular employees) and track all employee activities. Customer management will include order tracking, wishlists, and secure payment information storage. The analytics module will provide business intelligence on sales performance, employee productivity, and store profitability.

• The database and application are intended for a handmade crafts retailer who needs to manage their online store operations. The system owner will be responsible for maintaining the database and providing it as a service to customers browsing and purchasing products, employees managing inventory and customer service, and managers monitoring business performance across multiple store locations.

• Our project will address several key problems: inefficient manual inventory tracking, disorganized customer order management, lack of centralized employee permission systems, and insufficient business analytics. Specifically, it will solve inventory management challenges by providing real-time stock tracking, streamline customer service through organized communication logs, enforce security through hierarchical employee permissions, and enable data-driven decision making through comprehensive sales and performance analytics.

• The system will have multiple user types: Customers (who can browse products, place orders, and leave reviews), Regular Employees (with permissions for product management, customer communication, and order processing), Store Managers (with additional permissions for employee oversight and store-specific analytics), and the Business Owner (with full system access and cross-store analytics). Each user type will have different access levels and permissions appropriate to their role.

• While there are existing e-commerce solutions such as Shopify or WooCommerce, our proposal differs in its specialized focus on handmade crafts with features like production time tracking, maker-specific inventory management, and hierarchical employee permission systems tailored for craft businesses. Our approach offers integrated business analytics specifically designed for multi-location craft retailers, which provides advantages in operational efficiency and business intelligence for this specific market segment.

• This will be a web application with responsive design for both desktop and mobile access. The frontend will be built using modern JavaScript frameworks (React/Vue.js) while the backend will utilize PostgreSQL for data storage and Node.js/Python for server-side processing. The application will include separate interfaces for customers (shopping experience), employees (management dashboard), and administrators (analytics and system configuration).

---