E-commerce Website ER Diagram (ERD) | Entity Relationship Diagram

E-Commerce Website ERD – is applied in building the e-commerce website to foresee the back end flow or database of the website. The database design or ER diagram for e-commerce website is the basis in handling the data throughout the process.

Hi there Itsourcecoders! This time, I will be introducing to you the E-commerce Website Entity Relationship Diagram or ERD. This ERD or simple database design with tables, helps you to understand the E-commerce Website database project and how would it handle or store the given data.

The idea presented in this ERD can be used for your own E-commerce Website system final year project. You could also enhance the ER diagram for a system in this article to meet your desired system requirements.

This Entity Relationship Diagram for the E-commerce Website project with data table, will also give you ideas on how to make a database design with ERD, tables, and schema.

What are included in this ERD for E-commerce Website Database projects 2021?

E-Commerce Website Description with Features
E-Commerce Website database tables
Simple diagram for Website

E-commerce Website (ERD) Entity Relationship Diagram Description

This E-commerce Website database design was made based on managing website requirements. The system can secure and monitor the attendance of students. The school admin can have access to the students’ status during checking of attendance. all in all, they can handle and update the student attendance.

The features included in this Management system’s ERD were the security and monitoring of the student attendance records and status. These features were also listed and recorded in reports that served as the history of attendance checking done in the system.

ER Diagram For E-commerce Website With Tables and Features

Time needed: 5 minutes.

Here’s the database design for E-commerce Website with ER Diagram that includes Data Tables, Schema, PDF, etc.

E-Commerce Website
The process of e-commerce website is the main feature of this system wherein its ER diagram contains the basic details of every transactions made by the customers.
Customer Management
This feature plays a big role for the system because this gathers the important information of the customers. These information were used to track their transactions and other important matters regarding the system.
Manage Reports
The selling admin can manage the customers and products’ information as well as the status of their orders and details of their transactions.
Manage Customer Transactions
This system handles the customer transactions which determines their orders or reservation of their wants.
This will also served as the basis for the admin to track the transactions that are done in the system.
Transaction and Reports Management
This feature will store the transactions made by the customers including their information and the reports every transactions and timetables.

E-commerce Website Entity Relationship Diagram Tables

These tables below provide the complete database tables details such as Field Name, Descriptions, data types, character lengths.

Table Name: Customer

Field	Description	Type	Length
customer_ID (PK)	Customer ID	Int	11
name	Customer Name	Varchar	255
contact_add	Contact Address	Int	11
address	Address	Text

Table Name: Products

Field	Description	Type	Length
product_ID (PK)	Product ID	Int	11
category_ID (FK)	Category ID	Int	11
product_name	Product Name	Varchar	225

Table Name: Categories

Field	Description	Type	Length
category_ID (PK)	Category ID	Int	11
category_name	Category Name	Varchar	30
category_type	Category Type	Varchar	30

Table Name: Seller

Field	Description	Type	Length
seller_ID (PK)	Seller ID	Int	11
product_ID (FK)	Product ID	Int	11
name	Name	Varchar	30

Table Name: 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: Payment

Field	Description	Type	Length
payment_ID (PK)	Payment ID	Int	11
category_ID (FK)	Category ID	Int	11
date	Date of Payment	Date

Table Name: Deliveries

Field	Description	Type	Length
delivery_ID (PK)	Delivery ID	Int	11
customer_ID (FK)	Customer ID	Int	11
date	Date odf Delivery	Date

Table Name: Transaction Reports

Field	Description	Type	Length
report_ID	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

Entity Relationship Diagram for E-commerce Website

ER Diagram for E-commerce Website shows the system entity relationships in each entity and their supposed functions in each relationship.

Sample ER Diagram for E-commerce Website Project

Based on the image above, the Entity Relationship diagram for this System is the entity of the E-commerce Website database, which is presented by tables.

The tables are made to meet the required specification of the system and provide much more specific details of each entity within the system.

The purpose of this ER Diagram is to fully understand the E-commerce Website as well as the relationships of tables in the project database design. And if you like to have a reference for your project making, you can have the PDF copy of this E-Commerce Website ER Diagram.

Download the PDF File here!

Conclusion

So that completes our discussion about ER Diagram project fellas, and I hope that this article about ER Diagram For E-Commerce Website Database Design 2021 will help you a lot.

Now let me ask you something. What have you learned through the discussion?

May this article help you with your projects in the future!

If you have inquiries or suggestions about Entity Relationship Diagram (ERD) for E-commerce Website just leave us your comments below.

Keep us updated and Good day!

E-commerce Website ER Diagram (ERD) | Entity Relationship Diagram