Scribd
Upload
14 views

basic script

Uploaded by

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

basic script

Uploaded by

22201260
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Slide 1:Hello Assalamualaikum.

My name is Muhtasin towkir and this is my partner Abdullah Bin


Hossain.today we will be presenting a database project about e commerce platform.My partner and I
have been working on this project diligently with the goal to create a seamless and user friendly online
shopping experience, where customers can browse, purchase products, and provide feedback all in one
place.
slide 2: so on the following presentation we will show you the whole structure of our database,we
will show you how the schema and Entity diagram of the whole database works. we will showcase
queries designed to extract targeted insights, highlighting the potential of data-driven decision-making.

slide 3: so as you can see on the ppt,we have total of 11 entitites in the database.the attribute to these
entities hold the intricate details for each of them.the main focus entity are product and customer.We
have created the other entity in relation to the product and customer entity.

1.
Contains information about different product categories (e.g., electronics,
o
clothing).
o Each product is assigned a category from this table.
2. Product:
o Stores details about products like name, price, company, and the category they
belong to.
o Each product has a unique identifier.
3. Inventory:
o Manages stock levels of products.
o Links to the product to track the stock count for each item.
4. Admin:
o Manages system users with their login credentials (username, password, email).
5. Customer:
o Holds customer information, such as name, contact details, address, and status
(active/inactive).
6. Wishlist:
o Customers can add products they wish to buy later.
o Contains the customer’s name, product details, and price.
7. Cart:
o A temporary storage for products a customer intends to buy before proceeding to
checkout.
o Contains product IDs and quantities selected by the customer.
8. Order:
o Records customer orders with details like customer information, total price, order
time, and status (e.g., pending, shipped).
o Links to individual order items.
9. OrderItem:
o Describes the specific products in an order.
o Tracks product quantity and pricing for each item in the order.
10. Review:
oCustomers can leave reviews for products they purchased.
oContains ratings and feedback.
11. Payment:
o Keeps track of payments made by customers.
o Includes the method of payment and payment status.

How it works together:

 Customers browse products by category, add them to their Cart or Wishlist.


 When ready, they place an Order, which includes multiple OrderItems.
 The Order is linked to Payments for the final transaction.
 After purchasing, Customers can leave Reviews for the products.
 The Inventory is updated accordingly as products are bought.

This schema ensures efficient management of customer details, product availability, orders, and
payments, creating a smooth e-commerce experience.

You might also like