Design a very small database and a create a brief description of the below 3-4 steps in a doc
1. You need to add the data to the database that has been provided to you in the Excel document. You must add the new client using the T-SQL Insert statement. All other data—other than the client—can be entered using the SSMS Edit Table feature.
Important: In the doc, paste the text of your T-SQL Insert statement.
2. Write a paragraph describing any changes that you needed to make to your database design and implementation as a result of the materials provided here and in the Excel document. In a few sentences, what could you have done in the early design process that would have prevented any issues at this point in your project?
3. White a series of T-SQL SELECT queries to report the data that you have inserted into your database. There is no specific "look-and-feel" for your reports/queries. The T-SQL Select statement doesn't allow you to do much in the way of formatting your output. But make sure you can accomplish the following querying tasks—several of which will require you to join multiple tables together. The goal is to demonstrate that you can produce the desired output and that you can do so with a single T-SQL Select statement for each of the following (all queries in this project should use the data provided as part of this project for City of Windsor Fire Pension):
a. Create a query that shows the name of the client, the address information, investor contact, and client services contact.
b. Create a query that displays the name of the client and then the "sum" total of the value of their account. This is to say that it needs to calculate the shares X price for each investment and total these and show that total with the name of the client. Hence, this query should result in only one row for each company that you query.
c. Create a query that shows each stock, stock company name, price, shares, and total investment (shares X price).
d. Create a query that shows the client, the management fee, and then calculate what the total management fee will be based on the value of the investments being managed. For example, if the total value of the investments equal $10 million, then the total management fee will be $93,000.00.
You will copy the T-SQL query statements that you write into your progress report in the doc, making sure that you carefully document what each query does with what it produces. To document the results simply include a screen capture of your SSMS screen.
11 freelancer đang chào giá trung bình ₹9303 cho công việc này
hey how are you need asp.net mvc or [login to view URL] core developer em here for your assistant please ping me to discuss more on this and for front end #React js #angular js #angular
Hi, I have gone through the details which you have shared and I can do this. I have an experience of 10+ years in database. Ping me in chat for more details, Thanks in advance.