Wk 3 Assignment 1 Request Interpretations This assignment will allow you to support a DBA as he/she wrestles through strategy of planning modifications to existing databases. Work your way through the...

check the attach file


Wk 3 Assignment 1 Request Interpretations This assignment will allow you to support a DBA as he/she wrestles through strategy of planning modifications to existing databases. Work your way through the Colonial Adventure Tours Case: · Question 1 - page 281 · Interpret requests and create queries to retrieve data needed to fulfill those requests · Learn how to dissect a massive project for manageability Use the textbook and at least two other resources to complete this assignment. Along with your explanations and proposed solutions, site the resources you used in APA format. Save your file as MISE4643_YourName_Wk3Assignment1 to your computer. Upload and submit your file to this dropbox. Wk 3 Assignment 2 Your Own Version of GRASPS as a DBA - Project Intro It is important to create an assessment of an end-user request and have the ability to wade through details so that there is full understanding and acceptance on both sides before work begins on a major project. From the GRASPS video, create your own version of a GRASPS model for the request in Question 4 of the Colonial Adventure Tours Case on page 281. Outline each of the following: · Goal - challenge or problem · Role or Responsibility · Audience · Situation or Scenario · Product or Performance Save your file as MISE4643_YourName_Wk3Assignment2 to your computer. Upload and submit your file to this dropbox. Wk 3 Project Phase 1 Project Request - Phase One This is an ongoing, three-part project, that will need to be submitted in its entirety at the end of week 5. Phase one of this project should prepare you to move into the remaining phases. Read through the Colonial Adventure Tours Case: Question 4 - page 281. Using the GRASPS model you created for Assignment 2 of this week, begin mapping out possible tables and relationships that would need to be considered to provide a solution for the company. Explain why these additional tables are needed. Explain the table relationships chosen and why your approach will efficiently and accurately accommodate the company’s request to add reservations from sports clubs. Save your file as MISE4643_YourName_Wk3Project_Phase1 to your computer.  Wk 3 Journal Journal of Resources Remembering what you’ve used: As research for solutions to problems has been conducted, use this time to reflect on the resources you used and in what way they were used. List all resources used for this week that are outside of the recommended material, and share how the information from the resource helped you. This journal should be a bulleted list of resources in APA format with a brief (no more than 100 words) explanation of how the resource was used. Save your file as MISE4643_YourName_Wk3Journal to your computer.  Wk 4 Assignment SQL Review Now that you are bit more seasoned in understanding SQL, go back and complete the review questions of chapter 3 on pages 127-128. The purpose of this assignment is to solidify SQL components and engage your mind in something you should understand by this point in the course. Save your file as MISE4643_YourName_Wk4Assignment to your computer.  Wk 4 Project Phase 2 Project Request - Phase Two This is an ongoing, three-part project, that will need to be submitted in its entirety at the end of week 5. Phase two of this project involves ERD and normalization and should prepare you to move into the third and final phase. Continue using the Colonial Adventure Tours Case: Question 4 - page 281 Using the proposed tables and relationships you created in Week 3, create an ERD that is normalized to the most optimal normal form for your table set. Show the tables in the rawest form (tables and relationships form week 3 should suffice). Then show each normal form necessary to get the tables to the optimal state. Write the queries in SQL that would be required to add these tables and relationships to the database. Finally, list a minimum of 3 possible requests from the company regarding details about reservations from sports clubs. Convert those requests into SQL syntax with the aid of the textbook. Save your file as MISE4643_YourName_Wk4Project_Phase2 to your computer.  Wk 4 Journal Journal of Resources Remembering what you’ve used: As research for solutions to problems has been conducted, use this time to reflect on the resources you used and in what way they were used. List all resources used for this week that are outside of the recommended material, and share how the information from the resource helped you. This journal should be a bulleted list of resources in APA format with a brief (no more than 100 words) explanation of how the resource was used. Save your file as MISE4643_YourName_Wk4Journal to your computer. Wk 5 Project Final Project Request - Final Phase For the final phase of this project, you will create two independent documents that illustrate what you created in the first two phases. This is not intended to be a landing place for combining everything into one document. Instead, you will need to pull details and concepts into two separate formats and submit both of these formats as the final document: Executive Summary: Use the documents mentioned in this week’s material (https://www.business-plans-guide.com/executive-summary-example.html and https://www.inc.com/guides/2010/09/how-to-write-an-executive-summary.html), along with other research of your own to craft an executive summary of the project request and a final solution. The executive summary should be more more than one full page. Post-Mortem Document: Use the document mentioned in this week’s material (https://www.klariti.com/technical-writing/2015/05/14/how-to-perform-a-post-mortem-on-your-technical-documents/), along with other research of your own to creat a post-mortem document. This document can get rather lengthy, but it should not exceed 5 pages due to the size of the request. Use this document to evaluate the request and yourself in this process. How would you recommend approaching things differently? Save your file as MISE4643_YourName_Wk5Project_Final to your computer. Wk 5 Journal Journal of Resources Remembering what you’ve used: As research for solutions to problems has been conducted, use this time to reflect on the resources you used and in what way they were used. List all resources used for this week that are outside of the recommended material and share how the information from the resource helped you. This journal should be a bulleted list of resources in APA format with a brief (no more than 100 words) explanation of how the resource was used. Save your file as MISE4643_YourName_Wk5Journal to your computer. How to Remote into MACU-DMBS Server PC Instructions 1. Press the “Windows” key, or click inside the search box begin typing “remote desktop” 2. Click on “Remote Desktop Connection” 3. On the line for “Computer” for connecting from off-campus type 156.110.0.125, to connect from on-campus type 172.18.202.245 4. You will then be asked for your credentials which would be your mymacu credentials. If your mymacu username is not already entered, click More choices and choose Use a different account. Enter your mymacu username in either this format: mymacu\, or as an email address: @my.macu.edu. For example, a user with an email of [email protected] can either enter it exactly that way, or choose to enter mymacu\jane.doe. Either way works. 5. Click “Connect” - The very first time, you will see the following notification. As illustrated, check the box that says “Don’t ask me again for connections to this computer” and then click “Yes” 6. You should now be connected and see a desktop with links to the applications you will use for your course.