ER Diagram for E-commerce Website

ER Diagram for E-commerce Website

The ECommerce Website ER Diagram shows how it caters the data used in ecommerce management activities w/ the use of database design (ERD). It reveals the relationships between website’s entities in the database. This displays the logical structure of databases and done by identifying entities, their properties, and the interactions between them.

The E-commerce Website ER Diagram is sketched out to form its’ database design. This sketched ER Diagram for E-Commerce Website is made up of entities, their attributes, and their relationships.

ER Diagram for E-commerce Website: Project Name and Details

The table shows the name and details of ER Diagram for E-commerce Website. It has the complete description about the project’s information.

Name:E-commerce Website ER Diagram
Abstract:E-commerce Website ER Diagram depicts the relationship between various entities. It can be thought of as a blueprint for your system (project) structure. 
Diagram:ER Diagram also known as Entity Relationship Diagram
Users:Buyers (Customer), Seller, and Website Admin
Tools Used:Diagraming tools that provides ER diagram symbols.
Designer:ITSourceCode.com
ER Diagram for E-commerce Website – Project Name and Details

Definition of E-commerce Website ER Diagram

The E-commerce Website ER Diagram is referred as the software database design. This ER Diagram is the graphical depiction of relationships between all the entities involved in the system. The ER Diagram is used to build and troubleshoot the System’s relational database. It works best with DFD (Data Flow Diagram), which is responsible for data movement.

E-commerce : questions à se poser ... x
E-commerce : questions à se poser avant de créer un site marchand ?

The ER Diagram 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 the website is the basis in handling the data throughout the process.

Importance of ER Diagram for E-commerce Website

The importance of ER Diagram for E-commerce Website is that it helps in modeling its data storage or database. It is the basis of the project’s database foundation for construction. This entity relationship diagram (ERD) also aids in defining the data types to be stored such as their attributes and characteristics.

In addition to that, the ER Diagram also describes how an entity interacts with other entities. All other real-world projects are presented with ER Diagrams (database designs).

Features of ER Diagram for E-commerce Website

  • E-Commerce Websites : The process of e-commerce website is the main feature of this system wherein its database 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 their timetables.

E-commerce Website ER 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: Customer

Table Name: Products

FieldDescriptionTypeLength
product_ID (PK)Product IDInt11
category_ID (FK)Category IDInt11
product_nameProduct NameVarchar225
Table Name: Products

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: Categories

Table Name: Shopping Order

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

Table Name: Payment

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

Table Name: Deliveries

FieldDescriptionTypeLength
delivery_ID (PK)Delivery IDInt11
customer_ID (FK)Customer IDInt11
dateDate odf DeliveryDate
Table Name: Deliveries

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
Table Name: Transaction Reports

Simple ER diagram for E-commerce Website

This Simple ER diagram for E-commerce Website shows the supposed database design of the project. It conveys the data that would be present in e-commerce website, its characteristics and connection with other data (entity).

The simple E-commerce Website ER diagram can also be considered as the website’s database diagram. This is used as the basis of the systems’ database. It store the data information and source of the outputs.

E-Commerce Website System ER Diagram
Simple ER diagram for E-commerce Website

Based on the image above, the Entity Relationship diagram for E-commerce Website is the database design presented with 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 its discussion.

ER Diagram for E-commerce Website [PDF]

The ER Diagram for E-commerce Website [PDF] provides the information explaining the concepts of project database. You may apply these information into your own capstone project. You can also use it directly or modify its content depending on your project’s requirements.

The PDF File of ER Diagram for E-commerce Website 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 E-Commerce was given for free. You may have the ER diagram for e commerce website PDF by clicking the button below.

How to build ER Diagram for E-commerce Website

Time needed: 5 minutes.

Steps in building the ER Diagram for E-commerce Website with Cardinality Ratio.

  • Step 1: Familiarize the ER Diagram (Entity Relationship Diagram) Symbols and Cardinality

    Entity Relationship Diagram – shows the structure of data types in a project. It uses symbols to clarify its parts and relationships. Their symbols and applications must be familiarized before you build the ER Diagram.

    ER Diagram Symbols:
    Fields : Fields are the parts of a table that define the entity’s characteristics. In the database that the ERD models, attributes are commonly thought of as rows.
    Keys : is a technique to categorize data qualities. It is used to organize ER diagrams and assist users in modeling their databases to ensure that they are efficient. This is also used to connect different tables in a database.
    – Primary Key : identifies a single entity instance which means a unique attribute or set of attributes.
    – Foreign Key : is produced when data attributes has one to many relationship with other entities.

    ER Diagram Cardinalities:
    The styling of a line and its termination demonstrate cardinality and ordinality.
    The greatest number of times an instance of one thing can be related to instances of another entity is referred to as cardinality.
    While Ordinality refers to the fewest number of times a single entity instance can be linked to another.

  • Step 2: Determine the targeted users

    After the symbol familiarization, you’ll need to determine your targeted users. Your targeted users will be the ones to use your project.

    Your project is E-commerce Website then your users would be the admin, book borrowers and librarian. You may ask the users of the common activities that they do when doing task in website. These information will help you in proceeding with the next step.

  • Step 3: Analyze the entities and their included attributes

    Analyzation is very important in creating ER diagram. It will help you understand the work of the diagram and avoid the unwanted errors.

    The gathered information from the users are very useful in creating the diagram. You will evaluate the data and pick the useful ones.

    From this, you will see the possible data that will enter and exit the system. But only include the useful data related to website management. Then you’re ready for the next step.

  • Step 4: Plot the Entity Relationship Diagram

    To plot the ERD you will need the entities, their attributes, and relationships. You will base the data structure from the evaluated information to have the exact Entity Relationship Diagram.

    – To design the ER Diagram, you will list first all of the entities related to E-commerce Website.
    – Then you will place the attributes included under them. This will help you create the ER Diagram Fields.
    – Do not forget the keys of the attributes. The keys will generate the potential relationships between entities.
    – Finally, you have your ER Diagram Completed.

Conclusion:

It is essential for you to know the diagrams used to design and develop the E-commerce Website. That is to help you create a fully-functional system with use of ER Diagram. Creating it will help you perceive the back end of the software. This will hold of all the data that’ll enter and exit the system.

Related Articles:

Inquiries

If you have inquiries or suggestions about ER Diagram for E-commerce Website 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