Must be done in a mysql workbench EER diagram

Show the entities with all their associated attributes with their data types and constraints, primary keys, foreign key, unique keys to all attributes.

Show the relationship between the entities

SNL Bank Database will store details about the branches, customers, employees, and the types of accounts they have. A branch has a unique branch identification number. A Branch also has an Name, Address, office Number. A Customer has a unique social security number. A customer has a name, address, date of birth, email address and phone number. A branch hires employees. An employee can be a manager or staff member of that branch. An employee has a unique identification number. An employee also has a name, email and office phone number. An employee can assist one or more customers and can open one or more accounts. A customer can open an account online as well without the assistance of a SNL bank employee. Accounts can be categorized based on their type checking or savings. Accounts have a unique account number, it also has a balance, expiration date, card type, csv number and a category type. Customers can open both checking or savings accounts. A savings account has an interest rate. A checking account has an overdraft fee