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