Share
Explore BrainMass

SQL Accounting Database

PLEASE USE SQL 2008 ATTACHED FOR ALL SQL DATABASE CREATION

Design an SQL database that contains the fields found in the company's Chart of Accounts. Add a balance field to the database. Create a query that will display all of the fields of the database and run a report totaling the balance field using test data added to the database.
Basically, the spreadsheet (Chart of Account) needs to be on a SQL Database.

What needs to be completed:

An SQL database containing the fields in the current Chart of Accounts, plus a "balance" field.

An SQL query that will display all of the database fields.

A test of the database by means of a query by account number and a report totaling the balance field test data entered by the database design team. The query will display all fields (description, short description, and balance) using the account number as the key to the query. The report will display all fields with a break based on the first two digits of the account number and subtotal of the balance field at each break. A grand total of the balance field will be provided at the end of the report. The database design team will load sufficient entries into the balance field to prove their total routine is working - test balance entries are not necessary for all account numbers.

Attachments

Solution Summary

The solution includes an SQL database containing the fields in the current Chart of Accounts, plus a "balance" field, an SQL query that will display all of the database fields, a test of the database by means of a query by account number and a report totaling the balance field test data entered by the database design team.

$2.19