Find Jobs
Hire Freelancers

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

$50-80 USD

Closed
Posted over 7 years ago

$50-80 USD

Paid on delivery
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 [login to view URL] 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.
Project ID: 12209684

About the project

20 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $87 USD for this job
User Avatar
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
5.0 (1149 reviews)
7.7
7.7
User Avatar
A proposal has not yet been provided
$66 USD in 1 day
4.9 (84 reviews)
5.4
5.4
User Avatar
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 IT company using Java, jsp/jsf, hibernate, spring, software architecture and database programming. And most importantly, you will get your project done before the deadline.
$50 USD in 2 days
4.9 (44 reviews)
5.2
5.2
User Avatar
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 in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: Expert in SQL Server, Oracle and MS Access Databases Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script Expert in excel Macro Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble
$83 USD in 10 days
4.9 (42 reviews)
5.1
5.1
User Avatar
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 contact me to discuss more about your project Thanks
$80 USD in 3 days
5.0 (35 reviews)
4.6
4.6
User Avatar
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 satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$100 USD in 5 days
5.0 (2 reviews)
4.2
4.2
User Avatar
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
5.0 (9 reviews)
3.2
3.2
User Avatar
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
4.8 (2 reviews)
2.1
2.1
User Avatar
A proposal has not yet been provided
$122 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 however complications can happen which is why it is set to what it is. I hope to hear from you.
$50 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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, Cake PHP, Smarty, Opencart, Joomla, API development, Oscommerce, Bigcommerce, Salesforce CRM, Laravel, Shopping cart related work, Only backend work, Drupal, Prestashop, Android apps, IOS apps and many more other works. Please let me know about your point of view about this. Thanks
$66 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir/Madam, Good day! I'm a degree holder and I'm a software developer with more than 4 years experienced. I have tried developing "Computer Based Enrollment Transaction System of Learning School." I have also 3 years experienced in high level programming language like C++ and Clipper. I'm also a computer savvy and can do jobs with minimal supervision. Please contact me now. Thank you!
$72 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
FAIRBORN, United States
5.0
1
Payment method verified
Member since Nov 26, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.