3. MNO Incorporated Communications Network
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.
[See data/solutions files]
|