ERD for the Banking System in DBMS
Use immediately

ERD for the Banking System in DBMS

ERD for the Banking System in DBMS

Depositor

Customer

Account

M

N

Belongs to

Branch

M

1

Address

Customer Name

Customer ID

Loan Branch

Loan

1

M

Address

Branch ID

Branch Name

Has

1

Borrower

1

M

Employee

M

Payment Mode

Amount

Loan No

Account No

Balance

Employee ID

Address

Employee Name

Qualification

Salary

12
1
1
publish time: 2021-09-27
Ashley

Since ERDs make our work a lot easier for us, we will guide you step-by-step on how to create an ERD, for your Banking System, in one of the best drawing software - EdrawMax. The first step is to note down the main entities. In a banking system that has the constraints mentioned above, the main entities will be:Customer, Branch, Account, Loan, Employee. The second step is to list the attributes of the entities mentioned in the first step. Step 3: In this step, you have to analyze and identify the relationship between different entities. Based on the cardinalities, you have to place the appropriate sign. Step 4: Once you have all the relationships mapped out, now draw the actual lines. Step 5: The last step requires you to combine all the relationships formed in step 4.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
23
0
0
DILSHAN SACHINDRA