#ERD
#ERD #ERD_BANK_DATABASE ER Diagram- HOW TO DESIGN? | ER Diagram for Bank Database System
Steps to Design ER Diagrams:
1) Identify the entity sets (including weak entity set)
Employees
Customers
Accounts
Branch
Loan
Payment (Weak entity set)
2) Identify all attributes of each entity set.
Ex:
Employee: Emp_id, Ename,Address, Email_id, DOJ, etc
3) Identify the relationship that exist between two entity sets.
Ex: In between Customer and Account, there is a Depositor relationship.
4) Join the entity set to relationship set and entity set to attributes via lines.
5) Show the mapping cardinality constraints in between different entity sets.
Source: Database System Concepts | 6th Edition Book by Henry F Korth