Customer-Database-Design-SQL

This project involves designing and implementing a relational database in MySQL based on customer data from an Excel file. It includes defining tables with appropriate data types and constraints, populating the database with data, and validating the design through SQL queries to ensure data integrity and functionality.

#Skills-Used:

MySQL, SQL Scripting, Database Design, Data Modeling, Table Creation, Primary Key & Foreign Key Constraints, Data Types, Data Insertion, Query Writing, Data Validation, Relational Database Concepts.

Database-Structure

Database-Table-Structure

1. Category Table

2. Customer Table

3. Employee Table

4. Orders Table

5. OrdersDetails Table

6. Products Table

7. Shippers Table

8. Suppliers Table