Unit 6 Discussion Topic 1

Discussion Introduction/Overview

The following Discussion topics relate to your readings in Unit 6 and experiences you may have had in the areas of result set analysis and other technology issues you see in the news that related to databases. To successfully complete the Discussions, you must respond to the base question with an initial Discussion post no later than Saturday of each week and then reply to at least two other responses on different days before week end. See the Discussion rubric for questions on requirements.

Topic 1: Result Sets

Explain how you would analyze your result set to determine if is correct.

Unit 6 Topic 1

Brandon Eddy posted Dec 13, 2017 9:28 AM

Hello Everyone,

“Explain how you would analyze your result set to determine if is correct.” I assume this discussion is asking how to determine if a query’s results are correct. The most obvious method I can think of would be to compare the query to the information in the database to determine if the query is only showing you the information you asked for. But that seems kind of tedious and defeats the purpose of making a query in the first place. So, I guess you could analyze your results by simply looking to see if the data you get back in your results is the data that you asked for. If there is extra data there that you do not need, you could refine the query to narrow down the results. However if there is missing data, the only way I can think of to determine this would be either to double check the parameters of your query or you could break the query up into smaller queries and compare the data. For example if you had a statement with a JOIN operator, you could split that up into 2 queries, one for each table, and look to see if the same data is in the JOIN query as there is in the two separate queries. If anyone has a better method to analyse results, please don’t hesitate to correct me on this post.

Brandon

Powered by TCPDF (www.tcpdf.org)