MIS 610

MIS 610 Topic 4 DQ2 Determinism of a function is one of several properties of user-defined functions that determine the ability of SQL to index results. When and for what purposes would you choose to use deterministic versus nondeterministic functions to arrive at your desired results? Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 4 DQ 1 Using your experiences thus far regarding NULL values and aggregation, discuss when it is a good idea to assume there might be NULL data in your records. Explain why extra coding may be worthwhile. Discuss whether one should only do the extra work involved in this process when there is an issue. Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 3 DQ 2 Explain why data integrity is critical to performing unions or subqueries. Identify downstream effects that may result from inferior or substandard data. Describe measures one can take to ensure data integrity before beginning analysis in order to avoid poor results. Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 3 DQ1 Explain how a UNION function operates and how the resulting data is intended to be used. Discuss the weaknesses that exist, and strategies for making the process stronger to deliver a better end result. Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 2 DQ 2 . With CASE data studies, you are technically manipulating the data. Explain how you would know if you are looking at a report that had modified data on it. If data have been modified, explain how you could identify what specific data was changed. Discuss three common reasons data might be modified. Explain ways that data manipulation could become an ethical concern. Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 2 DQ 1 Review the Topic Material “Dirty Secrets of the CASE Expression.” Based on this article and the other topic readings, identify one limitation you could encounter in the workplace and describe strategies for circumventing it. Justify your ideas using support from the Topic Materials or relevant industry examples.

MIS 610 Topic 1 DQ 2 Reflect on the content of the Topic Materials and discuss the following. 1. Explain how you used the knowledge you gained from the Topic Materials to complete the topic assignment. 2. Discuss the workplace relevant “takeaways” you gained from this topic and provide an example of how you could apply this knowledge to a workplace project or scenario.

MIS 610 Topic 1 DQ 1 Describe the difference between static and dynamic embedded SQL. Provide two real-world examples of situations are most suitable to each of these procedural events along with a rationale for each.