Consider a Loan company database where the company needs to store the following data:

The customers will apply for one or more loans and the company needs to store their social security number , first name , last name , date of birth, address consisting of street number , street name city and zip code. The company needs to keep the following loan information : loan amount , loan date , interest rate and payoff period.

A loan can only be one of these three types: Personal Loan, Home Loan and Car Loan. For home loans, the company needs to store the home address (street, city, state and zip code and for car loan they need to store the car's year, make and model.

For each loan, the company needs to track the payments as each loan will have multiple payments. The payment information that needs to be stored are: payment date, amount and payment method. To be able to identify the loans the company would set a loan ID for each loan and the payments on each loan are going to be identified by the loan ID and date.

The employees who work in the company must have their information stores as well. Those information are: Employee ID , first and last name and date of birth . As employees will receive some commission on each loan, the company needs to store this information as well .

Draw an ER diagram for this company indicate the primary keys by underlining them . Write your assumptions if necessary .

Correct entity identification

Correct attribute and primary key identifications and correct overall notations

Correct relationship identification

Correct relationship cardinalities