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

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 ERDtables, 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 NameDescriptionsdata typescharacter lengths.

Table Name: Customer

FieldDescriptionTypeLength
customer_ID (PK)Customer IDInt11
nameCustomer NameVarchar255
contact_addContact AddressInt11
addressAddressText

Table Name: Products

FieldDescriptionTypeLength
product_ID (PK)Product IDInt11
category_ID (FK)Category IDInt11
product_nameProduct NameVarchar225

Table Name: Categories

FieldDescriptionTypeLength
category_ID (PK)Category IDInt11
category_nameCategory NameVarchar30
category_typeCategory TypeVarchar 30

Table Name: Seller

FieldDescriptionTypeLength
seller_ID (PK)Seller IDInt11
product_ID (FK)Product IDInt11
nameNameVarchar30

Table Name: Shopping Order

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

Table Name: Payment

FieldDescriptionTypeLength
payment_ID (PK)Payment IDInt11
category_ID (FK)Category IDInt11
dateDate of PaymentDate

Table Name: Deliveries

FieldDescriptionTypeLength
delivery_ID (PK)Delivery IDInt11
customer_ID (FK)Customer IDInt11
dateDate odf DeliveryDate

Table Name: Transaction Reports

FieldDescriptionTypeLength
report_IDReport IDInt11
customer_ID (FK)Customer IDInt11
order_ID (FK)Order IDInt11
Product_ID (FK)Product IDInt11
payment_ID (FK)Payment IDInt 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

ER Diagram for E-Commerce Website
ER Diagram for E-Commerce Website

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.

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!

Related Articles:

Leave a Comment