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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 17:00, shimmerandshine1
Aisha has finished working on a word processing document that contains 15 pages. she has added some special elements in the first three pages, page 9 and 10, and page 15 from the document. she wants to print only these pages to see how they look. which option is the correct way to represent (in the print dialog box) the pages that aisha wants to print
Answers: 3
image
Computers and Technology, 22.06.2019 17:30, uh8hardiek
Ou listened to a song on your computer. did you use hardware or software?
Answers: 2
image
Computers and Technology, 22.06.2019 19:00, detrickboucicaut
The fourth generation of computers emerged between 1970s and 1980s. which technological advancement brought about this generation of computers? which computer architecture was used most in this generation?
Answers: 3
image
Computers and Technology, 23.06.2019 13:30, gamingisfun
Me ! evelyn is a manager in a retail unit. she wants to prepare a report on the projected profit for the next year. which function can she use? a. pmt b. round c. division d. what-if analysis
Answers: 2
You know the right answer?
Show the ERD with relational notation with crowfoot. Drexel University Financial Office has made con...

Questions in other subjects: