ER Diagram for Online Shopping System | ERD

ER Diagram for Online Shopping System

The ER diagram for online shopping system shows the entities’ relationships to form the database design. It is also used to describe the logical structure of the system’s database or data storage.

Designing an ER diagram is done by identifying the system’s entities, their properties, and interactions.

Moreover, the database design is sketched out using online shopping system ER diagram. The database sketch then becomes the actual basis of the system’s data storage. This will also serve as the data destination and source.

Online shopping System ER Diagram: Details

Bank Management System ER Diagram |...
Bank Management System ER Diagram | Free Entity Relationship Diagrams

The table shows the name and details of the Online Shopping System ER Diagram. It also discusses the complete description of the project’s information.

Name:Online Shopping System ER Diagram
Abstract:Online Shopping System ER Diagram depicts the relationship between various entities. It is also known as a blueprint for your system (project) structure. 
Diagram:ER Diagram is also known as Entity Relationship Diagram
Users:Shopping App Admin, Online Sellers, and Shoppers.
Tools Used:Diagraming tools that provide ER diagram symbols.
Online Shopping System ER Diagram – Details

Implementation of Online Shopping System

An online shopping system is a type of electronic commerce that allows customers to buy goods or services over the Internet. It is done via a web browser or a mobile app.

Additionally, the major goal of the online shopping system is to keep track of shopping, the internet, payment, bills, and customer information. It also keeps track of all the information related to products, customers, and shopping.

Online Shopping ER Diagram Features:

  • Shopping Management – saves the customers’ shopping information. It also serves as the admin’s basis for the order of the customer.
  • Customer Management – this feature gathers important information about the customers. The gathered information was then used to know the customer orders and transactions.
  • Manage Transactions – allows the admin to monitor the transactions made by the customers. It saves all the transactions done as well as the shopping information.
  • Transaction and Reports Management – this feature stores the transactions made by customers. It also includes the information and reports of every transaction.

What is an ER Diagram?

The ER Diagram is referred to as the online shopping system’s database design. Both ER diagram and database design illustrate the relationships between all the system’s entities. Its major components are Entities, Attributes, and Relationships.

Additionally, the ER diagram is used to build and troubleshoot relational databases. It also works best with the online shopping system DFD, which is responsible for data movement. Creating the shopping system database design would also be much easier with the help of ER diagram.

Importance of ER Diagram

The importance of ER diagram for online shopping system is to help in modeling its database design. It becomes the basis of the project’s database foundation for construction. This 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. The er diagram for online shopping system is used to display both details and attributes of a data store. It also lets us visualize how data is connected generically.

Entity-relationship diagrams are utilized in software engineering during the planning phase of software development. It also aids in the identification of various system constituents and their interrelationships.

Additionally, ER Diagram is used as the foundation of the online shopping system UML Diagrams.

Entity Relationship Diagram for Online Shopping System

ER Diagram of Online Shopping System shows the system entity relationships in each entity and their supposed functions in each relationship.

Online Shopping System ER Diagram
Online Shopping System ER Diagram

Based on the image above, the ER diagram for Online Shopping System is presented in tables. The tables include products, categories, sellers, customers, shopping orders, payments, deliveries, and transaction reports.

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

Online Shopping System Database Design

The online shopping system database design was made based on online shopping management requirements. As a result, the system should encode the shoppers’ information upon the buying/ordering.

Furthermore, the admin should have access to the shoppers’ information as well as their transactions. They can also manage shopping information and record the request made by the customers.

The system features includes the security and monitoring of the seller’s and customers’ information as well as their status. They were recorded in reports and served as the history of transactions done in the system.

Online Shopping System ER Diagram Tables

The tables below provide the complete details such as Field NameDescriptionsdata types, and character lengths. These tables represent the characteristics and the attributes of data storage.

Specifically, the field column presents the names of each database’s attributes, the description column gives the complete thought of each attribute, the type column is their data type and the length is for their character lengths.

Table Name: Customer

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

Table Name: Categories

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

Table Name: Shopping Order

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

Table Name: Deliveries

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

Table Name: Products

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

Table Name: Seller

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

Table Name: Payment

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

Table Name: Reports

report_ID (PK)Report IDInt11
customer_ID (FK)Customer ID Int11
order_ID (FK)Order IdInt11
product_ID (FK)Product IdInt11
payment_Id (FK)Payment IdInt11
Table Name: Reports

All in all, the tables are given to be the basis for developers on how would they design the online shopping system database. It has a complete description of the database. Then the developers will put this into the program.

Online Shopping System ER Diagram [PDF]

The ER Diagram for Online Shopping System PDF explains the concepts of the project database. In fact, you may apply this information to your capstone project. You can also use it directly or modify its content depending on your project’s requirements.

How to create ER Diagram

Time needed: 5 minutes.

Steps in building the ER Diagram for Online Shopping System with Cardinality Ratio.

  • Step 1: Familiarize the ER Diagram Symbols and Cardinality

    First, you need to familiarize the needed symbols.

    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 also known as rows.
    Keys is a technique to categorize data qualities. It is used to organize ER diagrams and assist users in modeling their databases. 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 have one too many relationships with other entities.

  • Step 2: Finalize the entities included

    Second, design your ER Diagram by finalizing the entities that must be included in your online shopping system. This entity is represented by a rectangle.

  • Step 3: Add the attributes of each entity

    Next, is to add the attributes to each entity. Think about the qualities you’ll need to characterize an entity. The details of the various entities outlined in a conceptual ER diagram are supplied as attributes.

    The entity’s attributes were represented by ovals and can be seen in the tables. Apart from this, the design could also be converted to the database of the system.

  • Step 4: Describe the relationships (cardinality) between entities and attributes

    Finally, plot relationships between the entities.

    A relationship is an association that describes how the entities interact. Additionally, the cardinality is indicated by a crow’s foot at the connector’s endpoints.

    Specifically, one-to-one, one-to-many, and many-to-many are the three most common cardinal relationships. It’s the maximum number of times that one entity can be linked to another entity.


In conclusion, the ER diagram is not only applied for Online Shopping System Database Design but also the foundation of other diagrams. This diagram is modeled not only to specify the exact destination of data but also the source of data.

Furthermore, the entity-relationship diagram (ERD) is considered a very important part of system development. That is because ERD serves as the project backbone. So, If you want more knowledge about ER Diagrams, you can also visit the Related Articles.

Related Articles:


So, if you have inquiries or suggestions about ER Diagram for Online Shopping System, just leave us your comments below. We would be glad to know your concerns and suggestions and be part of your learning.

Keep us updated and Good day!

Leave a Comment