This project implements a relational database for an online store.
The system models the main components of an e-commerce platform, including customers, products, orders, suppliers, employees, invoices, reviews, and wishlists. The project demonstrates database design principles, normalization, and advanced SQL queries.
The database simulates the functionality of an online store where customers can browse products, place orders, leave reviews, and manage wishlists. The platform also manages suppliers, employees responsible for processing orders, and invoice generation.
Main functionalities modeled in the database:
- product and inventory management
- customer registration and order tracking
- supplier and category management
- order processing and delivery tracking
- product reviews and ratings
- wishlist management
- invoice generation
The database was designed following the standard database design process:
- real-world system analysis (online store model)
- entity-relationship modeling
- conceptual schema design
- transformation to relational schema
- normalization up to Third Normal Form (3NF)
Normalization ensures that the database avoids redundancy and maintains data integrity.
- SQL (Oracle SQL dialect)
- Relational Database Design
- Entity-Relationship Modeling
- Data Normalization (1NF – 3NF)
- SQL Constraints, Triggers and Sequences
- creation of relational tables with primary and foreign keys
- use of constraints (NOT NULL, UNIQUE, CHECK)
- implementation of triggers for data validation
- sequences for automatic ID generation