In preparing your progress report you will need to perform all the following: 1. You will need to add data to the tables in your design that matches the data in the supplied Excel documents. If your database design doesn't accommodate a given piece of data you must modify your design and implementation to ensure that all data provided in the spreadsheet can be added.
a. You may any other data you wish and as your design requires. If your design is such that the needed data is not supplied in the spreadsheet you will need to simply "mock" up some sample data and add it into your database.
b. Important: Your instructor cannot provide you with specific information how to complete this step. Each person's database design will be different and therefore, how data must be entered will be different from person to person.
2. Write a paragraph from you about your experiences (good or bad) adding data to your database. Did everything go smoothly? If everything was not perfect or not as smooth as you would otherwise like what went wrong and how did you fix it?
3. Write a paragraph describing any changes that you needed to make to your database design and implementation as a result of the materials provided in this
4. White a series of T-SQL SELECT queries to report the data that you have inserted into your database.
a. There is no specific "look-and-feel" for your reports/queries. We basically want to see the company information, and then the stock information.
b. One query must calculate the total AUM for each company (of which there are two on your spreadsheet). These can all be separate queries.
c. You will copy the T-SQL query statements that you write into your progress report, making sure that you carefully document what each query does and what it produces.
Criteria:
Much of your work in this assignment is that of adding data to your implemented database, changing the design of your database if your data needs dictate such, and then writing T-SQL queries to report on the data has been added.
Submission:
You will submit a single document in either Word of PDF format to Blackboard. This document will be your Progress Report to the partners at National Investments.
Important: You might want to go back and read the section on "Reports" from Introduction to Professional Communications. (Link to reports information here.) Focus on the information about the "Progress Report" and "Report Organization." Note, with respect to the "Report Organization" section you only need to focus on the information about the "Introduction," "Body," and "Conclusion."