MIS 610 Full Course Discussions GCU
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.
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 how you could apply this knowledge to a workplace project or scenario.
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 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 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 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 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 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 ideas with support from the Topic Materials or relevant industry examples.
MIS 610 Topic 5 DQ 1
Explain why it may be more efficient for a company to utilize an RDBMS based on workforce skill and availability. Discuss how a company might be able reduce costs through using an OODMS instead. Identify current or proposed/future developments that might influence a business to continue “as is” or leap to a different system. Justify your ideas with support from the Topic Materials or relevant industry examples.
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 your predictions of how this specific feature will be or could be improved to make it even more useful in the future. Justify your ideas with support from the Topic Materials or relevant industry examples.
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 features). What programs are actually considered “object based”? Select a specific program and explain both its functionality and advantages to a business. Justify your ideas with support from the Topic Materials or relevant industry examples.
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 or relevant examples from the field.
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 your ideas with support from the literature or relevant industry examples.
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.
MIS 610 Topic 8 DQ 2
Looking forward to current and future needs in your own industry or one in which you desire to work, describe how the more advanced SQL server integration services (SSIS) data migration software, SQL server analysis services (SSAS) online analytical processing technology, or SQL server reporting services (SSRS) report software could be useful for the industry’s current needs as well as to propel growth. Justify your ideas with support from the Topic Materials or relevant industry examples.
Reviews
There are no reviews yet.