MIS 605 (mis 605)

MIS 605 Topic 3 DQ 2 Your manager has informed you that another manager's team sales are going to be included as part of your team's sales report this month. Discuss whether you would report this. If so, to whom? Explain why? Yes, I would report this. I would first report to my manager since they are my direct superior. Then I would report to the other manager, unless my manager said to do otherwise. This may happen because my manager would want to tell the other manager instead of me te...

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. There is a need for the division of labor within the company and the different departments. As it allows each position to have their own tasks that need to be accomplished. One perso...

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. Microsoft Access and SQL Server are both developed by Microsoft. They are both relational database management systems and ha...

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 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. Determining what information is needed, why the information needed, and how to get and use that information are some of the most important questions. Referring back to the scenario I create...

 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. A query becomes complex when we have derived the need to combine various forms of data from multiple tables for a specific outcome. Even more complex, when we haven’t...

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

Assume you have a position as database administrator in a large corporation. The company has been collecting data about employees, including monitoring their working habits by recording their keystrokes, timing their telephone interactions with clients, and scanning their e-mail for personal correspondence. As database administrator (DBA), you are asked to help establish a record-keeping system to store such data. Does the company have a legal right to perform this kind of monitoring? Expla...

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

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.