Description
Users want bandwidth and will use as much as offered to them.
Compare video, voice, and data formats. Identify at least three bandwidth techniques and how you would manage them with either UDP or TCP protocols.
Consider both wired and wireless networks. Do not limit yourself to the TCP/IP protocol.
Write a 2- to 3-page paper. Include at least two references.
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
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!
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
programming logic
Assignment 2: Fran’s Virtual Fruit Stand, Part 2Due Week 9 and worth 190 pointsUse the concepts and scenario from Assign ...
programming logic
Assignment 2: Fran’s Virtual Fruit Stand, Part 2Due Week 9 and worth 190 pointsUse the concepts and scenario from Assignment 1 to help Fran’s Virtual Fruit Stand increase the functionality of its online shopping cart. When a customer checks out, the shopping cart must store the required data pertaining to each item the customer is buying. Your job is to design a program that will prompt the user for the required data and then store it. The required data includes the item name, the price per pound, and the number of pounds of that item being purchased. When complete, your program should include three (3) arrays, two (2) loops, one (1) and / or conditional statement, and one (1) variable.Using Visual Logic, design a flowchart that is also a fully functional program to add functionality to the online shopping cart. According to your design, the program must:Continually accept data regarding the purchase of fruit as specified below until the user enters a sentinel value, or until five (5) items are entered, whichever comes first.Prompt the user for each item and accept the name of the fruit (e.g., “dried apples”), the price per pound, and the number of pounds sold in a month.Store the required data in three (3) arrays (e.g., one (1) for the item name, one (1) for the price per pound, and one (1) for the number of pounds being purchased) with corresponding index values. Note: For example, index value 3, when applied to the “itemName” array, would give us the name of the third item that the customer is buying. That same index value of 3, when applied to the “pricePerPound” array, would give us the price per pound of that same third item that the customer is buying.Store up to five (5) values in each of the three (3) arrays.Provide functionality in which the user ends the program by typing a sentinel value, and the program tells the user what the sentinel value is. Note: An acceptable message may read “Type n to end the program.”, where “n” is the sentinel value. If the user does not end the program in this way, then the program ends when it has collected the data for five (5) items.Print an itemized receipt with the following data after the last item in the purchase has been saved to the array.Item namePrice per pound of each itemNumber of pounds purchased of each itemSubtotal price for each item, calculated as price per pound multiplied by the number of poundsTotal weight of the entire order (in pounds)The cost of shipping which is based on the total weight of the entire order, calculated as 50 cents per pound. Note: For example, if the entire order weighs seven (7) pounds, the cost of shipping would be $3.50.Grand total price of all items and shipping.Note: Use the “console” option in the output command to accomplish this task. An example of an acceptable output has been provided below:Week 9 Assignment 2 Table
CS 499 Southern New Hampshire University Zookeeper Application Java Program
I'm having some trouble enhancing a current project: the current program runs in the terminal of the IDE but I want to enh ...
CS 499 Southern New Hampshire University Zookeeper Application Java Program
I'm having some trouble enhancing a current project: the current program runs in the terminal of the IDE but I want to enhance it to use GUIs where each prompt question will have clickable buttons that will take the user to the next questions. The program is a zookeeper application that allows the user to monitor an animal or habitat. I want when the program runs a GUI (pop-up window) comes up with the first question "what would you like to monitor?" then have buttons to click for either animal or habitat and the same for the everything else. This is a link the google drive with the current source code and all files to my project. https://drive.google.com/drive/folders/15x8JJe7XQK...
CS5810 Royal Holloway Matlab Programming Question
This coursework will test some concepts of Matlab programming for data analysis, including writing scripts,
function, plo ...
CS5810 Royal Holloway Matlab Programming Question
This coursework will test some concepts of Matlab programming for data analysis, including writing scripts,
function, plotting, manipulating strings and using cell arrays and structure variables.
William Rainey Harper College C++ Coding Question
This assignment will simulate a guessing game. Imagine two people are bored in the car driving on a road trip. Create a pr ...
William Rainey Harper College C++ Coding Question
This assignment will simulate a guessing game. Imagine two people are bored in the car driving on a road trip. Create a program that uses the following steps.First person thinks of a number. Ask the user to input a number.First person then asks the second person the guess the number - ask the user to guess the number.If the number matches, print the output X is correct! and exit the programIf the number doesn't match, print Wrong on a line by istelf, then go back to step 2 and continue asking for the number until the correct answer is given.
Database Design and Analysis. Use 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 foll ...
Database Design and Analysis. Use 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.
Similar Content
Cornell University Social Media Metrics & Analytics Questions
MKT365
End-of-Course Assessment – July Semester 2021
Social Media Metrics & Analytics
_________________________________...
HTML project
Hi,Maximum image upload size should be less than 2MBImages that are getting inserted in the editor should be of max 500 x ...
ENGR 133 Montgomery College Rockville Calculus with MATLAB Exercises
ENGR 133 Calculus with MATLAB
Lab 06
Numerical Methods
LEARNING OBJECTIVES:
At the completion of this lab, you should be ...
Community College of Baltimore County Create a Java Code Computer Coding Task
3.5377 4.8339 0.74115 3.8622 3.3188 1.6923 2.5664 3.3426 6.5784 5.7694 1.6501
6.0349 3.7254 2.9369 3.7147 2.795 2.8759...
Virginia State University Encrypt and Decrypt Message Worksheet
This assignment is already a week late. Many tutors cancelled on me last week so please view the worksheet before you offe...
Convert the following Java/C-like code into ARM assembly.
Convert the following Java/C-like code into ARM assembly. The names of the variables reflect which registers must be used ...
Casefavsklz Au Revised
E-commerce Strategy Case Study: Favi Entertainment and SKLZ Businesses 1. What lessons about developing the proper e-comme...
Computer Literacy In Accounting
Basic computer skills are among the vital skills that have become relevant in the accounting profession. In modern society...
Itmg481 Assignment
Technological convergence is a trend where many technologies integrate to form a new feature. An example is a laptop or a ...
Related Tags
Book Guides
Notes from Underground
by Fyodor Dostoyevsky
Cant Hurt Me - Master Your Mind and Defy the Odds
by David Goggins
Where'd You Go Bernadette
by Maria Semple
The Glass Palace
by Amitav Ghosh
The Chosen
by Chaim Potok
The Remains Of The Day
by Kazuo Ishiguro
Too Much and Never Enough
by Mary L. Trump
Faust
by Johann Wolfgang von Goethe
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
programming logic
Assignment 2: Fran’s Virtual Fruit Stand, Part 2Due Week 9 and worth 190 pointsUse the concepts and scenario from Assign ...
programming logic
Assignment 2: Fran’s Virtual Fruit Stand, Part 2Due Week 9 and worth 190 pointsUse the concepts and scenario from Assignment 1 to help Fran’s Virtual Fruit Stand increase the functionality of its online shopping cart. When a customer checks out, the shopping cart must store the required data pertaining to each item the customer is buying. Your job is to design a program that will prompt the user for the required data and then store it. The required data includes the item name, the price per pound, and the number of pounds of that item being purchased. When complete, your program should include three (3) arrays, two (2) loops, one (1) and / or conditional statement, and one (1) variable.Using Visual Logic, design a flowchart that is also a fully functional program to add functionality to the online shopping cart. According to your design, the program must:Continually accept data regarding the purchase of fruit as specified below until the user enters a sentinel value, or until five (5) items are entered, whichever comes first.Prompt the user for each item and accept the name of the fruit (e.g., “dried apples”), the price per pound, and the number of pounds sold in a month.Store the required data in three (3) arrays (e.g., one (1) for the item name, one (1) for the price per pound, and one (1) for the number of pounds being purchased) with corresponding index values. Note: For example, index value 3, when applied to the “itemName” array, would give us the name of the third item that the customer is buying. That same index value of 3, when applied to the “pricePerPound” array, would give us the price per pound of that same third item that the customer is buying.Store up to five (5) values in each of the three (3) arrays.Provide functionality in which the user ends the program by typing a sentinel value, and the program tells the user what the sentinel value is. Note: An acceptable message may read “Type n to end the program.”, where “n” is the sentinel value. If the user does not end the program in this way, then the program ends when it has collected the data for five (5) items.Print an itemized receipt with the following data after the last item in the purchase has been saved to the array.Item namePrice per pound of each itemNumber of pounds purchased of each itemSubtotal price for each item, calculated as price per pound multiplied by the number of poundsTotal weight of the entire order (in pounds)The cost of shipping which is based on the total weight of the entire order, calculated as 50 cents per pound. Note: For example, if the entire order weighs seven (7) pounds, the cost of shipping would be $3.50.Grand total price of all items and shipping.Note: Use the “console” option in the output command to accomplish this task. An example of an acceptable output has been provided below:Week 9 Assignment 2 Table
CS 499 Southern New Hampshire University Zookeeper Application Java Program
I'm having some trouble enhancing a current project: the current program runs in the terminal of the IDE but I want to enh ...
CS 499 Southern New Hampshire University Zookeeper Application Java Program
I'm having some trouble enhancing a current project: the current program runs in the terminal of the IDE but I want to enhance it to use GUIs where each prompt question will have clickable buttons that will take the user to the next questions. The program is a zookeeper application that allows the user to monitor an animal or habitat. I want when the program runs a GUI (pop-up window) comes up with the first question "what would you like to monitor?" then have buttons to click for either animal or habitat and the same for the everything else. This is a link the google drive with the current source code and all files to my project. https://drive.google.com/drive/folders/15x8JJe7XQK...
CS5810 Royal Holloway Matlab Programming Question
This coursework will test some concepts of Matlab programming for data analysis, including writing scripts,
function, plo ...
CS5810 Royal Holloway Matlab Programming Question
This coursework will test some concepts of Matlab programming for data analysis, including writing scripts,
function, plotting, manipulating strings and using cell arrays and structure variables.
William Rainey Harper College C++ Coding Question
This assignment will simulate a guessing game. Imagine two people are bored in the car driving on a road trip. Create a pr ...
William Rainey Harper College C++ Coding Question
This assignment will simulate a guessing game. Imagine two people are bored in the car driving on a road trip. Create a program that uses the following steps.First person thinks of a number. Ask the user to input a number.First person then asks the second person the guess the number - ask the user to guess the number.If the number matches, print the output X is correct! and exit the programIf the number doesn't match, print Wrong on a line by istelf, then go back to step 2 and continue asking for the number until the correct answer is given.
Database Design and Analysis. Use 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 foll ...
Database Design and Analysis. Use 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.
Earn money selling
your Study Documents