Question
MNO Incorporated is considering acquiring its own leased lines to handle voice and data communications between its fourteen distribution sites in three regions around country. The summit load of communications for each site is expected to be a function of 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. produce a database table with an appropriate structure to store data above. Site Location can serve as the primary key for this table. Enter records shown above and get a printed listing of your table.
b. Survey results suggest that 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. Produce a report showing estimated peak demand for the telecommunications system at each site in kilobits. Produce a second report grouped by region and showing regional subtotals and total for system as a whole.