MIS 610 Topic 1,2,3,4,5,6,7 DISCUSSION

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

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 Ma...

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...

MIS 610 Topic 3 DQ 1 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 industr...

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 you...

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 t...

MIS 610 Topic 4 DQ 2 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...

MIS 610 Topic 5 DQ 2 Describe four key features of an object database management group (ODMG) and what makes this technology so appealing for so many different types of users. From those you previously identified, select the key feature you believe to be the most essential and versatile, and provide...

MIS 610 Topic 6 DQ 1 Of the two object-capable data programming methods, what attributes of object relational design make it the more preferred method? Justify your ideas with support from the Topic Materials or relevant industry examples.

MIS 610 Topic 6 DQ 2 Some consider SQL to be an ORDBMS due to several recently implemented features it provides, but most consider it an RDBMS. Oracle once touted itself as an ORDBMS in Release 8, but later retracted that statement in Release 8.1 (while retaining key desirable organizational feature...

MIS 610 Topic 7 DQ 1 Referring to the topic reading “Whatever Happened to Object-Oriented Databases?”, do you agree with the position that an object-oriented database is a niche market? Provide your assessment of the author’s stance, supporting your rationale with findings from the literature ...

MIS 610 Topic 7 DQ 2 Google and Amazon have done some amazing work regarding their database management systems. However, one of the constants is a lack of standardization. How do new DBMS products entering the market, such as graph databases, help or hinder companies trying to modernize? Justify you...

MIS 610 Topic 8 DQ 1 You have employed several commonly used database automation tools in your work throughout the course. Discuss which of these tools has proven to be the most useful overall. Provide your reflective analysis with support from your work, an industry example, or the Topic Materials.