Show the ERD with relational notation with crowfoot. Your ERD must show PK, FKs, min and max cardinality, and correct line types
.
Drexel University Financial Office has made contracts with several local banks to help students to easily obtain small loans up to $10,000 for qualified students for each year. A student can apply for loans up to 3 banks each year. For each application, student must indicate bank name, loan amount, and requested date. Obviously, a bank approves some student loans and also decline some loans depending on the student status (which is beyond the scope of this database). For each approved 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 history of payments to the loan, including payment date and payment amount. The office will record student ID, name, major, and year. 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.
Drexel University Financial Office has made contracts with several local banks to help students to easily obtain small loans up to $10,000 for qualified students for each year. A student can apply for loans up to 3 banks each year. For each application, student must indicate bank name, loan amount, and requested date. Obviously, a bank approves some student loans and also decline some loans depending on the student status (which is beyond the scope of this database). For each approved 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 history of payments to the loan, including payment date and payment amount. The office will record student ID, name, major, and year. 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:
Tension in cable BE= 196.2 N
Reactions A and D both are 73.575 N
Explanation:
The free body diagram is as attached sketch. At equilibrium, sum of forces along y axis will be 0 hence
hence
Therefore, tension in the cable,
Taking moments about point A, with clockwise moments as positive while anticlockwise moments as negative then
Similarly,
Therefore, both reactions at A and D are 73.575 N
