Mis 605 topic 2 dq 2 Study guides, Class notes & Summaries

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. Provide two peers with feedback about the potential answers to this question and justify why you think one answer might be more correct than others that are proposed. The ke...

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. Audits of the ERD, reporting the findings, and making recommendations to management, ensure data integrity. As the data and combinations of deriving information grows (implementation of a...

MIS 605 Topic 2 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

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: Topic 2 DQ 1

MIS-605: Topic 5 DQ 2

MIS 605 Topic 3 DQ 2

MIS 605 Topic 2 DQ 2 In the Topic Materials you read "Codd's 12 Rules" and learned about how in 1985, Dr. E. F. Codd developed the rules for an ideal relational database. Although all of the rules were not actually used, explain why they have served as a guideline for developers over the last few decades. Provide specific examples to support your ideas. Codd’s 12 rules is a set of rules that a database management system (DBSM) must have if its to be considered relational. These rules wer...

MIS-605: Topic 4 DQ 2 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. MIS-605: Topic 4 DQ 2 Your manager has difficulty understanding how SQL works and what insights the queries you have completed reveal. Discuss how you can communicat...