Banking database system - java database connectivity, JAVA Programming

Assignment Help:

JDBC Assignment

Banking Database System: 

BankCustomer

CUST_ID

 CUST_NAME

ADDRESS

ACC_TYPE

CUST_ID              :  customer identification number  [primary key]

NAME                   :  Name of the customer

ADDRESS             : Address of the Customer

ACC_TYPE           : Account type i.e savings/current

CustomerAccount

CUST_ID

BALANCE

CUST_ID              : customer identification number [foreign key]

BALANCE             :  account balance

By using above tables write a Program to cover all the below operations

1.  Find customer details of the given customer account

2.  Get balance of the given customer account

3.  Deposit amount into the given customer account

4.  Withdraw amount from the given customer account (minimum balance should be 1000)

5.  Show all the customer details  and account balances

 


Related Discussions:- Banking database system - java database connectivity

Explain the 4 phases of RUP?, 1. Inception : In the mean while the inc...

1. Inception : In the mean while the inception phase, you work out the business part for the project. You also will be creating a rough cost estimate and return on investment.

Get info from website using javascript, Get info from website using javascr...

Get info from website using javascript Project Description: I need to extract the text from all the available (red, blue) seats of all the events on this site without getting

Online Music Store, Online music store that stores information about song, ...

Online music store that stores information about song, artist, album, customer, playlist. Also all necessary diagrams - use case, uml, erd

Game, any example of games that is created by java ?

any example of games that is created by java ?

Program to calculate the value into hours and minutes, Specifically, you'll...

Specifically, you'll create a program that will hold minutes worked and assign a value. Calculate the value into hours and minutes. Display the result as shown in Figure 2. Reme

What is heuristic, What is heuristic? Heuristic is a procedure which co...

What is heuristic? Heuristic is a procedure which commonly, but not always, works or that provides nearly the right answer.

#, Consider the following code? What input is needed for x in order for the...

Consider the following code? What input is needed for x in order for the sum variable that is output at the end of the code to be 12 ? (In other words: what do I need to make X be

What is public static void main signifies, What is 'public static void main...

What is 'public static void main (String args[ ] ) ' signifies? Access specifier is the 'public' keyword. 'static' keyword allows main() to called without instantiating

Java program to play minesweeper , Project Requirements Write and tes...

Project Requirements Write and test a Java program to play Minesweeper using Model-View-Presenter design (The model is an interface defining the data to be displayed or other

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd