There is always one employee assigned to manage that branch


ABC Bank has many branches. Each branch has a unique name, an address (including No., Street, District, City, and Region), phone numbers, fax numbers, email, and total number of employees working there. Each branch has many employees and an employee must work at a branch. There is always one employee assigned to manage that branch. The employee can only manage the office to 
which he or she is assigned. For each employee, we need to store a unique code, first name, last name, date of birth, phone numbers, email, and home address (including No., Street, District, and City). The bank issues three different types of bank accounts for their customers. For Savings Accounts, the bank must keep track of the account's balance, interest rate, and the date the account 
was opened. Checking Accounts pay no interest, so the bank keeps track of just the balance and date opened. The third type of account, Loans, requires tracking the date the loan was taken, the balance due, and the interest rate of the loan. Each customer may have any number of bank accounts, and all accounts have a unique account number. The bank save the following information 
of each customer: a unique code, first name, last name, home address, office address, phone numbers, email. Each customer is attended by an employee and an employee can serve many customers. 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: There is always one employee assigned to manage that branch
Reference No:- TGS096734

Expected delivery within 24 Hours