Reference no: EM133401228

Case Study: • The bank is organized into branches. Each branch is in a particular city with an address and is identified by a unique branch-ID and a name. The bank monitors the assets of each branch. Each branch of the bank has a manager and an assistant manager who are employees of the bank. • Bank customers are identified by their social security numbers. The bank stores each customer's name and address (apartment number, street number, state, city, and zip code). Customers may have several accounts and can take out loans that are managed as accounts as well. A customer may be associated witha particular branch and has a personal banker who works with the customer on their loan and bank transactions. • Bank employees are also identified by their social security numbers. The bank stores the name and telephone numbers of each employee and the names of the employee's dependents. The bank also keeps track of the employee's start date and, thus, length of employment. An employee at the bank works for one of the branches and reports to the manager of that branch. may have a manager and the manager is in charge of a certain number of employees. • The bank offers several types of accounts; savings, checking, money market, and loan accounts. An account can be held by more than one customer, and a customer can have more than one account. Each account is assigned a unique account number. The bank maintains a record of each account balance and the most recent date on which the account was accessed by each customer holding the account. In addition, saving and loan accounts have fixed interest rates, money market accounts have variable interest rates regularly updated based on the stock market. and overdrafts are recorded for each checking account. • A loan originates at a particular branch and can be held by one or more customers. A loan is identified by a unique loan number (similar to an account number). For each loan, the bank keeps track of the loan amount and the loan monthly re-payment amount. • The bank keeps track of all the transactions. A transaction is identified by a unique code and has a type of name. For example, "WD" is the code for withdrawal, and "CD" is for customer deposit. When a customer makes a transaction, the transaction record should identify the transaction code, the date, the hour, the amount, and the account. Some transactions are free but the bank charges for most of them. If a customer makes a chargeable transaction,the charge is also registered as a chargeless transaction.

Questions:

A) List the business rules requirements

B) Develop/Draw an ER Diagram (Entity relationship) model for the conceptual design, and

C) Develop a relational schema design from the ER Diagram created