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