Create an ERD with relational notation with a crows foot style, and submit an appropriate screen shot.
Question:
Create an ERD with relational notation with a “crow’s foot” style, and submit an appropriate screen shot.
Drexel University’s Financial Office has made contracts with several local banks to help its university members to easily obtain small loans of up 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 it back one year after their college graduation with a fixed amount per month. An employee loan has a higher interest rate than a student loan, and employees need to pay certain amounts each month after the 2 nd month of the loan approval. Each loan belongs to only one bank. Obviously, a bank approves many loans. For each loan, there is a loan#, interest rate, approved amount, monthly payment amount, and the beginning date of loan payments. For each loan, the office also keeps tracks of the history of payments to the loan, including payment date and payment amount. The office also wants to know the university member’s ID, name, and address. In addition, each student has a major, while faculty and staff have the department name they work for and their job titles. For banks, we just keep track of the 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. Please write out additional facts or assumptions.
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris