- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Construct an ER diagram for the Banking system in DBMS?
Draw an ER model of the Banking database application considering the following constraints −
A bank has many entities.
Each customer has multiple accounts.
Multiple customers belong to a single branch.
Single customer can borrow multiple loans.
A branch has multiple employees.
Follow the steps given below to draw an ER model of the Banking database application −
Step 1 − Identify the entity sets
The entity set has multiple instances in a given business scenario.
As per the given constraints the entity sets are as follows −
Step 2 − Identify the attributes for the given entities
Customer − the relevant attributes are customerName, CustomerID, address.
Account − The relevant attributes are AccountNo, balance.
Branch − The relevant attributes are branchID, branchName, address.
Loan − The relevant attributes are loanNo, paymentMode, dateOfLoan, and amount.
Employee − The relevant attributes are empID, empName, dateOfJoin, experience, qualification.
Step 3 − Identify the Key attributes
CustomerID is the key attribute for a customer.
AccountNo is the key attribute for Account entities.
BranchID is the key attribute for branch entities.
LoanNo is the key attribute for a loan entity.
EmpID is the key attribute for an Employee entity.
Step 4 − Identify the relationship between entity sets
One customer is enrolled by multiple accounts and one account for multiple customers. Hence, the relationship is many to many.
Many customers belong to one branch but one branch belongs to many customers. Hence, the relationship between customer and branch is many to one.
One customer can borrow multiple loans in the same way multiple loans can borrow a single customer, hence the relationship between customer and loan is one to many.
One branch has many employees and in the same way the number of employees works in a single branch.
Step 5 − Complete ER diagram
The complete ER diagram is as follows −
- Construct an ER diagram for the Library management system(DBMS)?
- Construct an ER diagram for a company in DBMS?
- Draw an ER diagram for a University database application(DBMS)?
- Explain the components of the ER diagram in DBMS?
- Minimization of ER Diagram
- What is an ER model in DBMS?
- What are the components of ER diagrams in DBMS?
- Explain the conversion of ER diagrams to tables in DBMS?
- What are constraints on ER model in DBMS?
- Explain Extended or Enhanced ER model in DBMS?
- Explain Mapping the ER diagrams with binary and ternary relationships(DBMS)?
- Basic Elements to Construct the Block-Diagram of Continuous-Time Systems
- Difference between an SAP ERP system and DBMS
- Tips for Smart and Safe Mobile Banking
- Database Management System (DBMS)