Scribd
Upload
25 views6 pages

E-commerce SQL Database Project Guide

The final project involves simulating an e-commerce business by creating a database with tables for products, customers, orders, and payments. It requires setting up relationships between these tables and performing queries to gain insights into product performance and customer behavior. The project includes tasks such as creating tables, inserting sample data, and generating reports on sales, orders, payments, and revenue.

Uploaded by

saraswatsarthak062
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views6 pages

E-commerce SQL Database Project Guide

The final project involves simulating an e-commerce business by creating a database with tables for products, customers, orders, and payments. It requires setting up relationships between these tables and performing queries to gain insights into product performance and customer behavior. The project includes tasks such as creating tables, inserting sample data, and generating reports on sales, orders, payments, and revenue.

Uploaded by

saraswatsarthak062
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL - Module 10

Final Project

Objective: The project will simulate an e-commerce business with various entities like
products, customers, orders, and payments. You will need to create tables for each of these
entities, set up relationships between the tables, and perform queries for business insights
like product performance and customer behaviour.

Tasks:

● Create a database:

sqlite3 [Link]

● Create Products table:

● Create Categories table:


● Create Customers table:

● Create Orders table:

● Create Payments table:


● Insert Sample Data on Categories:

● Insert Sample Data on Products:

● Insert Sample Data on Customers:

● Insert Sample Data on Orders:


● Insert Sample Data on Order Items:

● Insert Sample Data on Payments:

● Total Sales by Product:

● Number of Orders by Customer:


● Payments Received:

● Unpaid Orders:

● Revenue by Category:
Expected outcome:

You might also like