Pay
Loan System ER Diagram

Loan System ER Diagram

Loan Request

Date: datetime

BorrowrID: int

Deadline: datetime

Amount: numeric(19,0)

Description: varchar(255)

payday: datetime

Borrower

ID: int

AddresseeID: int

Loan Request_Lender

Loan RequestDate: datetime

LenderID: int

Amount: nemeric(19,0)

Repayment

Date: datetime

Amount: numberic(19, 0)

Load

Date: datetime

DeadlineAgreed_Date: datetime

Lender_Borrower

BorrowerID: int

LenderID: int

LoanDate: datetime

LoanDate : datetime

Percentage : int

Addressee

ID: int

Name: varchar(255)

Address: varchar(255)

Lender

ID: int

AddresseeID:int

Deadline

Agreed_Date: datetime

Intermediary

ID: int

AddresseeID: int

LoanDate: datetime

1
0
0
publish time: 2021-06-04
easy diagrams

The loan system entity relationship diagram has several entities that define how the lending system actually works. It has entities like Loan Request, Loan Request_Lender, Repayment, Lender_Borrower, Borrower, Load, and others. These entities have attributes like Loan RequestData: DateTime, LenderID: int, Amount: numeric, BorrowerID: int, Deadline: DateTime, Amount: numeric, Description: varchar, BorrowerID: int, LenderID: int, LoanDate: DateTime, LoanDate: DateTime, Percentage: int, and others. As the loan system image suggests, an entity-relationship (ER) diagram gives a snapshot of how these entities relate to each other. It should be noted here that ERD provides a visual starting point for database design that can also be used to help determine information system requirements throughout an organization.

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
22
0
0
DILSHAN SACHINDRA