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.
1 answer:
You might be interested in
Answer:
Explanation:
The following program is written in Java. It takes 5 inputs of int values for the ages of each member in the group. Then it loops through all of the ages and chooses the youngest age. Finally, it applies that age as a discount to the final price which would be $50, outputting the final discounted price. The output for the test case provided can be seen in the attached picture below in red.
import java.util.Scanner;
class Brainly
{
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
int[] person = new int[5];
System.out.println("Enter age of individual 1: ");
person[0] = in.nextInt();
System.out.println("Enter age of individual 2: ");
person[1] = in.nextInt();
System.out.println("Enter age of individual 3: ");
person[2] = in.nextInt();
System.out.println("Enter age of individual 4: ");
person[3] = in.nextInt();
System.out.println("Enter age of individual 5: ");
person[4] = in.nextInt();
int youngest = person[0];
for (int x = 0; x < person.length; x++) {
if (person[x] < youngest) {
youngest = person[x];
}
}
double discount = 1 - (((double)youngest) / 100);
double output = 50 * discount;
System.out.println("Total Price: " + output + " the youngest is " + youngest);
}
}
