simple accounting system (assignment for a Database class)(repost)

Cancelado Publicado Apr 23, 2007 Pagado a la entrega
Cancelado Pagado a la entrega

**This is actually a project for an undergraduate database class so financial/accounting knowledge is not required. I dont need the whole project to be done, I simply need some parts of the "teller" to be done, and the "manager" section of the project also needs to be done(using Asp and Sql 2000).So I will send you the code that I have already completed and you can continue from there. Here is the description of the whole project.

Business description:

**This is an extremely simplified accounting system for a bank. The system is to manage customers and their bank accounts. Assume all accounts have the same currency.

Customers have to see a teller of the bank if they want to open new accounts or deposit/withdraw money to/from their accounts. For a new customer, a teller will register following information into the system: customer name, address, customer id, and password. Tellers are able to open new accounts for registered customers. There are three kinds of accounts: checking, savings, and CD (Certificate of Deposit).

Some common attributes for all accounts are: account number, opening date, and current balance. Customers can login using their customer id and password. After login, they are able to inquiry their account information and the transaction history of each account. They also can transfer money between their accounts.

**I have attached the full detailed description but here are the baseics:

Basic functionalities:** (70% of grade)

* Customers can login, transfer funds and inquiry customer/account information and transaction histories.

* Tellers can login, register new customers, update customer information, open new accounts, deposit, withdraw, transfer fund, and inquiry customer and account information and transaction histories.

* Managers can update account information and manage teller information(add/update/remove tellers).

**Advanced functionalities:(30% of grade)**

## Deliverables

**Final report due:

** * ER diagram and constraints, relation schema/database model diagram

* SQL scripts to create the database

* List of triggers, store procedures, views, indexes

* Transaction processing if any

* Access controls if any

* Application architecture description (2 tier/3 tier)

* List of developed user interfaces with their purposes

* Source codes; [url removed, login to view] (how to deploy the application)

The advanced features described above dont have to be done but can be attempted if there is enough time. The basic functionalities must be completed though.

This Final Report is the most important part of the project because it will describe everything in detail, and it is what the majority of the grade if based upon. Additionally, the following standard rules apply:

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP

Administración de bases de datos Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL

Nº del proyecto: #2937833

Sobre el proyecto

12 propuestas Proyecto remoto Activo May 15, 2007

12 freelancers están ofertando un promedio de $528 por este trabajo

somireddy

See private message.

$85 USD en 5 días
(72 comentarios)
5.1
brijesh123

See private message.

$510 USD en 5 días
(11 comentarios)
4.4
shraddhamit

See private message.

$297.5 USD en 5 días
(8 comentarios)
4.2
Boca

See private message.

$255 USD en 5 días
(7 comentarios)
3.7
AsmaSanam

See private message.

$85 USD en 5 días
(16 comentarios)
3.5
happyprogrammer

See private message.

$170 USD en 5 días
(8 comentarios)
3.4
bluebuyer

See private message.

$340 USD en 5 días
(7 comentarios)
2.8
vw839209vw

See private message.

$85 USD en 5 días
(4 comentarios)
1.9
renua

See private message.

$127.5 USD en 5 días
(3 comentarios)
1.6
thecloudkernel

See private message.

$4080 USD en 5 días
(3 comentarios)
0.9
sandeep8150

See private message.

$127.5 USD en 5 días
(0 comentarios)
0.0
irfanrafiqvw

See private message.

$170 USD en 5 días
(0 comentarios)
0.0