🛒 FAKESHOP E-Commerce Platform

This is a full-stack database-driven e-commerce project for Level 2, Term 2. It includes complete modules for buyers, sellers, employees (including courier, customer care, and admin), and uses:

• 🔥 Vite + React for the frontend
• ⚙️ Node.js + Express for the backend
• 🛢️ Oracle Database for storage

---

📁 Project Structure

E:\FAKESHOP
│
├── backend/                # Express backend (Oracle DB connection)
├── frontend/               # Vite + React frontend
└── SQL_CODES/
    └── ALL_SQL_CODES/
        └── dumpSQL.sql     # Contains full DB schema and sample data

---

🚀 Setup Instructions

Follow these steps to run the full system after cloning:

1. Clone the Repository

git clone https://github.com/LegendaryDarkKnight/DB_PROJECT_FAKESHOP.git
cd FAKESHOP

---

2. Set Up the Oracle Database

1. Ensure Oracle DB is running.
2. Connect using SQL*Plus or any Oracle tool:

sqlplus FAKESHOP/1234@localhost/orcl

3. Run the SQL dump to initialize schema & data:

@E:\FAKESHOP\SQL_CODES\ALL_SQL_CODES\dumpSQL.sql

---

3. Backend Setup (/backend)

cd backend
npm install

Create .env File in /backend

Create a .env file in the backend folder with the following content:

DB_USER=FAKESHOP
DB_PASSWORD=1234
DB_CONNECTSTRING=localhost/orcl
PORT=3000
APP_SECRET=BUETCSEISBEST

Start Backend Server

npm test

---

4. Frontend Setup (/frontend)

cd ../frontend
npm install
npm run dev

This will start the React app on http://localhost:5173 (or another port if in use).

---

📦 Features

• 👥 User roles: Buyer, Seller, Admin, Courier, Customer Care
• 🧾 Order processing and shipment tracking
• 💬 Customer support management
• 📊 Admin control dashboard
• 🔒 Secure API with token-based authentication

---

⚠️ Notes

• Backend and frontend must be run in separate terminals.
• Oracle must be running locally with the given credentials.
• The SQL dump provides all necessary tables and sample records for quick testing.

---

👨‍💻 Author

Developed as part of Level 2, Term 2 Database Systems course.