MIS 605 (mis 605)

Topic 8 DQ 2 Explain how keeping an up-to-date ERD ensures data integrity. If someone looks over the ERD and finds and error, explain how the error could be fixed and the update/change communicated to other stakeholders. Discuss the potential backlash that could result from a misreported dataset.

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

Topic 8 DQ 1 In theory, how complex could a View statement get? Discuss whether there would be an advantage to chain multiple views under another view. Where does it stop? Explain the possibilities, and support your ideas with specific examples. The complexity is exponential with each addition of each field. Careful attention needs to be made for each line so as not make minute errors, especially with the addition of aliases. Perhaps, experience mitigates the ease or complexity (subjective...

Week 7 – DQ 2 Using the AdventureWorks database, create your own unique query using at least three tables. Post the query in the Main Forum. Explain the query and what the data are telling you. Comment on the queries, accuracy, and interpretation of the data listed in posts from two of your peers

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 an

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

Explain the difference between an INNER and OUTER join. Discuss why you would select one over the other using a specific example. An inner join looks at what is shared between the two tables. In order to use an inner join, there must be some matching data between the tables that are being compared. It searches tables for matching data. When it has found the data, the inner join combines the tables being used into one new table with all the information the user wanted to find.

Your manager has difficulty understanding how SQL works and what insights the queries you have completed reveal. Discuss how you can communicate this information to the manager to get your point across. Provide specific ideas for ways to share the information in easy to understand terms. If my manager was having a hard time understanding how SQL works and what my queries have found, I would set a time to meet my manager one on one to explain to them how it works. During the meeting, I woul...

MIS 605 Week 4 DQ1