plz could you help me by this:
You are required to build a web site using java servlet and JSP. The site is a portal for a bank that customers can use to access their accounts information. Here is the database:
• Customer (id, firstName, lastName, login, password)
• Branch (id, branchName, city, telephone)
• Account (number, customerId, branchId, balance)
• Transaction (id, fromAccountNumber, toAccountNumber, amount, kind, theDate) where "kind" has one of the following values: "credit" when an amount of money is added to "toAccountNumber", "debit" when an amount of money is debited from "fromAccountNumber", "transfer" when an amount of money is transferred from "fromAccountNumber" to "toAccountNumber".
A customer may have many accounts. A branch contains many accounts.
You are required to write the following dynamic web pages using java servlets. You can use any kind of database you prefer.
1. A page to login
2. A page to display the list of account that a customer has. When the user clicks on an accounts, the last ten transactions on this account are displayed with the balance.
3. A page to display the branches of a given city.
4. A page that permits the user to transfer an amount of money from one of his accounts to another account given by its number. The user chooses his account from a dropdown list containing all his accounts.
You are required to write the following dynamic web pages using JSP:
1. A page to manage (add/delete/update) a customer
2. A page to manage (add/delete/update) a branch
3. A page to manage (add/remove) an account