Question

Read the directions

Draw an ER diagram for a bank database. The database stores information about customers and their loans. Information about a customer includes the name, address, phone, SSN, and loan(s) the customer has. Loans have loan numbers, types (e.g. mortgage, car) and amount. Do not add any attributes other than the ones describe here.

Modify your design to accommodate the following constraint(s). Each constraint is independent from one another. Again, do not add any attributes other than the ones describe here. Each question modifies the original diagram independent of each other.

1. A loan belongs to exactly one customer.

2. A customer can have a set of addresses and a set of phones (but must have at least one of each). You can just draw the relevant part.

3. A customer can have a set of addresses, and at each address there is a set of phones. You can just draw the relevant part.

4. We also need to record payments made to each loan. The payments have amounts and payment numbers (e.g. 1, 2, 3, …). The payment numbers are not unique among the database, but are unique among the loan.

Answer 1