This repository contains a comprehensive SQL database schema for an Amazon-like e-commerce platform. Developed as part of a database design assignment, this schema demonstrates relational database modeling for a complex online retail system.
The schema includes tables for:
- User management (Sign up, Login, User details)
- Product cataloging (Products, Categories, Brands)
- Order processing (Orders, Order details)
- Inventory management (Stock, Suppliers)
- Customer interactions (Reviews, Wishlists)
- Payment processing
- Shipping and Returns
The main SQL file Amazon.sql contains the following tables:
- Sign_up
- Log_in
- User_Table
- Payments
- Order_Table
- Category
- Brand
- Product
- Cart
- Suppliers
- Stock
- Order_Details
- Reviews
- Wishlist
- Wishlist_Details
- Returns
- Shipments
To set up the database:
- Ensure you have a MySQL server installed and running.
- Open your MySQL client or command-line interface.
- Run the following command to create the database:
CREATE DATABASE Amazon;
- Use the newly created database:
USE Amazon;
- Copy the contents of
Amazon.sqland execute them in your MySQL environment.
This project was created as part of an educational assignment. However, suggestions and improvements are welcome. Please open an issue to discuss proposed changes.
This project is licensed under the MIT License.
[Asif Ahamed] - [asif223311112@outlook.com]
Project Link: [https://github.com/asifahamed11/amazon-ecommerce-db-schema.git]
- [Course name - Database Management System]