View the step-by-step solution to:

MNO Incorporated Communications Network Calculating Bandwidth MNO Incorporated is considering acquiring its own leased lines to handle voice and data...

MNO Incorporated Communications Network
Calculating Bandwidth
MNO Incorporated is considering acquiring its own leased lines to handle voice and data communications between its 14 distribution sites in three regions around the country. The peak load of communications for each site is expected to be a function of the number of phone links and the number of computers at that site. Communications data are available below.You have been asked to analyze this information.
a. Create a database table with an appropriate structure to store the data above. Site Location can serve as the primary key for this table. Enter the records shown above and get a printed listing of your table.
b. Survey results suggest that the peak traffic to and from a site will be approximately 2 kilobits per second for each phone line plus 10 kilobits per second for each computer. Create a report showing the estimated peak demand for the telecommunications system at each site in kilobits. Create a second report grouped by region and showing regional subtotals and a total for the system as a whole.

MNO Incorporated Communications Network Calculating Bandwidth MNO Incorporated is considering acquiring its own leased lines to handle voice and data communications between its 14 distribution sites in three regions around the country. The peak load of communications for each site is expected to be a function of the number of phone links and the number of computers at that site. Communications data are available below.You have been asked to analyze this information. a. Create a database table with an appropriate structure to store the data above. Site Location can serve as the primary key for this table. Enter the records shown above and get a printed listing of your table. b. Survey results suggest that the peak traffic to and from a site will be approximately 2 kilobits per second for each phone line plus 10 kilobits per second for each computer. Create a report showing the estimated peak demand for the telecommunications system at each site in kilobits. Create a second report grouped by region and showing regional subtotals and a total for the system as a whole. Site Location Region Phone Lines Computers Boston East 228 95 New York East 468 205 Richmond East 189 84 Atlanta East 192 88 Detroit East 243 97 Cincinnati East 156 62 New Orleans Central 217 58 Chicago Central 383 160 Saint Louis Central 212 91 Houston Central 238 88 Denver West 202 77 Los Angeles West 364 132 San Francisco West 222 101 Seatle West 144 54
Background image of page 1
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question