SQL_ECommerce_MGMT

Relational database system for an online chocolate shop

Project Overview:

Developing a system for handling inventory, customers, orders and customer/user authentication. All implemented with SQL utilizing techniques such as stored procedures wrapped in transactions. SQL queries flavored for MySQL.

Project Components:

1. Database Design

• a. Database Schema Design
• b. Table relationships
• c. Feature Constraints

2. Data Population

• a. Sample data used for database
• b. Queries to Ensure data consistency and referential integrity

3. Basic Operations

• a. CRUD operations for managing chocolate, customers/users, and orders
• b. Allow users to add, update, and delete records from the database

4. Intermediate Queries

• a. Example queries to retrieve information such as:
  • i. Top-selling chocolate
  • ii. Customers with the highest order amounts
  • iii. Total revenue generated over a specific period
  • iv. Chocolate with low inventory levels

5. Advanced Features

• a. Transactions implemented to ensure atomicity and consistency during order processing
• b. Stored Procedures to answer specific business questions (e.g., identifying patterns in customer behavior)
• c. Query performance optimization
• d. Role-based access control to restrict access to sensitive data and operations

6. Conclusions & Next Steps

• Conclusions
• Next Steps

---

Contact Information

Contributor	Github	email	LinkedIn
Max	ImMaxRoss	max@maxross.com	maxim-ross

File Structure

.
├── data
│  └── data_sample.csv
├── static
│  ├── thank_you.jpg
├── LICENSE
├── README.md
└── sql_system_walkthrough.ipynb