MNO Incorporated Communications Network
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.
Recently Asked Questions
- could you please post full coding for relative and absolute address homework 4 extra credit 2
- An educational researcher wants to estimate the mean amount of money spent on books (per semester) for her university. The researcher chooses a random sample
- Trace the development of the British-American conflict up to 1776. Could the relationship have been saved?