Open

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

This project is ending today and has an average bid price of $86 USD.

Get free quotes for a project like this
Employer working
Project Budget
$50 - $80 USD
Total Bids
26
Project Description

Design and implement a sophisticated and usable DBMS

1.

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.

2.

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

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

3.

Run your transactions on your database and print the results.

SIMPLE BANKING APPLICATION

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.

Entities-

Customer ID

Branch

Type of account (checking, saving)

Deposit

Withdrawal

Transactions-

The main transactions are

Account creation

Updating

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 Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online