Banking database system - java database connectivity, JAVA Programming

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

 

Posted Date: 3/28/2013 2:09:52 AM | Location : United States







Related Discussions:- Banking database system - java database connectivity, Assignment Help, Ask Question on Banking database system - java database connectivity, Get Answer, Expert's Help, Banking database system - java database connectivity Discussions

Write discussion on Banking database system - java database connectivity
Your posts are moderated
Related Questions
What is the difference among microprocessors and microcontrollers? Give one example of both? The microprocessor is electronic equipment that can perform various functions and a

Both synchronous and asynchronous are given by JMS.

J2EE prepares use of the JNDI interface to access different resources like JMS, JDBC, EJB etc. The client finds up for these resources through the JNDI look-up. The JNDI look like

Question: a) Change the following example, using the Java's conditional operator expression, to solve the duplication problem. public class Demonstrate { public static voi

For this assignment we will be solving the producer-consumer problem with a bounded buffer. You are required to implement this assignment in Java. There are three components in thi

Want an Experienced iOS and Android expert Project Description: I am seeking a super talented team or Individual for a Real Estate app. The project wants to get done in a ver

I send you these files in order to make clear image about my task that I want you to design for me an application for PC that used to control robot arm via micro controller PIC18.

Create an application for an animal-fur trimming service. The business is open 15 weeks of the year, from April through July. The fee for a small animal (under 6 pounds) is $100, a

Problem : Compiler Design - Limit the loops Rajni is a newbie to the programming and while learning the programming language he came to know the following rules: ???• Each program

When should a method be static? • Neither reads from nor writes to example fields • Independent of the state of the object • Mathematical methods which accept arguments, appl