Computers and Technology

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."

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 01:30, giannav57
How do you set up a slide show to play continuously, advancing through all the slides without requiring your interaction? a. click set up slide show, and then select the loop continuously until โ€˜esc' and show without narration options. b. click set up slide show, and then select the loop continuously until โ€˜esc' and use timings, if present options. c. click set up slide show, and then select the show presenter view and use timings, if present options. d. click set up slide show, and then select the show without animation and browsed at a kiosk (full screen) options.
Answers: 3
image
Computers and Technology, 23.06.2019 03:00, Julianhooks
State 7 common key's for every keyboard
Answers: 1
image
Computers and Technology, 23.06.2019 09:00, mimithurmond03
Which is the highest level of the hierarchy of needs model? a. humanity b. intrapersonal c. team d. interpersonal
Answers: 1
image
Computers and Technology, 23.06.2019 14:00, uday50
Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving
Answers: 2
Do you know the correct answer?
In preparing your progress report you will need to perform all the following: 1. You will need to...

Questions in other subjects:

Konu
Mathematics, 04.05.2021 17:50