MIS 605 Full Course Discussions GCU

  • Description
  • Reviews (0)

Description

MIS 605 Full Course Discussions GCU

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

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-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? Explain your professional responsibility in this situation. Discuss provisions within the ACM and IEEE Codes of Ethics that can be used to guide you.

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?

MIS 605 Topic 4 DQ 1

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

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

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.

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

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.

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.

 

 

Course Tutor helps in providing the best essay writing service. If you need 100% original papers for MIS 605 Full Course Discussions GCU, then contact us through call or live chat.

MIS 605 Full Course Discussions GCU

Best MIS 605 Full Course Discussions GCU

MIS 605 Full Course Discussions GCU

ACCT 553 DeVryBIAM 500 DeVryCIS 500 STRCIS 558 STRENG 105 GCUFIN 390 DeVryFIN 504 GCUHCA 545 GCUHCA 699 GCUHLT 306 GCUHLT 362 GCUHLT 555 GCUHLT 610 GCUHLT 665 GCUHOSP 594 DeVryHRM 600 DeVryMAT 144 GCUMGMT 600MGT 599 STRMGT 655 GCUMKT 373 GCUPSY 362 GCUPSY 565 GCUPSY 575 GCUPSY 665 GCUSOC 102 GCUSOC 320 GCUSOC 372 GCUSOC 412 GCUNSG 6440 SUHIM 515 GCUNSG 4029 SUHIM 615 GCUNSG 3029 SUNSG 4055 SUNSG 6630 SUNSG 6005 SUCRMJ 310PSY 510 GCUCRMJ 300 DevryCRMJ 425SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCUMGT 640 GCUCIS 527 STRSOC 436 GCU,ACC 502 GCUFIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVryNETW 203 DeVryNETW 205 DeVryECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVryPSY 402 GCU , SOC 480 GCU , HUM 112 STR , PHI 210 STR,  ACC 667 GCU,  ACC 622 GCU,  ACC 623 GCU,  ENTR 510 DeVryDNP 840 GCU , BIO 550 GCU , HRM 420 DeVry , ACC 690 GCU  , HCA 807 GCU , ACC 650 GCU , REET 420 DeVry , MIS 605 GCU

 

 

Reviews

There are no reviews yet.


Only logged in customers who have purchased this product may leave a review.

You've just added this product to the cart: