Aperto

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

Questo progetto scadrà tra 1 giorno ed ha raccolto una media di offerte di $87 USD.

Ottieni preventivi gratuiti per un progetto come questo
Datore di Lavoro impegnato
Budget del Progetto
$50 - $80 USD
Offerte Totali
26
Descrizione del Progetto

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.

Competenze Richieste

Stai cercando di guadagnare dei soldi?

  • Stabilisci il tuo budget ed il tempo limite
  • Metti in rilievo la tua proposta
  • Fatti pagare per il tuo lavoro

Assumi Freelancer che hanno fatto un'offerta per questo progetto

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