andarge123-bli/ADVANCED_DATABASE_PROJECT_VIA_GROUP_2_SWENG-_2_YEAR_STUDENT
Domain:
socioeconomicCreator:
and
Host:
E-Commerce // High-Performance MySQL 8+ Relational Architecture This repository contains the core database architecture for a large-scale e-commerce platform specifically engineered for the Ethiopian digital economy. Designed to support 1M+ concurrent users, this system prioritizes data integrity and high-speed transaction processing.
# 🛒 Ethiopian E-Commerce Platform
### Advanced Database Systems — Group 2 Project
> **A fully-normalized, enterprise-grade distributed relational database designed for a multi-city Ethiopian e-commerce marketplace — covering Addis Ababa, Adama, and Hawassa.**
---
NO
STUDENT NAME
STUDENT ID
DEPARTMENT
1
Tilahun Tolesa
8638/17
SE
2
Yohanna Shimelis
8457/17
SE
3
Andarge Girma
8739/17
SE
4
Dinu Mohammed
8883/17
SE
5
Emnet Lema
7872/17
SE
6
Abrham Tsega
8554/17
SE
7
Alemayehu Worku
8556/17
SE
8
Biruk shiferaw
8654/17
SE
9
leul solomon
8668/17
SE
10
medaga taju
4428/16
SE
11
Hilina Tamiru
8627/17
SE
## 📋 Table of Contents
- Project Overview
- Database Architecture
- Schema Subsystems
- Lookup & Reference Tables
- User & Identity
- Product Catalog
- Inventory Management
- Orders
- Payments & Refunds
- Security & Audit
- Analytics
- Social & Promotions
- ER Diagram
- Normalization
- Security Implementation
- Distributed Design
- Query Optimization
- Project Deliverables
- Setup & Installation
- Team — Group 2
---
## 🌍 Project Overview
This project implements a **production-quality relational database** for an Ethiopian multi-vendor e-commerce platform. The platform serves sellers and buyers across multiple Ethiopian cities and is designed to handle real-world challenges including encrypted PII storage, distributed horizontal sharding, row-level security, fraud detection, and full audit trails.
| Property | Value |
|---|---|
| **Platform Name** | Ethiopia E-Commerce (`eth_ecommerce`) |
| **Database Engine** | PostgreSQL 15+ / MySQL 8+ compatible |
| **Total Tables** | 32 entities |
| **Normalization Form** | 3NF & BCNF throughout |
| **Covered Cities** | Addis Ababa · Adama · Hawassa |
| **Supported Currencies** | ETB (Ethiopian Birr) |
| **Payment Methods** | Telebirr, CBE Birr, Bank Transfer, Cash on Delivery |
| **Architecture** | Horizontally sharded distributed database |
| **Encryption** | AES-256-GCM for PII · bcryp …