JAVA JDBC expert and DB2

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.

Project Specification:

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

3. Exit

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

3. Deposit

4. Withdraw

5. Transfer

6. Account Summary

7. Exit

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

4. Exit

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.

Taidot: C-ohjelmointi, Tietokantaohjelmointi, Java, MySQL, Oracle

Näytä lisää: java jdbc logging wrapper, desktop ticketing system using java jdbc, ticketing system using java jdbc, db2 type 4 driver class name, jar, db2 type 4 driver, class not found, java mainframe db2 connectivity, connect to db2 database using java, db2 jdbc connection string parameters, how to connect db2 database in java using eclipse, rational software architect java jdbc connection, java jdbc jsp, java profiler expert tomcat, java jdbc wrapper class 2008, java jdbc swing j2se, jpmishra java jdbc example, java populate servlet db2, java jdbc filesystem, project java jdbc

Tietoa työnantajasta:
( 158 arvostelua ) Calcutta, India

Projektin tunnus: #15760973

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


Hello sir, Please give me brief of project we are group of expertise, having 7+ years of development experience in different CMS and Frameworks like Wordpress, Core PHP, WooCommerce, CodeIgniter, Laravel Framework . Lisää

₹333 INR / tunti
(3 arvostelua)
₹277 INR / tunti
(5 arvostelua)

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

₹125 INR / tunti
(4 arvostelua)
₹277 INR / tunti
(4 arvostelua)

Hi, # 20 hours will be upper limit you pay for, if it takes over 20 hours it's discount for you. #it will come with unlimited number of revisions, #free support for two weeks after even project is completed, includi Lisää

₹105 INR / tunti
(2 arvostelua)

Hello, I’m interested in the position of "Java / J2ee Developer " you recently posted. I have been a working as Sr. Java Developer for 6+ years, and am very familiar with Java, J2ee,Spring,Spring MCV, Lisää

₹388 INR / tunti
(2 arvostelua)
₹333 INR / tunti
(0 arvostelua)
₹222 INR / tunti
(0 arvostelua)

I am having 4.5 years of work experience in java development.I understand the project scope and i can assure you to complete this in time.

₹194 INR / tunti
(0 arvostelua)

Hello Mr, I would like to do this job. I know what u means, u want to create a simple app that can connect to database and using on your own purpose, actually i can do it in netbeans a very simple, im experienced use Lisää

₹277 INR / tunti
(0 arvostelua)

expert in all java platforms(spring,hibernate,webservices). Good experience in Hadoop related platforms

₹111 INR / tunti
(0 arvostelua)

Have a good hand in java and SQL. Will love to serve you

₹277 INR / tunti
(0 arvostelua)

I have a rich working experience in java, mobility, database, cryptography and splunk ( for log analysis and problem resolution) and have completed masters in computer application. Having a vast experience in many tech Lisää

₹361 INR / tunti
(0 arvostelua)