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

**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

Tietokannan hallinto tekniikka MySQL PHP Tietojärjestelmäarkkitehtuuri Ohjelmistojen testaus SQL

Projektin tunnus: #2937833

Tietoa projektista