Who are employees of the bank

Assignment Help Computer Engineering

Reference no: EM133370765

• 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 with a 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.

Reference no: EM133370765

Questions Cloud

Creating spreadsheet that models real-world situation : When creating a spreadsheet that models a real-world situation, why do we try to include a section for assumptions for the model?

Summary of history of your selected publication : Write a summary of the history of your selected publication and the evolution of that type of media.

Differences between fraud and abuse : Discuss the differences between fraud and abuse.

Analyze the performance of the three firms : How can you analyze the performance of the three firms over the two years using appropriate ratios i.e. profitability, liquidity, activity, and debt ratios.

Who are employees of the bank : 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

How can racism affect a woman ability to access quality : How can racism affect a woman's ability to access quality prenatal care? How could this impact her health and/or the health of her child?

Consider professional relationship : Consider a professional relationship. Does a remote boss do these things? How would this impact remote teammates?

Providing a high-performance memory hierarchy : identify the binary address, the tag, and the index given a directmapped cache with two-word blocks and a total size of 8 blocks. Also list if each reference

Describe a policy that impacts women health : Describe a policy that impacts women's health. The policy can be at the organizational level, state, or federal level. What is the policy and at what level

User Account

All Pages