MIS 605 Introduction to Databases GCU

1. MIS 605 Introduction to Databases GCU Just Click on Below Link To Download This Course: https://www.coursetutor.us/product/mis-605-introduction-to-databases-gcu/ Or Email us on help@coursetutor.us MIS 605 Introduction to Databases GCU 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.

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

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

4. MIS 605 Full Course Assignments GCU MIS 605 Topic 1 Locating Database Content The purpose of this assignment is to practice navigating and identifying database tables and related fields. For this assignment, assume you have just been hired by Adventure Works Cycles company. As part of the orientation process, you have been asked to learn a little about the company by reading the “Adventure Works Cycles Company Story.” Your supervisor also wants you to gain an understanding of the content included in the company database. To do this, you must utilize SELECT and FROM statements like the example provided below. EXAMPLE: SELECT * FROM [Database].[Schema_Name].[Table_Name] Access the “AdventureWorks 2016 and Scripts for SQL Server 2016 CTP3” database and use SELECT and FROM statements to find the answer to each of the questions below. Create a Word document that includes the SQL queries used to explore the database tables and answer the following questions using the queries completed in steps 1-5. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to an Excel file for a visual check of accuracy. 1. Locate the “Person” table and run a basic SELECT query as listed in the example. List all the available fields and how many records exist in that table. 2. On what table and schema would you locate an applicant’s resume data? 3. When is the CEO’s Birthday? 4. What is the list “ListPrice” of the product “HL Touring Seat Assembly?” 5. Is “Holiday Skate & Cycle” a preferred vendor? Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected.

5. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 1 Proposal for Process Improvement The purpose of this assignment is to practice making proposals to communicate database needs to relevant stakeholders. For this assignment, assume you work at Adventure Works Cycles. Your manager recently informed you that by law, all employees must have an emergency phone number on file. This information is not currently included in the company database, so you must submit a proposal to the IT Department detailing your request to have it added. Using the “Proposal for Process Improvement” template, construct a Word document that outlines the requester, business problem, proposed solution, resources, implementation steps, benefits, and potential obstacles of the request. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 2 Interpreting and Building OpenOffice Draw Documents The purpose of this assignment is to analyze the structure of a relational database and demonstrate the ability to correctly document and explain additions to the structure of a relational database. Part 1: For this part of the assignment, you will use the “AdventureWorks 2014 OLTP Schema.” Open the schema and follow the tree/chain to answer the questions below in a Word document. 1. How does the Sales.SalesTerritory table relate to the Person.StateProvince table? Which table holds the Primary and the Foreign Key? On what field do they join together? 2. If you wanted to know the Planned Cost of a Product, what route would you take to the data? Identify the tables and fields used to join on each.

6. 3. Imagine a bonus was paid to an employee using a different currency. Identify the fields you would need so you could access the information. List all the tables involved and the fields used to join. Part 2: For this part of the assignment, you will continue to assume you work at Adventure Works Cycles company. In the Topic 1 assignment, you made a request to add a field to the company database. That request has been approved, and now the database diagram needs to be accurately updated. Create a simple OpenOffice Draw document demonstrating how your new table will connect to the Human Resources.Person table on the diagram. Since this is a new table, add new fields to create the proper relationships as you see fit. In a one or two paragraph Word document, explain how these fields relate to the rest of the database content. Compile the OpenOffice Draw file and Word document into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 3 Visualizing Business Problems The purpose of this assignment is to identify business problems that can be addressed through analyzing database content. For this assignment, assume the role of a data analyst at Adventure Works Cycles company. Your manager recently approached you with a problem. The company is losing money on its popular model “LL Road Frame-Black 60” but cannot determine why sales are down. You have been tasked to research potential reasons why this product, which your manager believes is solid, is not selling. In order to address this business problem, you must deconstruct it. Study the entity relationship diagram (ERD) titled “AdventureWorks 2014 OLTP Schema,” and use it determine the specific questions that must be asked and answered to address the problem.

7. In a 250-word document, address the following. Include basic information related to the problem along with specific information about the tables that should be researched. 1. Explain what methods will be used to set the parameters for the query. 2. Define the specific questions that need to be asked and answered in order to address the specified business problem. 3. Explain how the entity relationship diagram (ERD) was used in addressing questions 1-2 above. 4. Describe ethical dilemmas that could be encountered as a result of the research being done to address the business problem. 5. Explain what resources you will use to assist with addressing ethical dilemmas. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 4 Writing Queries to Get Data The purpose of this assignment is to design and implement queries that will assist in developing answers to business problems. For this assignment, continue to operate in the role of a data analyst at Adventure Works Cycles company. Based upon “LL Road Frame-Black 60” scenario and questions formulated for the Topic 3 assignment, write queries for the “AdventureWorks 2016” database using SQL Server 2016 Developer Edition. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions. 1. Find the product ID for the LL Road Frame – Black 60. 2. Find the listing price of the LL Road Frame – Black 60. 3. How would you rewrite the query used in question 2 to exclude NULL values? 4. How many orders have been placed for LL Road Frame – Black 60?

8. 5. Rename the OrderQty to Quantity in your results. Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 5 Advanced Queries The purpose of this assignment is to conduct advanced queries for the creation of separate reports. For this assignment, continue to play the role of the data analyst for Adventure Works Cycling Company. Your manager has asked you to localize query results into a temporary table to avoid running the same queries repeatedly and to better track the data. This will also free up network resources for the company. Saving queries is of the utmost importance since temporary tables are lost soon when you disconnect from the server. Failing to save a query will result in the need to rebuild the code for the temporary table. Using the queries completed in the Topic 4 assignment, complete the steps below and address the questions. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions. 1. Create a basic temporary table from work done in Topic 4, question 5 and call it “MyTempTable.” Write a SELECT statement to query the new data. 2. Order the results on MyTempTable by SalesOrderID. 3. Add a timestamp field called “DateRan” and update it to the current date. 4. Explain how to drop the table and start over. 5. Explain how the table can be re-added?

9. Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 5 Creating an Entity Relationship Diagram (ERD) The purpose of this assignment is to create temporary tables and document them using an entity relationship diagram (ERD). For this assignment, continue to play the role of the data analyst for Adventure Works Cycling Company. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code for the temporary table that includes the dates of each sales order. 1. Create a temporary table for each of the Topic 4 assignment data components. 2. Use the skills you have learned and practiced to write a query to determine the dates of each sales orders from a table you have not looked at yet. Create a temporary table for this information. 3. Use OpenOffice Draw to create a new entity relationship diagram (ERD) to document the addition of the temporary tables and the work stream. Show the relationship between the tables. Compile the OpenOffice Draw, Excel data file, and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA format is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite.

10. MIS 605 Topic 6 Joins The purpose of this assignment is to complete two complex queries, join them, and validate the expected results of the join. For this assignment, continue to assume the role of a data analyst at Adventure Works Cycling Company. As you work to address the business problem surrounding sales of the “LL Road Frame- Black 60,” you must continue to refine the data by condensing them into two tables. This requires you to join the table data sets together. While this is an important process, you must be aware of the data integrity issues that can occur as a result of completing joins. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions. Complete the steps below to practice joins. 1. Combine MyProduct and MyPriceHistory displaying the fields into a new temporary table called MyProductPriceHistory. Display ProductID, Name, EndDate, and List Price. 2. Combine MyProduct and MySalesOrderDetail displaying the fields into a new temporary table called MySalesOrderDetailbyName. Display ProductID, Name, SalesOrderID, and Quantity. 3. Combine MySalesOrderDetailbyName and ALLSalesOrderDates displaying the fields into a new temporary table called MySalesHistory. Display ProductID, Name, OrderDate, and SumOfQuantity. This will require you using the SUM and GROUP BY statements. Create a Word document that includes the SQL query code used for each of the joins listed. Additionally, identify and analyze the data integrity issues you encountered in SQL. 1. Discuss bad queries and bad table data in your analysis. 2. Explain the impact of the data integrity issues. 3. Indicate what needs to be revised in the code. 4. Discuss specifically what needs to be done to fix the data integrity issues created by the join. Please note that as part of your final project for the course you will be adding these new tables to the ERD you created in Topic 5.

11. Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 7 Query Optimization and Errors The purpose of this assignment is to update a previous query and present it in an easily readable format. For this assignment, continue to assume the role of a data analyst at Adventure Works Cycles company. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions. Part 1: 1. Using what you have learned, replicate the data found in #MySalesOrderDetailbyDate and #MyProductPriceHistory using a single line of SQL code. Refer back to the Topic 5 assignment for this information. 2. Modify the query completed in the Topic 6 assignment, and present it in an easy-to-read format. To do this, write the query in two single statements without temporary tables, using abbreviations and line spacing. Part 2: Karen Berge, a document control assistant at the company, comes to you with a request. Karen wants the titles and file names of all of the documents she has produced and has asked you to generate this information for her. Using what you have learned, produce a query in one statement to give her the information she needs. Note that constructing the query will require some thinking outside the box since the relationships are not well documented.

12. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. This Excel file should include the names of all documents Karen has produced. Add to the Word document you created in Part 1 and include the SQL query code associated with the query you wrote to locate Karen’s documents. Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 8 Stored Procedures The purpose of this assignment is to build a stored procedure that allows for the compression of data and the ability to run a process repeatedly over time. For this assignment, continue to assume the role of a data analyst at Adventure Works Cycling Company. Your manager is waiting for you to deliver your analysis of why the company is losing money on its popular model “LL Road Frame-Black 60.” As you are preparing your final report, your manager asks you to save your final queries from Topic 6 (the two nontemporary queries) as a stored procedure so you can periodically check on them from time to time. To do this, you will need to complete the steps below. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code used to explore the database tables. 1. Drop all ORDER_BY statements from the query. 2. Label one as PriceHistory723. 3. Label the other as SalesOrderDetailbyDate723.

13. Compile the Excel data file and Word document containing the SQL queries into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. MIS 605 Topic 8 Final Project The purpose of this assignment is to analyze data and use it to provide stakeholders with potential answers to a previously identified business problem. For this assignment, continue to assume the role of a data analyst at Adventure Works Cycling Company. Evaluate the data associated with the drop in sales for the popular model “LL Road Frame-Black 60.” Provide a hypothesis on what could be contributing to the falling sales identified in the initial business problem presented by your manager. In 250-500 words, share these recommendations in a Word document that addresses the following. 1. Summary of the business problem including the requestor who initially brought the problem to you. 2. Summary of the data that were requested and how they was obtained. 3. Discussion of the limitations of the available data and ethical concerns related to those limitations. 4. Hypothesis of why sales of the popular model have dropped based upon data analysis. Reference the Excel file that summarizes the data findings that resulted from your queries. 5. Recommendations for addressing the business problem. 6. In addition to the report, the manager has requested that you submit the Excel files summarizing the data findings that resulted from your queries. 7. The manager has also requested that you update the ERD you created in the Topic 5 assignment to include the tables generated as a result of the joins completed in the Topic 6 assignment. The ERD should clearly document the work stream and relationships.

14. Compile the updated ERD, Excel data file, and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. Download Now