Online Shopping System ER Diagram | Entity Relationship Diagram

Online Shopping System Entity Relationship Diagram

Hi there Itsourcecoders! Today I will give you ideas about the Online Shopping Entity Relationship Diagram (ERD) for 2021. This schema will also give you deep understanding about Online Shopping system database project ER Diagrams tables. This will teach you in managing shopping database as well as the relationships of tables in Online Shopping system project database design.

This ER Diagram for Online Shopping System project with table will also give you the idea on how to make a database design for a Online Shopping system with ERDtables, and schema.

The idea presented here can be used for your Online Shopping system final year project. You can enhance the ER diagram for a system in this article to meet your desired system requirements.

What are included in this ER Diagram for Online Shopping System Database projects 2021?

  • Online Shopping system Description with Features
  • Online Shopping system database tables
  • Schema diagram for Online Shopping system
  • ER Diagram for Online Shopping System

Online Shopping System ER Diagram Description

This Online Shopping system database was made based on online shopping management requirements. The system can encodes the shoppers’ information upon the buying/ordering. The admin can have access to the shoppers’ information as well as their transactions. They can handle the data needed in managing information and records the request made by the customers.

The features included in the system ER diagram were the security and monitoring of the seller information and customers’ information status. These features were also listed and recorded in reports that served as the history of transactions done in the system.

ER Diagram For Online Shopping System With Tables : Features

Time needed: 5 minutes.

Here’s the database design for Online Shopping system with ER Diagram of Online Shopping system 2021 that includes Tables, Schema, PDF, etc.

  • Shopping Management

    This feature gives the system or the user the customers’ shopping information. This will serve as the basis of the admin on what to prepare or invokes the system to give the order of the customer.

  • Customer Management

    This feature plays a big role for the system because this gathers the important information of the
    customers. These information were used for determining the choices of the customer orders and their transactions.

  • Manage Transactions

    In this feature, the admin can have and monitor the transactions that are made by the customers. This will save the transaction information as well as the important matters that were done during shopping like ordering and paying.

  • Transaction and Reports Management

    This feature will store the transactions made including their information and the reports every transactions in the corresponding timetables.

Online Shopping System 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_addCustomer ContactInt11
addressCustomer AddressText

Table Name: Categories

FieldDescriptionTypeLength
category_ID (PK)Category IDInt11
category_nameCategory NameVarchar255
category_typeCategory TypeVarchar255

Table Name: Shopping Order

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

Table Name: Deliveries

FieldDescriptionTypeLength
acc_ID (PK)Account IDInt11
customer_ID (FK)Customer IDInt11
dateDate of DeliveryDate

Table Name: Products

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

Table Name: Seller

FieldDescriptionTypeLength
seller_ID (PK)Seller IDInt11
product_ID (FK)Product NameInt11
seller_nameSeller NameVarchar255

Table Name: Payment

FieldDescriptionTypeLength
payment_ID (PK)Payment IDInt11
customer_ID (FK)Customer IDInt11
dateDate of PaymentDate

Table Name: Transaction Report

FieldDescriptionTypeLength
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

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.

Sample ER Diagram for Online Shopping System Project

Online Shopping System ER Diagram
Online Shopping System ER Diagram

Based on the image above, the ER diagram for this System is the entity of the Online Shopping system 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.

Conclusion

So that completes our discussion fellas! And I hope that this article about ER Diagram For Online Shopping System 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 Online Shopping System just leave us your comments below.

Keep us updated and Good day!

Related Articles:

Leave a Comment