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
P1.Customer (ID, Name, Gender, Age, Pin)
P1.Account (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)
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)
For #1, prompt for customer ID, account type, and balance (Initial deposit). System will return an account number if successful.
For #2, change the status attribute to ‘I’ and empty the balance.
For #3, prompt for the account number and amount.
For #4, prompt for the account number and amount.
For #5, prompt for the source and destination account numbers and amount.
For #6, the total balance and each account number and its balance belong to the same customer.
For #7, go back to the previous menu.
Screen # 4 (Title – Administrator Main Menu)
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.
For #1, same function as #6 above except that you would need to input the customer ID explicitly.
For #2, you would display the customer ID, Name, Age, Gender, and total balance in decreasing order.
For #3, you prompt for a min & max age to display Average Age and Average Balance.
For #4, go back to the previous menu.
Section C: User Interfaces
Section D: Additional Notes:
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services