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 Name, Descriptions, data types, character lengths.
Table Name: tbl_Customer
| Field | Description | Type | Length |
| customer_ID (PK) | Customer ID | Int | 11 |
| name | Customer Name | Varchar | 255 |
| contact_add | Customer Contact | Int | 11 |
| address | Customer Address | Text |
Table Name: tbl_Categories
| Field | Description | Type | Length |
| category_ID (PK) | Category ID | Int | 11 |
| category_name | Category Name | Varchar | 255 |
| category_type | Category Type | Varchar | 255 |
Table Name: tbl_Shopping Order
| Field | Description | Type | Length |
| order_ID (PK) | Order ID | Int | 11 |
| customer_ID (FK) | Customer ID | Int | 11 |
| date | Date of Order | Date |
Table Name: tbl_Deliveries
| Field | Description | Type | Length |
| acc_ID (PK) | Account ID | Int | 11 |
| customer_ID (FK) | Customer ID | Int | 11 |
| date | Date of Delivery | Date |
Table Name: tbl_Products
| Field | Description | Type | Length |
| product_ID (PK) | Product ID | Int | 11 |
| category_ID (FK) | Category ID | Int | 11 |
| product_name | Product Name | Varchar | 255 |
Table Name: tbl_Seller
| Field | Description | Type | Length |
| seller_ID (PK) | Seller ID | Int | 11 |
| product_ID (FK) | Product Name | Int | 11 |
| seller_name | Seller Name | Varchar | 255 |
Table Name: tbl_Payment
| Field | Description | Type | Length |
| payment_ID (PK) | Payment ID | Int | 11 |
| customer_ID (FK) | Customer ID | Int | 11 |
| date | Date of Payment | Date |
Table Name: tbl_Transaction Report
| Field | Description | Type | Length |
| report_ID (PK) | Report ID | Int | 11 |
| customer_ID (FK) | Customer ID | Int | 11 |
| order_ID (FK) | Order Id | Int | 11 |
| product_ID (FK) | Product Id | Int | 11 |
| payment_Id (FK) | Payment Id | Int | 11 |
ER Diagram Symbols
In this image below, you will see the different 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
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:
- ER Diagram for E commerce Website With Database Structure
- ER Diagram for Order Management System
- DFD for Online Shopping System (Data Flow Diagram)
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!