Description
I need 7 question answer all in like a paragraph at least is about network those 7 question I need it completed by two hours from now so by like 8:30 your help will be greatly appreciated.
1. (TCO 1) What is the function of the access layer? Discuss the equipment used at this layer, the criteria used to select the equipment, the size of the network that would use this layer, and whether redundancy is typically used here. Question 2. 2. (TCO 2) In the top-down network design model, why are the organizational and business goals and constraints listed first? Question 3. 3. (TCO 3) What are the network application characteristics and considerations? Question 4. 4. (TCO 5) Is the Internet viable as WAN backup technology? What are its advantages and disadvantages? What methods are used to connect networks over this media? Question 5. 5. (TCO 6) What are some of the factors that affect voice quality during VOIP calls? Question 6. 6. (TCO 7) What are some of the common threats and risks? Question 7. 7. (TCO 4) What are the considerations for the use of STP?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Nice! Really impressed with the quality.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
198 pages
Sql Tutorial
SUBDATE(date,INTERVAL expr unit) and SUBDATE(expr,days) ......... 145 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ...
Sql Tutorial
SUBDATE(date,INTERVAL expr unit) and SUBDATE(expr,days) ......... 145 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ........................ ...
South University Information Technology Project Management Question
Project Charter: Developing a Corporate Website
This assignment is in continuation to the project discussed in the Submiss ...
South University Information Technology Project Management Question
Project Charter: Developing a Corporate Website
This assignment is in continuation to the project discussed in the Submissions Area assignment in Week 1.
In a 2- to 3-page Microsoft Word document, create a project charter for the project for developing a corporate Website. The project charter should consist of detailed description of different aspects in all the different phases of the project.
It should include the following details:
Project objective
Manager's authority
Project deliverables
Approach of the project
2 pages
Dog Class
// this keyword refers to the variable dogSpaceNumber inside the Dog class System.out.println("My Dog has a space number o ...
Dog Class
// this keyword refers to the variable dogSpaceNumber inside the Dog class System.out.println("My Dog has a space number of " + d.dogSpaceNumber +
ITS 410 CSU Python Worksheet
Your Portfolio Project consists of two items, a lessons learned reflection report and a database design and analysis proje ...
ITS 410 CSU Python Worksheet
Your Portfolio Project consists of two items, a lessons learned reflection report and a database design and analysis project.Lessons Learned and ReflectionWrite a 2- to 3-page summary that outlines the lessons you learned in this database class. Reflect on how these lessons can be applied toward more effective database management and reporting.Database Design and AnalysisUse the Accidents_2016.csv file below to implement the following steps for your database project.Create a MySQL schema named “accidents.”Within the accidents schema, create a table named accidents_2016 with the following columns:accident_index as a varchar(13),accident_severity as an intWithin the accidents schema, create a table named vehicles_2016 with the following columns:accident_index as a varchar(13),vehicle_type as a varchar(10)Within the accidents schema, create a table named vehicle_type with the following columns:vcode int,vtype as a varchar(100)Next, you will load the data for the three tables.Load the accidents data. Note that @dummy is a placeholder for a column in the .csv file that you want to ignore during the load.load data local infile '…\\data\\Accidents_2016.csv'
into table accidents_2016
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 lines
(@col1, @dummy, @dummy, @dummy, @dummy, @dummy, @col2
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
)
set accident_index=@col1,accident_severity=@col2;Load the vehicle data.load data local infile '…\\data\\Vehicles_2016.csv'
into table vehicles_2016
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 lines
(@col1, @dummy, @dummy, @col2
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
)
set accident_index=@col1,vehicle_type=@col2;Load the vehicle type data.load data local infile '…\\data\\vehicle_type.csv'
into table vehicle_type
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 linesAfter the data are loaded, you will perform the analysis. First, find the average accident severity and the number of accidents for vehicles of type motorcycle. Note the performance of your query. Your query may run so slowly that MySQL aborts running completing.Improve Query PerformanceLook at the explain tool output and save the results to a graphic file.From the explain results, how many rows have to be read per join?Add an index named “accident_index” of type “index" on the accident_indexcolumn in the accidents_2016 table and another index named “accident_index” of type “index” on the vehicles_2106 table.alter table accidents_2016
add index accident_index (accident_index asc);alter table vehicles_2016
add index accident_index (accident_index asc);After adding the indices, rerun the query explanation tool and determine the number of rows to be read per join.Find the median accident severity.MySQL does not have a median function so to find the median accident severity, you will have to write a Python script.You'll need to install Python and the PyMySQL module.Install Python version 2.7 or 3.4 from www.python.org.To install the PyMySQL module, run the following command in a Windows command prompt after Python has been installed:python -m pip install --index-url=https://pypi.python.org/simple/ --trusted-host pypi.python.org PyMySQLb) Create an accident median tablecreate table accident_medians
(
vtype varchar(100),
severity int
);Run the following Python script:import pymysql
myConnection = pymysql.connect(host='localhost', user='****', passwd='****', db='accidents')
cur = myConnection.cursor()
cur.execute('SELECT vtype FROM vehicle_type WHERE vtype LIKE "%otorcycle%";')
cycleList = cur.fetchall()
selectSQL = ('''
SELECT t.vtype, a.accident_severity
FROM accidents_2016 AS a
JOIN vehicles_2016 AS v ON a.accident_index = v.Accident_Index
JOIN vehicle_type AS t ON v.Vehicle_Type = t.vcode
WHERE t.vtype LIKE %s
ORDER BY a.accident_severity;''')
insertSQL = ('''INSERT INTO accident_medians VALUES (%s, %s);''')
for cycle in cycleList:
cur.execute(selectSQL,cycle[0])
accidents = cur.fetchall()
quotient, remainder = divmod(len(accidents),2)
if remainder:
med_sev = accidents[quotient][1]
else:
med_sev = (accidents[quotient][1] + accidents[quotient+2][1])/2
print('Finding median for',cycle[0])
cur.execute(insertSQL,(cycle[0],med_sev))
myConnection.commit()
myConnection.close()Write each query you used in Steps 1 – 8 in a text file. If a query produced a result set, then list the first ten rows of each row set after the query. Bundle your lessons learned report, your queries and your query results text file, and your MySQL query explanations from both before and after adding table indexes into a single zip file and submit that zip file as your final portfolio.
Wireshark & TCP Lab
1 ObjectiveIn this lab, you will investigate the behavior of TCP by analyzing a trace of the TCP segments sent and receive ...
Wireshark & TCP Lab
1 ObjectiveIn this lab, you will investigate the behavior of TCP by analyzing a trace of the TCP segments sent and received in transferring a file from a server to a client. Specifically, you will accomplish the following: • Experiment with TCP connections; • Analyze TCP network traffic • Experiment with wireshark, traffic monitoring and filters
Similar Content
Java programming moving text, assignment help
The task is to write a program in Java that uses buttons to move a message back and forth and radio buttons to change the ...
UMES Geospatial Intelligent and Advantages of 3D Analysis Questions
1.)Discuss advantages of the 3D analysis.2.)Discuss disadvantages of the 3D Modeling3.) Identify a key Geospatial Intellig...
Refine and Finalize Website
Simple web forms can be used for order forms, a subscription to a newsletter, or a request for contact.Using the course so...
Write a Java program (non-GUI preferred) to demonstrate the use of JDBC, computer science help
Write a Java program (non-GUI preferred) to demonstrate the use of JDBC.The program should allow a user to do the fol...
Haskell Question
There are 3 haskell coding questions.The detailed requirement is in the file I uploaded.Question 1 In this question, you a...
MySQL Essays
Here are two sets of data:
Q1:
Data Set #1PERSONTop5_1Top5_2Top5_3Top5_4Top5_5PhilipSeptemberSuperstitionSuper FreakRock S...
Falling Stars
//The velocity and acceleration of the first star. var v1 = 0; var acceleration1 = //The position variables of the first s...
Value At Risk Corrected
Part 1: Creating returns variable for each series and plotting graphs gld=read.csv("C:/Users/user/Desktop/r datasets/GLD.c...
Website Description
Urban Fashions is a multinational approved fashion and design organization. It was established in 2020 in response to the ...
Related Tags
Book Guides
The Power of Habit - Why We Do What We Do in Life and Business
by Charles Duhigg
Crime and Punishment
by Fyodor Dostoyevsky
The Two Towers
by J. R. R. Tolkien
Murder on the Orient Express
by Agatha Christie
Pachinko
by Min Jin Lee
The Russian Hoax
by Gregg Jarrett
Blink
by Malcolm Gladwell
The Old Man and the Sea
by Ernest Hemmingway
Where'd You Go Bernadette
by Maria Semple
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
198 pages
Sql Tutorial
SUBDATE(date,INTERVAL expr unit) and SUBDATE(expr,days) ......... 145 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ...
Sql Tutorial
SUBDATE(date,INTERVAL expr unit) and SUBDATE(expr,days) ......... 145 EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) ........................ ...
South University Information Technology Project Management Question
Project Charter: Developing a Corporate Website
This assignment is in continuation to the project discussed in the Submiss ...
South University Information Technology Project Management Question
Project Charter: Developing a Corporate Website
This assignment is in continuation to the project discussed in the Submissions Area assignment in Week 1.
In a 2- to 3-page Microsoft Word document, create a project charter for the project for developing a corporate Website. The project charter should consist of detailed description of different aspects in all the different phases of the project.
It should include the following details:
Project objective
Manager's authority
Project deliverables
Approach of the project
2 pages
Dog Class
// this keyword refers to the variable dogSpaceNumber inside the Dog class System.out.println("My Dog has a space number o ...
Dog Class
// this keyword refers to the variable dogSpaceNumber inside the Dog class System.out.println("My Dog has a space number of " + d.dogSpaceNumber +
ITS 410 CSU Python Worksheet
Your Portfolio Project consists of two items, a lessons learned reflection report and a database design and analysis proje ...
ITS 410 CSU Python Worksheet
Your Portfolio Project consists of two items, a lessons learned reflection report and a database design and analysis project.Lessons Learned and ReflectionWrite a 2- to 3-page summary that outlines the lessons you learned in this database class. Reflect on how these lessons can be applied toward more effective database management and reporting.Database Design and AnalysisUse the Accidents_2016.csv file below to implement the following steps for your database project.Create a MySQL schema named “accidents.”Within the accidents schema, create a table named accidents_2016 with the following columns:accident_index as a varchar(13),accident_severity as an intWithin the accidents schema, create a table named vehicles_2016 with the following columns:accident_index as a varchar(13),vehicle_type as a varchar(10)Within the accidents schema, create a table named vehicle_type with the following columns:vcode int,vtype as a varchar(100)Next, you will load the data for the three tables.Load the accidents data. Note that @dummy is a placeholder for a column in the .csv file that you want to ignore during the load.load data local infile '…\\data\\Accidents_2016.csv'
into table accidents_2016
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 lines
(@col1, @dummy, @dummy, @dummy, @dummy, @dummy, @col2
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
)
set accident_index=@col1,accident_severity=@col2;Load the vehicle data.load data local infile '…\\data\\Vehicles_2016.csv'
into table vehicles_2016
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 lines
(@col1, @dummy, @dummy, @col2
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
,@dummy, @dummy, @dummy, @dummy, @dummy
)
set accident_index=@col1,vehicle_type=@col2;Load the vehicle type data.load data local infile '…\\data\\vehicle_type.csv'
into table vehicle_type
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
ignore 1 linesAfter the data are loaded, you will perform the analysis. First, find the average accident severity and the number of accidents for vehicles of type motorcycle. Note the performance of your query. Your query may run so slowly that MySQL aborts running completing.Improve Query PerformanceLook at the explain tool output and save the results to a graphic file.From the explain results, how many rows have to be read per join?Add an index named “accident_index” of type “index" on the accident_indexcolumn in the accidents_2016 table and another index named “accident_index” of type “index” on the vehicles_2106 table.alter table accidents_2016
add index accident_index (accident_index asc);alter table vehicles_2016
add index accident_index (accident_index asc);After adding the indices, rerun the query explanation tool and determine the number of rows to be read per join.Find the median accident severity.MySQL does not have a median function so to find the median accident severity, you will have to write a Python script.You'll need to install Python and the PyMySQL module.Install Python version 2.7 or 3.4 from www.python.org.To install the PyMySQL module, run the following command in a Windows command prompt after Python has been installed:python -m pip install --index-url=https://pypi.python.org/simple/ --trusted-host pypi.python.org PyMySQLb) Create an accident median tablecreate table accident_medians
(
vtype varchar(100),
severity int
);Run the following Python script:import pymysql
myConnection = pymysql.connect(host='localhost', user='****', passwd='****', db='accidents')
cur = myConnection.cursor()
cur.execute('SELECT vtype FROM vehicle_type WHERE vtype LIKE "%otorcycle%";')
cycleList = cur.fetchall()
selectSQL = ('''
SELECT t.vtype, a.accident_severity
FROM accidents_2016 AS a
JOIN vehicles_2016 AS v ON a.accident_index = v.Accident_Index
JOIN vehicle_type AS t ON v.Vehicle_Type = t.vcode
WHERE t.vtype LIKE %s
ORDER BY a.accident_severity;''')
insertSQL = ('''INSERT INTO accident_medians VALUES (%s, %s);''')
for cycle in cycleList:
cur.execute(selectSQL,cycle[0])
accidents = cur.fetchall()
quotient, remainder = divmod(len(accidents),2)
if remainder:
med_sev = accidents[quotient][1]
else:
med_sev = (accidents[quotient][1] + accidents[quotient+2][1])/2
print('Finding median for',cycle[0])
cur.execute(insertSQL,(cycle[0],med_sev))
myConnection.commit()
myConnection.close()Write each query you used in Steps 1 – 8 in a text file. If a query produced a result set, then list the first ten rows of each row set after the query. Bundle your lessons learned report, your queries and your query results text file, and your MySQL query explanations from both before and after adding table indexes into a single zip file and submit that zip file as your final portfolio.
Wireshark & TCP Lab
1 ObjectiveIn this lab, you will investigate the behavior of TCP by analyzing a trace of the TCP segments sent and receive ...
Wireshark & TCP Lab
1 ObjectiveIn this lab, you will investigate the behavior of TCP by analyzing a trace of the TCP segments sent and received in transferring a file from a server to a client. Specifically, you will accomplish the following: • Experiment with TCP connections; • Analyze TCP network traffic • Experiment with wireshark, traffic monitoring and filters
Earn money selling
your Study Documents