Project #29235 - SQL

Service Request SR-kf-009, “SQL Accounting

 

Work on Service Request SR-kf-009, “SQL Accounting Database.

 

 • Develop a project plan defining all tasks and work assignments

   for each team member.

 

 • Analyze the current Chart of Accounts spreadsheet.

 

 • Define the SQL database.

 

• Load the SQL database with data from the chart of accounts

  spreadsheet.

 

 • Prepare test data and load it into the SQL database.

 

 • Create account number query.

 

 • Test query.

 

 The assignment will consist of a Microsoft Word document

containing the following information:

 

1. Summary of your observations of the "Charts of

Accounts" data including recommendations on normalizing

the data as well as rationale for any keys and indexes

chosen. Breaking the data into more than one table is not

required for this report, however your submission should

include recommendations about how the data could be

stored more effectively for queries outside of the report

defined in SR-kf-009. Pay close attention to the data itself

and consider how it should be stored versus how it's stored

in the spreadsheet today.

 

2. Database diagram

 

3. SQL statements used for creating database table(s) and any

related keys and/or indexes used.

 

4. SQL statements used to load test data

 

5. SQL statement(s) used to query data for report

 

 

6. Report results

Subject Computer
Due By (Pacific Time) 05/01/2014 08:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy