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

Differentiate between onload and onunload, Differentiate between onLoad and...

Differentiate between onLoad and onUnload? Onload executes the particular javascript code when a latest document is loaded into a windows. ONUnload executes he particular javas

It, Implement a program that can compute your taxes (assume year 2012, as- ...

Implement a program that can compute your taxes (assume year 2012, as- sume a form 1040EZ). The form should ask for your ling status (single, married), income, deductions and cred

Jumps in loops, explain jumps in loops and explain labelled loops

explain jumps in loops and explain labelled loops

Design the complete user interface of the simulation, Task 1- Design the co...

Task 1- Design the complete user interface of the simulation. Task 2 -Design the record structures of the text files that are required to drive the working simulation. Populate

Prepare a java program, Using Java, write the class Time which consists of ...

Using Java, write the class Time which consists of the following: (a) three private integer data members (hours, minutes and seconds). (b) a constructor to initialise the dat

What are the sub categories of ai explain, What are the Sub categories of A...

What are the Sub categories of Artificial Intelligence? Briefly explain any two. 1. Robotics :  These are the machines that are computer programmed and perform work that was pr

Explain about the dynamic behavior of core java, This language was designed...

This language was designed to adapt the changing environment and behavior. New methods and instance variables can be added to the client side without any major changes happening at

What are access specifiers available in java, What are Access Specifiers av...

What are Access Specifiers available in Java? Java has four access specifiers, which are enlisted below: Public: public methods, classes and fields can be accessed by ever

Farm production system, Farm Production System Project Description: I...

Farm Production System Project Description: I require software that will allow me to input/record the daily production of our farm and allow me to view the data back in the o

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