PLEASE ANSWER FULLY. EXPLAIN AS WELL.

A bank customer may have several savings and checking accounts at a bank, with each account having a current balance; joint accounts are allowed, but must have a primary holder. Assume that only savings accounts earn interest, and that checking accounts are charged a monthly fee Customers can also be issued credit cards by the bank, which have the usual information (e.g., card number, expiry date, limit (Note that a credit card is not the same as an ATM/debit card, which we will NOT be modeling It is not tied to an account.) Complication: a bank (with a name, and headquarter state may have multiple branches (branch information includes unique branch number, address, and phone) and the earlier paragraph failed to make this distinction! (a) Develop a conceptual model of this domain, and give an EER diagram capturing as much of it as possible For identification purposes, you can assume that banks (not their branches! have a unique SWIFT code (for inter-bank wire transfers), bank accounts have unique account numbers that are only 5-digits long, and persons have unique social security numbers . PLEASE USE YOUR KNOWLEDGE OF HOW YOU INTERACT WITH REAL BANKS IN CREATING THE DIAGRAM. AND PLEASE BE SURE TO EXPRESS ALL POSSIBLE CONSTRAINTS IN THE DIAGRAM. (b) Show separately any changes to parts of your EER model, if one is needed, to keep track of the history of balances for each account (from which you can reconstruct deposit/withdrawal information) (c)*Name any examples of the following IF they occur in your model: (i) relationship attributes, (ii) aggregate relationships, (iii) weak entity, (iv) reified relationship, (v) manifestation, (If your model in part (a) does not have one of these, try to add a reasonable aspect of the world that would involve it. But please do it on a separate copy of the answer.)