A mini project on a DBMS with 3 entities,transactions and printing the results using any high level language

Design and implement a sophisticated and usable DBMS


Design and implement a database with the banking system. There

should be minimum three entities( in the [url removed, login to view] can use any high

-level language(Java, C, C++, Visual Basic, etc) thatcan embed SQL statements.


Design a set of transactions (minimum 3) on your database and implement each

transaction using high-level language of your choice and embedded SQL.


Run your transactions on your database and print the results.


The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples include MySQL, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.

In this the basic banking functions like account creation, type of accounts(Checking, savings) and balance updating, branches are taken into entity sections where customer ID is the primary key and account number , balance and branch are foreign keys.

The operations or transactions like creation-creation of the account in a specific branch, read- getting the details of the customer or the account from the account number or customer ID.

Updating-the updating of the account balance after transactions like deposit or withdrawal.

Deletions-the deletion or removal of the account from the database of the bank etc.


Customer ID


Type of account (checking, saving)




The main transactions are

Account creation


Deposit or withdrawal

Account deletion.

Front end- JAVA

Back end – My SQL

Server- Apache tomcat 6.0

High level language-JavaScript, CSS, HTML

Basically the first initiation process takes place with the creation of account in the bank which requires the customer a specific ID for example let take the SSN(social security number) as the primary key. Then the account number and I took separate account numbers for each type of account like Savings and checking which one to many for the customer ID.

Branch of the bank like which is taken from the many branches of the bank. Like branch name and city.

Balance for each account and which needs to be updated after deposit or withdrawal.

Skills: Database Programming, Java, SQL

See more: what is a high level programming language, i need a developer to help develop a web based software program i will provide full project details once you place a placeholder, high level programming language list, high level programming language, high level computer programming language designed general commercial use, first high level programming language, mini project dbms, dbms project workmedicalstore, dbms project medical store, dbms project medical shop, dbms project medial store, dbms project hospital management, dbms project ecommerce, dbms project college management system, dbms project powerpoint, using php mysql load language site, dbms project student information system, project report fanuc pick place robot, dbms project normalization using, dbms project atm machine, develop mini project using access, html using javascript mini project, mini project description resevation mnagement using java, mini project airline reservation using basic java, mini project html css

About the Employer:
( 1 review ) FAIRBORN, United States

Project ID: #12209684

23 freelancers are bidding on average $86 for this job


Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.

$80 USD in 3 days
(1059 Reviews)
$200 USD in 10 days
(242 Reviews)
$65 USD in 10 days
(44 Reviews)

A proposal has not yet been provided

$66 USD in 1 day
(76 Reviews)

I have good knowledge in below mentioned skills by you. I also have some certifications in Java. I can share some of demos with you if you want for better understanding. Currently I'm working on a banking project in an More

$50 USD in 2 days
(43 Reviews)

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me More

$83 USD in 10 days
(40 Reviews)

Hi , hope you are doing well i am software engineer with 5 years experience in software development using Java I can help you to complete this project, also i can provide demo for your requirements hope to co More

$80 USD in 3 days
(29 Reviews)
$80 USD in 4 days
(12 Reviews)

ZERO ERROR GUARANTEED!! Please read my 160+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfie More

$100 USD in 5 days
(2 Reviews)

Hello Sir....! I read your description I can do that also I will complete your project on time and within your budget I am fully confident about your project. I will receive your best wishes. I am waiting your respo More

$100 USD in 3 days
(8 Reviews)

Hello, I am new on the site, but I have wide experience in java development, and I can do what you need.

$72 USD in 10 days
(9 Reviews)
$72 USD in 10 days
(4 Reviews)

I can do this using SQL server and Java. Java will use jdbc to connect SQL. Let me know if you have any specific question.

$200 USD in 10 days
(2 Reviews)
$55 USD in 10 days
(1 Review)

Hello I am ready to start this work from now. I have more than 6 years of professional developing experience and advanced computer skills. I have done the projects in core php, codeignitor, Javascript, Symfony PHP More

$66 USD in 3 days
(0 Reviews)

Hi. It should be a HTML frontend with Java and MySQL as backend? Are there any restrictions on java libraries to help in the development?

$90 USD in 5 days
(0 Reviews)

A proposal has not yet been provided

$122 USD in 3 days
(0 Reviews)

Hi. I have read your job description and I am very interested in your job. I have over 12 years of experience in filemaker development. Here are some areas of my experience. Advertising Media Management Solutio More

$72 USD in 10 days
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c More

$53 USD in 6 days
(0 Reviews)

This project seems simple enough as it is to create a banking system that enters the data to a sql database. I am assuming this is school/college/uni work. The work should be completed quicker than the goal suggests ho More

$50 USD in 4 days
(0 Reviews)