subject

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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 03:30
Other - a written response, no less than arial 12-point font, to the following: of the following, which would you consider is most important to customer service goals? choose one and explain why. (1) accuracy (2) punctuality and attendance (3) courtesy (4) productivity (5) organization
Answers: 1
question
Computers and Technology, 24.06.2019 17:00
Aman travel 200m towards east< br /> from his house then takes left< br /> to turn and moves 200 m north< br /> find the displacement & distance.< br />
Answers: 3
question
Computers and Technology, 24.06.2019 17:30
When you type january in a cell, then copy it using the fill handle to the cells below and the data automatically changes to february, march, april, and so on, what is this feature called? auto fill automaticcopy monthfill textfill
Answers: 1
question
Computers and Technology, 25.06.2019 01:30
Once a vulnerability has been identified by nessus, where would you check for more information regarding the identified vulnerability, exploits, and any risk mitigation solution?
Answers: 1
You know the right answer?
Show the ERD with relational notation with crowfoot. Drexel University Financial Office has made con...
Questions
question
English, 28.01.2021 19:10
question
Mathematics, 28.01.2021 19:10
question
Mathematics, 28.01.2021 19:10
Questions on the website: 13722367