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.

The purpose of this is to write a professional progress report

TI K L M N O P Q R S T 4 A 1 Client List (partial provided as example) 3 Client 4 Id Account Type Business Personal Management Phone Phone Fee Investor AUM Contact C/S Investment Strategy Representative Manager Client Name Address 1 Address 2 City State Zip Email Inception 6 2242F1 Allegany Fire Department Pension Pi 42 Charlevoix Rd. Pittsburgh PA 15230 SRobinsor 555-386-8197 1.25% $ - Sheryl Robinson 9/21/2009 LCV Riley Huff Peter Denning 8 2344C1 City of Ferguson Muncipal Workers 401K K1 1977 Bird I Route 53 Ferguson MO 63135 KevinR23(555-979-2.555-203-5 1.09% $ . Kevin Riley 5/26/2011 LCV Keisha Sanders Peter Denning * Note: Kevin Riley is with Parkland Investment Group. This company's address is as follows: 101 River Dr., Pittsburgh, PA 15214 Telephone Number: 555-828-1392 AUM Note: AUM cannot provided in this spreadsheet as it will depend on the total holdings value from the "Holdings" tabs. Partial Client List Allegany Fire Holdings City of Ferguson Holdings D E F G H I J K 1 Holdings Report by Client 3 4 Client Id Client Name 6 2242F1 Allegany Fire Department Pension Current Value Price Ticker AAPL Name Apple Inc Loews Southwest Airlines JPMorgan Chase Shares 18,923 48,321 52,049 27,152 LUV JPM - Investor AUM Price Note: You will need to lookup the most recent per-share price for each of these stocks and enter in the Price column Value Note: The Current Value column will automatically calculate as Shares X Price. You must be able to calculate the Current Value from your database based on the number of Shares X the Share Price--and then sum these values. C D E A B Holdings Report by Client Client Id client Name 2344C1 City of Ferguson Muncipal Workers 401K Current Value Price Ticker BRK-B GM NFLX Name Berkshire Hathaway General Motors Netflix, Inc. Shares 79,059 $ 108,000 $ 35,069 $ - Investor AUM Price Note: You will need to lookup the most recent per-share price for each of these stocks and enter in the Price column Value Note: The Current Value column will automatically calculate as Shares X Price. You must be able to calculate the Current Value from your database based on the number of Shares X the Share Price--and then sum these values. TI K L M N O P Q R S T 4 A 1 Client List (partial provided as example) 3 Client 4 Id Account Type Business Personal Management Phone Phone Fee Investor AUM Contact C/S Investment Strategy Representative Manager Client Name Address 1 Address 2 City State Zip Email Inception 6 2242F1 Allegany Fire Department Pension Pi 42 Charlevoix Rd. Pittsburgh PA 15230 SRobinsor 555-386-8197 1.25% $ - Sheryl Robinson 9/21/2009 LCV Riley Huff Peter Denning 8 2344C1 City of Ferguson Muncipal Workers 401K K1 1977 Bird I Route 53 Ferguson MO 63135 KevinR23(555-979-2.555-203-5 1.09% $ . Kevin Riley 5/26/2011 LCV Keisha Sanders Peter Denning * Note: Kevin Riley is with Parkland Investment Group. This company's address is as follows: 101 River Dr., Pittsburgh, PA 15214 Telephone Number: 555-828-1392 AUM Note: AUM cannot provided in this spreadsheet as it will depend on the total holdings value from the "Holdings" tabs. Partial Client List Allegany Fire Holdings City of Ferguson Holdings D E F G H I J K 1 Holdings Report by Client 3 4 Client Id Client Name 6 2242F1 Allegany Fire Department Pension Current Value Price Ticker AAPL Name Apple Inc Loews Southwest Airlines JPMorgan Chase Shares 18,923 48,321 52,049 27,152 LUV JPM - Investor AUM Price Note: You will need to lookup the most recent per-share price for each of these stocks and enter in the Price column Value Note: The Current Value column will automatically calculate as Shares X Price. You must be able to calculate the Current Value from your database based on the number of Shares X the Share Price--and then sum these values. C D E A B Holdings Report by Client Client Id client Name 2344C1 City of Ferguson Muncipal Workers 401K Current Value Price Ticker BRK-B GM NFLX Name Berkshire Hathaway General Motors Netflix, Inc. Shares 79,059 $ 108,000 $ 35,069 $ - Investor AUM Price Note: You will need to lookup the most recent per-share price for each of these stocks and enter in the Price column Value Note: The Current Value column will automatically calculate as Shares X Price. You must be able to calculate the Current Value from your database based on the number of Shares X the Share Price--and then sum these values