Design a database for a bank, including information about customers and their accounts. Information about a customer includes their name, address, phone, and Social Security number. Accounts have numbers, types $($e$.$g$.,$ savings, checking$)$ and balances. Also record the customer$($s$)$ who own an account. a$.$ Create schemas for each relation using the schema notation from the book. b$.$ Provide an Entity Relational Diagram.

$2.$ Modify your solution to the first question as follows: a$.$ Change your diagram so an account can have only one customer. b$.$Further change your diagram so a customer can have only one account.