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.
