Computer Information Technology Study guides, Class notes & Summaries

MIS 605 Week 7 DQ 1 Describe how complex a query can get, by locating an example of a complex AdventureWorks query online. Post a link to the example in the Main Forum. Include an explanation of what the data are telling you. Comment on the accuracy and interpretation of the posts and data listed by two of your peers.

MIS-605: Topic 6 DQ 2 In the topic assignment, the two temporary tables (#MyPriceHistory and #MySalesOrderDetailbyDate) cannot be joined in their current state. Explain why this join is not possible. Discuss what you think is missing in order to make a join work and propose the solution to your peers in the Main Forum.

MIS-605: Topic 5 DQ 2 There is a division of labor from the business, to the analyst, to the IT department. Explain how having each of these roles ensures the proper requests are submitted. Would it be easier to have one person handle it all? Defend your answer using specific examples to justify your reasoning.

MIS-605: Topic 2 DQ 1 Explain why database designers use relationships to construct a database instead of listing all the records in one location. Some think it would seem easier to have all the information in one place, so explain why using relationships is the standard.

MIS 605 Week 4 DQ1 In the Topic 4 assignment, a key query has been left out. You were not asked to query the date of the sales orders. Discuss how you think you would complete that query. Explain why this query is important as you attempt to address the business problem that has been presented to you.

MIS 605 Topic 1 DQ 2 Explain metadata, why metadata are important in a database design, and metadata's connection to the schema. Include specific examples to support your ideas.

MIS-605: Topic 1 DQ 1 In the Topic Material "Microsoft SQL Server vs. Oracle: The Same, But Different?" two relational database management systems were compared. Conduct research and evaluate the pros and cons of two additional systems. Some to consider could include MYSQL, PostgreSQL, IBM DB2. Include relevant links to related articles and content when appropriate.

MIS 665 Topic 3 DQ 2 By definition, simulations require a distribution to be specified (e.g., normal, Poisson). Many times, the exact distribution to be used is unknown, so it must be assumed. One argument against using simulations to perform risk analysis is that there is no real benefit because the set of assumptions is simply shifted from assumed parameter values to assumed distributions of parameters. Comment on this argument and justify your opinions with reasons, facts, and examples.

MIS 665 Topic 3 DQ 1 Before computers were widespread, almost all risk analysis was done without simulation. Therefore, only a handful of scenarios could be formulated to understand the risk of a decision. Typically, a best-case and worst-case scenario was determined and decisions were based on these two scenarios. What are some of the drawbacks of this decision-making approach? Specifically, how does the capability to summarize 1,000s of simulated scenarios improve the approach?