100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
MIS-605: Topic 1,2,3,4,5,6,7,8 DISCUSSION $20.99   Add to cart

Package deal

MIS-605: Topic 1,2,3,4,5,6,7,8 DISCUSSION

Topic 8 DQ 2 Topic 8 DQ 1 Week 7 DQ 2 Week 7 DQ 1 Topic 6 DQ 2 Topic 6 DQ 1 Topic 5 DQ 1 Topic 5 DQ 2 Week 4 DQ1 Topic 3 DQ 2 Topic 3 DQ 1 Topic 2 DQ 2 Topic 2 DQ 1 Topic 1 DQ 2 Topic 1 DQ 1

15 items

MIS-605: Topic 1 DQ 1

(0)
$8.49

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

View example

MIS 605 Topic 1 DQ 2

(0)
$7.99

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.

View example

MIS-605: Topic 2 DQ 1

(0)
$7.99

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.

View example

MIS 605 Topic 2 DQ 2

(0)
$7.99

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

View example

MIS-605: Topic 3 DQ 1

(0)
$7.99

MIS-605: Topic 3 DQ 1 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-ma...

View example

MIS 605 Topic 3 DQ 2

(0)
$7.99

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?

View example

MIS 605 Week 4 DQ1

(0)
$7.99

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

View example

MIS 605 Topic 5 DQ 1

(0)
$7.99

MIS 605 Topic 5 DQ 1 Explain how temporary tables can be used and why this is beneficial to the company. Provide specific examples to support your ideas. Explain why it is important to clear temporary tables, and discuss what could happen if this is not done.

View example

MIS-605: Topic 5 DQ 2

(0)
$7.99

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

View example

MIS 605 Topic 6 DQ 1

(0)
$7.99

MIS 605 Topic 6 DQ 1 Explain the difference between an INNER and OUTER join. Discuss why you would select one over the other using a specific example.

View example

MIS-605: Topic 6 DQ 2

(0)
$7.99

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

View example

MIS 605 Week 7 DQ 1

(0)
$7.99

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

View example

MIS 605 Week 7 DQ 2

(0)
$7.99

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

View example

MIS 605 Topic 8 DQ 1

(0)
$7.99

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

View example

MIS 605 Topic 8 DQ 2

(0)
$7.99

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

View example
avatar-seller
abram23

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller abram23. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $20.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

89358 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$120.35 $20.99
  • (0)
  Add to cart