Directions 1. Design a database for a BANK including information about customers and their accounts. Draw the ER diagram. Be sure to underline the Primary keys. CUSTOMER includes their name, address, phone number, and Social Security number. ACCOUNT includes number, types (e.g., savings, checking) and balances Each customer OWNS an account 2. Modify your solution to Number 1 as follows: a) Change your diagram so an account can have only one customer b) Change your diagram so a customer can have only one account c) Change your original diagram of question 1 so that a customer can have a set of addresses and a set of phones. d) Further modify your diagram so that customers can have a set of addresses, and at each address there is a set of phones. 3. Design a database for team sport of your choice (for example hockey, soccer). Include information about athletes and their team. Draw the ER diagram. Be sure to underline the Primary keys. ATHLETE includes their name, age, id, TEAM includes name, id, colors, city, ranking Each athlete PLAYS FOR a team and what year they started