Posted: March 12th, 2023

Networking and Database reports

See atched docs

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.

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

http://www.edrawsoft.com/templates/images/ethernet-lan-diagram

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 w ired 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 n eed 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 Milestone Two Guidelines and Rubric

Rubric