Draw an ER diagram accordingly to the following user requirements. You can draw the diagram using tools that you prefer $($such as Word, Visio$),$ but you must follow the ER notation that we are using in this course. Please submit a PDF file to Canvas. List assumptions for your diagram, if there is any. In this course, hand written submission will result in a Zero.

RCR Bank needs to keep the following information in its database. Customer information is collected, including SSN$,$ name $($first name, last name$),$ phone number, and address. When a person owns an account, the person becomes a customer of the bank. The bank database keeps track of account information, including account number $($unique$),$ account balance, type of account $($e$.$g$.$ saving, checking$),$ and the monthly fee associated with the account. When a customer opens a new account, the date to open the account is the same as the date the customer owns the account. New customers can be added to an existing account after the account was opened. We need the date when a customer starts to own an account. A customer is allowed to own many accounts. Any account must be owned by at least one customer.

When a person has a loan with the bank, this person is also considered as a customer of the bank. The bank database keeps track of loan information. A loan has a loan number $($unique$),$ total amount of the loan, the loan type $($e$.$g$.$ mortgage$),$ and the interest rate. A loan has a number of payments. Each payment has a payment number $($e$.$g$.1,2,3)$ that is unique with respect to a loan. Each payment has an amount, the method for the payment $($e$.$g$.$ by check, autopay$),$ and a status $($e$.$g$.$ paid on time, or late$),$ and a due date. A customer is allowed to borrow many loans. A loan can be borrowed by many customers, at least one.

The bank also keeps track of the information of its branches. Each branch has a branch name $($unique$)$ and an address. Each customer has at most one favorite branch that he$/$she visits most frequently. If a customer never goes to a branch $($for example, only use online banking$),$ he$/$she does not have a favorite branch. A branch can be the favorite of many customers, at least one.