Reference no: EM13930320

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.

Attachment:- Balance Sheet.docx

Attachment:- Chart+of+Accounts.zip