Version 1 Page 1 of 4 Module Title: Enterprise Applications with Java Enterprise Edition Module Code: CE00874-6 Module Leader: Dr. Ronald S. Cordova Weighting: 50% Submission Time and Date: 1:00 PM, 1 January 2017 Scenario – Bank Management System A leading bank in Oman keeps information about customers' records including the branch name where they opened their account and bank account details. A data model is illustrated below for your reference. The system should be designed based on the following facts: a. A bank has several branches (BranchID, Description, Location, etc.) b. A branch has many customers (Name, Phone, Address, etc.) c. A customer has one or many accounts (AccountNo, Balance, Description, etc.) d. Each account belongs to a certain type(i.e. savings or current account) e. Depending upon the account type, the annual interest varies. Create database tables for the scenario above. You must name your tables with your ID number as part of the table name: e.g. if your ID number is 12345 you would name the tables as follows: branch table "branch12345", customer table "customer12345", account table "account12345". Your entity classes will have a name that reflects your ID number. You are required to develop a website using a Java Enterprise Edition Technology (Java Server Pages, Servlet or Java Server Faces) which will perform the functions below. Your business logic Bank Account Bank Customer BranchVersion 1 Page 2 of 4 should be separated from the presentation logic. Your website should be interactive and attractive and perform the following functionalities: 1. Create a main page with appropriate hyperlinks 2. Create branch, customer and account records 3. Add customers to a branch 4. Add new accounts to a branch 5. Update/Edit branches, customers and accounts 6. Delete branches, customers and accounts 7. List all branch, customer and account details 8. List the customers and accounts of a particular branch by account number and customer name. 9. Change the account type of a customer's bank account (from savings account to current account or vice versa). 10. Create a function that will compute the interest rate of a bank account with the following criteria: If a bank account is a savings account, it will have a 10% annual interest rate i.e. interest rate =10% of current balance If a bank account is current account it will have a 3% annual interest rate i.e. interest rate =3% of current balance 11. List the branches (branchID, name, description) + accounts that they have (account number, name, balance, interest rate) +total accounts per branch. One request is enough to accomplish this function 12. Transfer money between accounts with the same branch otherwise it is not allowed to make such a transaction. Submission Materials  A soft copy of your complete report  A hard copy of the report and important Java files that you have written  The body of the report should include the following:Version 1 Page 3 of 4 I. Introduction  Write a simple description about the program II. UML and Storyboard  Include all the diagrams including a brief description of each diagram  Display the screenshot of each web page and label the different objects  Give a brief description of each web page III. Implementation  Identify important code snippets for discussion in each web page IV. Testing  Write at least 2 test cases for each web page V. Critical Analysis  Write a brief description about the completed work, the good and bad about it and its significance to your study. Marking Criteria SUBMIT TOPICS MARKS PART 1 Entity Relationship Diagram 5 Creating the system design and story board 5 Main page with appropriate hyperlinks 5 Add branches, customers and accounts 5 List and show branches, customers and accounts with the required condition filters 10 PART 2 Report layout (For the numbering, table of contents, list of figures, proper references, list of abbreviations) 5 Update and delete the branches, customers and accounts 5Version 1 Page 4 of 4 Demonstration Periods It is the student's responsibility to make an appointment with your tutor. You have to agree with your tutor on an interview date to discuss your assignment. The date should be at least a week before the submission deadline. This may be supported by the draft documentation of work carried out to date. In this interview you need to address design considerations on the basic functionalities of the assignment. At this stage you are expected to have a clear idea about aspects of your implementation. The second stage will involve a demonstration of your implementation. You can change the codes based on the feedback coming from your tutor but the marks for the demonstration will be final. Other Comments  This is an individual assignment - the college rules on plagiarism apply.  Please save your assignment in a separate CD or USB flash disk and follow the Faculty's assignment submission guidelines (labeling the disk, etc.). List the branches (branchID, name, description, etc.) + accounts (account number, name, balance, etc.)+ total accounts of branch 10 Transfer money between accounts 10 Change the account type of a customer 5 Calculating interests 10 Testing 10 Critical analysis of the assignment 5 DEMO Demonstrates the proper functions of the program and correctly answers all the questions. 10 TATOT 100