You are responsible to write a database application which acts as a simple banking system. This application must be able to do basic banking functions according to the specifications given below. This project must be implemented using DB2, Java, & JDBC.
Section A: Schema Definition
[url removed, login to view] (ID, Name, Gender, Age, Pin)
[url removed, login to view] (Number, ID, Balance, Type, Status)
-- All the attributes cannot be NULL.
-- Underlined attributes is denoted as the primary key of that relation.
-- Italicized attributes is system generated.
-- Attribute types and ranges:
- ID: integer (system generate starting from 100)
- Name: varchar(15)
- Gender: char (must be M or F only !!!)
- Age: integer (>= 0)
- Pin: integer (>= 0)
- Number: integer (system generate starting from 1000)
- Balance: integer (>= 0)
- Type: char (C for Checking, S for Saving)
- Status: char (A for Active, I for Inactive)
Section B: Data Administration & Manipulation
Screen # 1 (Title – Welcome to the Self Services Banking System! – Main Menu)
1. New Customer
2. Customer Login
For #1, prompt for Name, Gender, Age, and Pin. System will return a customer ID if successful.
For #2, prompt for customer ID and pin to authenticate the customer. If user enters 0 for both customer ID & pin, then you will go straight to Screen #4.
Screen # 3 (Title – Customer Main Menu)
1. Open Account
2. Close Account
6. Account Summary
For #1, prompt for customer ID, account type, and balance (Initial deposit). System will return an account number if successful.
For #2, prompt for account #, change the status attribute to ‘I’ and empty the balance for that account.
For #3, prompt for account # and deposit amount.
For #4, prompt for account # and withdraw amount.
For #5, prompt for the source and destination account #s and transfer amount.
For #6, display each account # and its balance for same customer and the total balance of all accounts.
For #7, go back to the previous menu.
Screen # 4 (Title – Administrator Main Menu)
1. Account Summary for a Customer
2. Report A :: Customer Information with Total Balance in Decreasing Order
3. Report B :: Find the Average Total Balance Between Age Groups
Note: The only way you can get to Screen #4 is by entering 0 as the ID and 0 as the pin in the customer login screen.
13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
i have an 5+ year experience in java ,i am able to complete your web project including all your mentioned features yes ,i do have one negative review it was just misunderstanding lets discuss in details