Create a query that shows the name of the client, the address information, investor contact, and client services contact.ī. 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):Ī. But make sure you can accomplish the following querying tasks-several of which will require you to join multiple tables together. The T-SQL Select statement doesn't allow you to do much in the way of formatting your output. There is no specific "look-and-feel" for your reports/queries. White a series of T-SQL SELECT queries to report the data that you have inserted into your database. 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?ģ. 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. Important: In your report, paste the text of your T-SQL Insert statement for review by your instructor.Ģ. All other data-other than the client-can be entered using the SSMS Edit Table feature. But there is one additional requirement that was not part of the previous project-you must add the new client using the T-SQL Insert statement. First, you need to add the data to the database that has been provided to you in the Excel document. In preparing your progress report you will need to perform all the following:ġ. Furthermore, this assignment gives you an opportunity to see if you can create some fairly complex queries from the data that you have. This assignment is all about ensuring your database and its design is capable of handling new data-especially when that data might be in a slightly different form than the data you have already been working with. You already have data in your database, and certain design changes may require you to first delete the data that you already have. Can your database design handle this zip code format?Īnd, yes, this is new information and your database design may need to change as a result. They are in the format A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters. How are you going to accommodate the province of "Ontario," in this specific example? Also, Canadian zip codes are alphanumeric. Canada is not comprised of states, but rather of provinces-10 to be specific. The company you are adding is a Canadian company. The data that needs to be added can be found in the Excel document. In this project, you will add a new client to your database, four stock holdings for this client, and create several queries. In your previous assignment you created your database using SSMS, added data, and ran a simple query. This is part of the requirement for building effective and efficient databases. You must read these case studies carefully and thoroughly to fully understand their business and their needs. Though fictitious, the narrative and issues discussed are very real for many companies. Part of your work over the course of the semester will be to design and build a database for this fictional company. This is the sixth and final installment of the case study for a company called National Investments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |