Bank Management System ER Diagram | Entity Relationship Diagram

Bank Management System Entity Relationship Diagram

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

This Entity Relationship Diagram for the Bank Management System project with a table will also give you the idea of how to make a database design for a Bank management system with ERDtables, and schema.

Watch the video of Bank Management System ER Diagram full discussion

The idea presented here can be used for your Bank management 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 Bank Management System Database projects 2021?

  • Bank management system Description with Features
  • Bank management system database tables
  • Schema diagram for Bank management system
  • ER Diagram for Bank Management System

Bank Management System ER Diagram Description

This bank management system database was made based on bank requirements. The system can encode customer information. Banking admin can have access to the customer status and information for important transaction. They can handle the data needed in managing customer and employee files as well as the transactions made by the customer and staff.

The features included in the system ER diagram were the security and monitoring of the customer records, transactions and status. These features were also listed and recorded in reports that served as the history of transactions done in the system.

ER Diagram For Bank Management System With Tables : Features

Time needed: 5 minutes.

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

  • Bank Management

    Bank Management is the main feature of this system wherein ER diagram and it contains the basic details of bank.

  • 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 bank admin can manage the customers and employees’ information such as personal information, status, logs, as well as the tracking of transaction history.

  • Manage Customer Transactions

    This system handles the customer transactions which determines their desired actions for their bank account.
    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.

Bank Management 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
fnameCustomer First NameVarchar255
lnameCustomer Last NameVarchar255
contact_addCustomer ContactInt11
addressCustomer AddressText
emailCustomer EmailVarchar255
passwordCustomer PasswordVarchar255

Table Name: Admin

FieldDescriptionTypeLength
admin_ID (PK)Admin IDInt11
fnameAdmin First NameVarchar255
lnameAdmin Last NameVarchar255
addressAdmin AddressText
emailAdmin EmailVarchar255
passwordAdmin PasswordVarchar255

Table Name: Employee

FieldDescriptionTypeLength
employee_ID (PK)Employee IdInt11
fnameFirst NameVarchar30
lnameLast NameVarchar30
addressAddressText
contact_addressContact AddressInt11
emailEmailVarchar30
passwordPasswordVarchar30

Table Name: Bank Account

FieldDescriptionTypeLength
acc_ID (PK)Account IDInt11
customer_ID (FK)Customer IDInt11
acc_nameAccount NameVarchar255

Table Name: Logs

FieldDescriptionTypeLength
logs_ID (PK)Login IDInt11
trans_ID (FK)Transaction IDInt11
login_dateLogin DateDate30
login_timeLogin timeTime

Table Name: Transactions

FieldDescriptionTypeLength
transaction_ID (PK)Transaction IDInt11
employee_ID (FK)Transaction NameInt11
customer_ID (FK)Customer IDInt11
transaction_nameEmployee IDVarchar255
transaction_date Transaction DateDate

Table Name: Reports

FieldDescriptionTypeLength
report_ID (PK)Report IDInt11
acc_ID (FK)Account IDInt11
logs_ID (FK)Logs IDInt11
trans_ID Transaction IDInt11
report_nameReport nameVarchar255
report_dateReport TypeVarchar255

Entity Relationship Diagram for Bank Management System

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

Bank Management System ER Diagram
Bank Management System ER Diagram

Sample ER Diagram for Bank Management System Project

Based on the image above, the ER diagram for this System is the entity of the bank management 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 about ER Diagram project schema fellas, and I hope that this article about ER Diagram For Bank Management 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 Bank Management System just leave us your comments below.

Keep us updated and Good day!

Leave a Comment