This assignment has one question of 40 marks. Rest 10 marks are for viva voce. Please go through the guidelines regarding assignments given in the programme guide for the format of presentation.

Q1.

Create a website for a Bank which offers online Banking service to its registered customers. The website should be designed using logical divisions through

tags and an external CSS file. Every page of the website is divided into four divisions namely – Main, Cpyrt, Options and Data as displayed in the following figure:

Perform the following tasks for the website as given above:

[ Part (a) : 10 Marks + Part (b) : 05 Marks + Part (c) : 05 Marks + Part (d) : 20 Marks]

(a) Create four pages for the website viz Home, Account Balance, Transactions and Feedback; all the four pages should have same Main, Options and Cpyrt division but different Data division. The Options Division should provide links to the Home page as well as all the other three pages. All these four options should be available in all the web pages designed by you for this assignment. Thus, this Option division may be used for navigating among the four web pages. The Data Division of every page should be different. The information that should be displayed in Data Division of each of the pages is described below:

(i) The Home page should display the list of services available through these pages.

(ii) The Account Balance page should display a form for logging into the Database of the Bank.

(iii)The Transactions page should display the transactions of the account for which Balance has been shown.

(iv)The Feedback page should display another form having a text area field for writing the Feedback and a Button to submit the form.

(b) Create an external CSS that gives different background colour to each division. You may choose the format of other elements as per your choice. (c) Create a JavaScript program that generates an error message if Username field is left blank in the form for Account Balance page; or if the length of entered password in the password field is less than 4 characters . After displaying the error message, the login form should be displayed again.

(d) Implement the following using jsp program, servlets, java classes, database(s), etc. for the pages as described below:

(i) When a user presses Submit button after properly filling Username and password in the form in the Account Balance page, these details are checked in a database and in case such username and password are correct, the account number, account holder name and balance of the account are displayed on the screen. You may also create a cookie, if needed, to remember the account number for the given username and password (assuming each user has only one account).

(ii) On selection of Transactions option, all the transactions made (assume only Deposit and Withdrawal transaction) for the account number, as remembered in part (d)(i) above, is displayed in a tabular format.

(iii) When you press the Submit button of the Feedback Form, the information (account number from the cookie and entered text) should be stored in the database.

(iv)You must design a suitable database structure.

You may make suitable assumptions, if needed