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. ************************** 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

Queston 1:

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

Address Grame Account.no Phone nunber Balance customer Account types Social Security rambly Figure - 1: Bank Database ER diagram Database Name : BANK Customer table: . Name . Address Phone number * Social Security number: paimary Account table: * Accauit.no Prionary key types Balance