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 importance of abstract classes in java, Question: (a) Expl...

Question: (a) Explain the importance of abstract classes in Java with an appropriate example. (b) Explain what is meant by an interface in Java? Use a simple example to il

Explain rmi architecture, RMI uses a layered architecture; every of the lay...

RMI uses a layered architecture; every of the layers could be increased or replaced without affecting the rest of the system. The details of layers can be summarised as follows:

What are checked and unchecked exception, What are Checked and UnChecked Ex...

What are Checked and UnChecked Exception? A checked exception is some subclass of Exception (or Exception itself), excluding class RuntimeException and its subclasses. Making a

Neatbeens and glass fish, Assignment 3 Project Proposal Documentation Descr...

Assignment 3 Project Proposal Documentation Description Marks out of Wtg(%) Due date Assignment 3 100 35% 15/09/14 In the assignment we will start analysing and designing the

Non-final functions in java object class, Normal 0 false fals...

Normal 0 false false false EN-US X-NONE X-NONE

Bluej program, program to find the frequency of a digit in a number

program to find the frequency of a digit in a number

Demonstrate java client and server , There is no separate homework this wee...

There is no separate homework this week, but you may complete the exercises ahead of time, in which case you only need to attend for long enough to get your work marked off by your

How is method overriding different from method overloading, How is method o...

How is method overriding different from method overloading? Overriding involves the creation of two or more concepts with the same name and same signature in different classes

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