Question

Show the ERD with relational notation with crowfoot. Drexel University Financial Office has made contracts with several local banks to help its university members to easily obtain small loans to $10,000 for each year. For this purpose, there are two types of university members - either students or employees. A student loan has a low interest rate, and students will begin to pay back after one year of their college graduation with a lixed amount per month. An employec loan has a higher interest rate than student loans, and employees need to pay certain amounts cach month from the 2nd month of the loan approvals. Each loan belongs to only one bank. Obviously, a bank approves many loans. For each loan, there is a loanff, interest rate, approved amount, monthly payment amount, and the beginning date of loan payments. For each loan, the office also keeps tracks of history of payments to the loan, including payment date and payment amount. The office also wants to know university member ID, name, and address. In addition, each student has major, while faculty and staff have the department name they work for and their job titles. For banks, we just keep bank number and name. You may add other unstated, but common-sense oriented, facts to the ERD, but you must represent the facts stated above.

Answer 1

Answer:

Detailed ERD Diagram is given in the attachment