ER Diagram for Online Shopping System

In this article, I’ll share some thoughts on the ER Diagram of Online Shopping System.

You will get the Online Shopping System ER diagram PDF and PPT files at the end of the talk, which will be useful for your DBMS studies.

This article will give you a full idea about the ER Diagram for an Online Shopping System with a Database Structure.

This article will give you a full idea about the ER Diagram for online shopping with Database structures.

This database for the Online Shopping System was created to meet the needs of the online shopping system.

During the buying/ordering process, the system can encode the information of the customers.

The admin has access to the information and transactions of the customers.

They can handle the data required for information management and keep track of consumer requests.

The security and monitoring of seller information and customer information status were included in the system ER diagram.

These characteristics were also listed and recorded in reports that served as a record of the system’s transactions.

Shopping Systems Entities And Their Attributes

  • Shopping Entity: Attributes of Shopping are shopping_id, shopping_name, shopping_type, shopping_description
  • Shopping Cart Entity: Attributes of Shopping Cart are shopping_cart_id, shopping_cart_name, shopping_cart_type, shopping_cart_dscription.
  • Order Entity: Attributes of Order are order_id, order_customer_id order_type, order_number, order_description.
  • Payment Entity: Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_amount, payment_description.
  • Product Entity: Attributes of Product are product_id, product_customer_id product_items, product_number, product_type, product_description.
  • Delivery Entity: Attributes of Delivery are delivery_id, delivery_customer_id, delivery_address, delivery_type, delivery_by, delivery_date, delivery description.

ER Diagram of Online Shopping System With Tables : Features

Time needed: 5 minutes

Here’s the database design for an Online Shopping system with ER Diagram of Online Shopping system 2022 that includes Tables, Schema, PDF, and etc.

  • Shopping Management

    This feature provides the system or the user with information about the customers’ shopping habits. This will act as the admin’s guide to what to prepare or how to get the system to give the customer’s order.

  • Customer Management

    This feature is crucial to the system since it collects critical client information. These details were utilized to decide on customer order options and transactions.

  • Manage Transactions

    The admin can access and monitor the transactions done by consumers using this functionality. This will store transaction information as well as crucial actions taken during the purchasing process, such as ordering and paying.

  • Transaction and Reports Management

    This function will save all transactions, including their details, as well as the reports for each transaction in the corresponding timeframe.

Online Shopping System With Database Tables

These tables below provide the complete database tables details such as Field NameDescriptionsdata typescharacter lengths.

Table Name: tbl_Customer

FieldDescriptionTypeLength
customer_ID (PK)Customer IDInt11
nameCustomer NameVarchar255
contact_addCustomer ContactInt11
addressCustomer AddressText
Customer Table

Table Name: tbl_Categories

FieldDescriptionTypeLength
category_ID (PK)Category IDInt11
category_nameCategory NameVarchar255
category_typeCategory TypeVarchar255
Categories Table

Table Name: tbl_Shopping Order

FieldDescriptionTypeLength
order_ID (PK)Order IDInt11
customer_ID (FK)Customer IDInt11
dateDate of OrderDate
Shopping Order Table

Table Name: tbl_Deliveries

FieldDescriptionTypeLength
acc_ID (PK)Account IDInt11
customer_ID (FK)Customer IDInt11
dateDate of DeliveryDate
Deliveries Table

Table Name: tbl_Products

FieldDescriptionTypeLength
product_ID (PK)Product IDInt11
category_ID (FK)Category IDInt11
product_nameProduct NameVarchar255
Product Table

Table Name: tbl_Seller

FieldDescriptionTypeLength
seller_ID (PK)Seller IDInt11
product_ID (FK)Product NameInt11
seller_nameSeller NameVarchar255
Seller Table

Table Name: tbl_Payment

FieldDescriptionTypeLength
payment_ID (PK)Payment IDInt11
customer_ID (FK)Customer IDInt11
dateDate of PaymentDate
Payment Table

Table Name: tbl_Transaction Report

FieldDescriptionTypeLength
report_ID (PK)Report IDInt11
customer_ID (FK)Customer IDInt11
order_ID (FK)Order IdInt11
product_ID (FK)Product IdInt11
payment_Id (FK)Payment IdInt11
Transaction Report Table

ER Diagram Symbols

In this image below, you will see the different ER Diagram Symbols.

ER Diagram Symbols

Entity Relationship Diagram of Online Shopping System

ER Diagram of Online Shopping System shows the system entity relationships in each entity and their supposed functions in each relationship. In creating this activity diagram we used lucidchart.

ER Diagram of Online Shopping System Project

ER Diagram for Online Shopping System Project
ER Diagram for Online Shopping System Project

The database design shown with tables in the Entity Relationship diagram of Online Shopping System is shown in the image above. The tables are designed to suit the system’s requirements and to provide considerably more detailed information about each entity within the system.

The purpose of this ER Diagram is to thoroughly comprehend both the Online Shopping System and the table relationships in the project database design. You can also get a PDF copy of the conversation if you want to use it as a reference for your project.

ER Diagram of Online Shopping [PDF]

The Entity Relationship diagram of Online Shopping System [PDF] provides the information explaining the concepts of project database. You can use this knowledge into your capstone project. You can also utilize it directly or adapt its content to meet the needs of your project.

The PDF File of Entity Relationship diagram of Online Shopping System is provided for you to have your own reference. Through this PDF file, you can modify the diagram or use the diagram into your project. This Entity Relationship diagram for Online Shopping System was given for free. You may have the ER diagram for e commerce website PDF by clicking the button below.

Conclusion:

To summarize, we have discussed about the ER diagram for Online Shopping System, and above we have the system database tables and their relationships.

Related Articles:

Inquiries

If you have inquiries or suggestions about ER Diagram of Online Shopping Project With Database Structure just leave us your comments below. We would be glad to know to concerns and suggestions and be part of your learning.

Keep us updated and Good day!

Leave a Comment