#ERD #ERD_BANK_DATABASE ER Diagram- HOW TO DESIGN? | ER Diagram for Bank Database System

Описание

#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