This assignment will be submitted to Turnitin®. Instructions Prepare networking and database reports for the scenario provided. For the networking report, describe the network configuration,...

This assignment will be submitted to Turnitin®.
Instructions
Prepare networking and database reports for the scenario provided. For the networking report, describe the network configuration, explaining the role of each component and connection, following the diagram provided by your supervisor. Write a short description of any components you think are missing from the network diagram and provide a potential rationale that explains why you think these components are critical to the network. Specifically, state the functions of the components and describe how they contribute to the network. For the database report, modify the appropriate components of the provided database with the information regarding the employees' computers and the upgrade. The table containing the date of each computer's upgrade should be updated upon completion of this upgrade. The query identifying each employee's upgrade date should be run. This will serve as the type of report that would be given to Help Desk staff to communicate with employees. For additional details, please refer to theMilestone Two Guidelines and Rubricdocument, theNetwork Diagram, and theMilestone Two Database

IT 505 Milestone Two Guidelines and Rubric IT 505 Milestone Two Guidelines and Rubric Prompt You are a new employee at an IT help desk. The organization that you work for has computers that are due for an operating system (OS) upgrade. Your supervisor has provided you with components of the implementation plan to carry out in order to facilitate a smooth upgrade process in each department. For Milestone Two, you will submit a network and database report based on the resources provided. For the networking report, describe the network configuration, explaining the role of each component and connection, following the diagram provided by your supervisor. Write a short description of any components you think are missing from the network diagram and provide a potential rationale for why you think these components are critical to the network. Specifically, state the functions of the components and how they contribute to the network. For the database report, modify the appropriate components of the provided database with the information regarding the employees’ computers and the upgrade dates. You will then run a query identifying each employee’s upgrade date. Specifically: 1. Open up each table in the database to view the data and examine its formatting. Be sure to open the database in regular and design view. Describe what each table contains and any data types that are other than text. 2. Open the Table Upgrade Information in design view. Change the data type of the “Upgrade Date” field from “text” to “Date/Time”. 3. Enter the appropriate date for each assignment based on the assignments group number. Do this in regular view of the table. Use the same dates that you used for Milestone 1. The groups and their corresponding dates for upgrade should be as follows: Group 1: Use the same initial upgrade date at least 30 days in the future that you used for Milestone 1. Group 2: This date should be 2 days after the initial upgrade date. Group 3: This date should be 5 days after the initial upgrade date. Group 4: This date should be 8 days after the initial upgrade date. Group 5: This date should be 10 days after the initial upgrade date. 4. Once you have entered the dates in the appropriate column in the Table Upgrade Information, save your data and close the table. Describe the steps you took to complete this task. 5. Open the upgrade list query in design view. Make note of the actions it is taking and how the tables are linked. Describe how the tables are linked and why you think the linking is done in this way. Then describe what data the query is pulling. Then click “Run.” Take a screenshot of the results of your query to include in your submission. https://learn.snhu.edu/d2l/lor/viewer/viewFile.d2lfile/395659/2537,-1/ https://learn.snhu.edu/d2l/lor/viewer/viewFile.d2lfile/395659/2536,-1/ https://learn.snhu.edu/d2l/lor/viewer/viewFile.d2lfile/395659/2536,-1/ Rubric Guidelines for Submission: Written components of projects must follow these formatting guidelines when applicable: double spacing, 12-point Times New Roman font, and one-inch margins. Critical Elements Exemplary (100%) Proficient (90%) Needs Improvement (70%) Not Evident (0%) Value Network Configuration – Explanation Meets “Proficient” criteria and elaborates on the explanation for the wired configuration with examples of how it addresses enterprise needs Clearly describes the wired network configuration and provides a comprehensive explanation of most components and connections Describes the wired network configuration and attempts to provide an explanation of most components and connections; however, key information is missing or inaccurate Does not describe wired network configuration 20 Network Configuration – Evaluation Meets “Proficient” criteria and provides specific examples that highlight the significance of the missing components Accurately describes the critical components necessary for a network that are missing from the wired network diagram Describes the critical components necessary for a network that are missing from the diagram; however, key information is missing or inaccurate Does not describe the critical components that are missing or their roles 20 Network Configuration – Rationale Meets “Proficient” criteria and substantiates the importance and functions of the missing components with examples Provides a rationale for the critical components that are missing from the configuration, based on the functions of the missing components Tries to provide a rationale for the critical components that are missing from the configuration; however, information is missing or inaccurate Does not provide a rationale for the need for the missing components 20 Database Modifications – New Data Field Meets “Proficient” criteria and provides a detailed explanation of the steps taken Accurately creates and describes a new data field for the database Incorrectly creates or describes a new data field for the database Does not make a new data field for the database 20 Database Modification – Data Query Meets “Proficient” criteria and provides a well-detailed description of how the tables are linked and why, and what data the query is accessing Describes how the tables are linked and why, and what data the query is accessing Attempts to describe how the tables are linked and why, and what data the query is accessing; however, is incomplete or inaccurate Does not describe how the tables are linked and why, and what data the query is accessing 20 Total 100% IT 505 Network Diagram IT 505 Network Diagram This is an illustration of the network configuration for the organization. Use this diagram for Milestone Two and the Final Project. Source: http://www.edrawsoft.com/templates/images/ethernet-lan-diagram.png http://www.edrawsoft.com/templates/images/ethernet-lan-diagram.png