1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Bogdan [553]
3 years ago
13

Show the ERD with relational notation with crowfoot. Drexel University Financial Office has made contracts with several local ba

nks 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.

Computers and Technology
1 answer:
andreyandreev [35.5K]3 years ago
3 0

Answer:

Detailed ERD Diagram is given in the attachment

You might be interested in
When doing a Risk assessment, what is one of the most important things to do?
GaryK [48]

Answer:

Determine who might be harmed and how.

8 0
2 years ago
Read 2 more answers
If you're searching for a date and a product at the same time, you're running a _______ query. A. Complex B. Select C. Parameter
Andrews [41]

If you're searching for a date and a product at the same time, you're running a _______ query. A. Complex B. Select C. Parameter D. Range                                                                                                                                                                                                                                                         A. Complex

6 0
3 years ago
When should you integrate technology?​
earnstyle [38]
Nolur acil lütfen yalvarırım yalvarırım lütfen yalvarırım when should you integrate technology?
5 0
3 years ago
Read 2 more answers
If you're unsure of what chart to use for a set of data, what feature does Excel include that will help you to decide? A. Sparkl
asambeis [7]
If what I found is correct it would be C, all charts... If not that then it would be B.
6 0
3 years ago
Read 2 more answers
An example for Shareware?
Kryger [21]
A software that is free of cost for a certain amount of time such as Adobe programs, or Winzip.
6 0
2 years ago
Read 2 more answers
Other questions:
  • What is the primary purpose for a screen saver in windows?
    8·1 answer
  • Given that arrayIntValues [MAX_ROWS][MAX_COLUMNS] is a 2 dimensional array of positive integers, write a C++ function Even to fi
    15·1 answer
  • How were the pages made to create the Book of Kells? a. Scribes prepared the papers using a printing press. b. 185 calves were s
    9·1 answer
  • A ____ appearing in the main text of a document indicates a footnote or endnote.
    15·1 answer
  • Software that instructs the computer how to run applications and controls the display/keyboard is know as the
    8·1 answer
  • Draw a logic circuit for the function F = (A + B)(B + C)(A + C), using NOR gates only. ​
    9·1 answer
  • Explain the importance of mobile computing in communication​
    5·1 answer
  • Malwar is the short form for malicious software and used to refer​
    14·1 answer
  • 2 ways to make your computer work faster ( please help asap )
    6·1 answer
  • A method that determines if a list is empty in a consistently written linked list class that uses a reference first to point to
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!