0% found this document useful (0 votes)
33 views2 pages

Assignment

This document outlines an online shopping system with multiple entities and relationships. The system includes suppliers that provide products, a shopping website for browsing products organized by category, customers that can add products to carts and complete orders, and an admin interface to manage the website. Products have attributes like name, price, and status and exist within a many-to-many relationship between suppliers and categories.

Uploaded by

Avijit Hira
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
0% found this document useful (0 votes)
33 views2 pages

Assignment

This document outlines an online shopping system with multiple entities and relationships. The system includes suppliers that provide products, a shopping website for browsing products organized by category, customers that can add products to carts and complete orders, and an admin interface to manage the website. Products have attributes like name, price, and status and exist within a many-to-many relationship between suppliers and categories.

Uploaded by

Avijit Hira
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
You are on page 1/ 2

Online Shopping System

Supplier_name Product_id
Supplier 1
Cart
Quality
Supplier_id 1
Supplier_Address Supplies
Size

Added

Product_p
to
Admin_name M
Admin_id

ri ce
Website_name Product_status
Website_url Category_id
M
1 M 1 1 M
1 Shopping
has
Product
has Product
Admin has Website Category
M
Admin_role Contact_no Category_name

Procut_name

Product_id
Added

ty
to

Ci
F_name L_name
State
Payment_no
Pin_code 1 Tracking No
Payment_date Cust_id Name Address Order_no

M 1 1 1 1 M Tracking
Payment make Customer make Order has Details

Order-date Order_Ammount Courier_name


Payment_amount Contact_no
Relational Table

Product Cart Supplier


Your paragraph text

Product_id Product_id Supplier_name


Product_name Quantity Supplier_id
Product_price Size Supplier_Address
Product_id

Product Category Shopping Website Admin

Category_id Website_url Admin_id


Category_name Website_name Admin_name
Product_id Contact_no Admin_role
Product_id Website_url
Order
Your paragraph text

Category_id Product_id

Order_no
Order_date Customer Payment Tracking Detail
Order_amount
Product_id Customer_id Payment_date Order_no
Customer_name Payment_no Tracking_no
Customer_no Payment_amount Courier_name
Name Order_no Order_date
Address Customer_id
website_url

You might also like