Question

Delivery trucks enter and leave a depot through a controlled gate. At the depot, each truck is loaded with packages, which will then be delivered to one or more customers. As each truck enters and leaves the depot, the following information is recorded and uploaded to a database.
The truck's identification number
The truck's weight
The date and time the truck passes through the gate
Whether the truck entering or leaving the depot Using only the information in the database, which of the following questions CANNOT be answered?
1) On which day in a particular range of dates did the greatest number of trucks enter and leave the depot?
2) What is the average number of customer deliveries made by each truck on a particular day?
3) What is the change in weight of a particular truck between when it entered and left the depot?
4) Which truck has the shortest average time spent at the depot on a particular day?

Answer 1

The question that cannot be answered based on the information in the delivery truck data base is 2) What is the average number of customer deliveries made by each truck on a particular day?

Why can this question not be answered?

In order to answer this question, the number of customers that each truck delivered to during the day needs to be recorded.

The total number of deliveries will then be added up and divided by the number of trucks making deliveries.

The information on the number of deliveries made is not in the database so this question cannot be answered.

In conclusion, option 2 is correct.

Find out more on databases at brainly.com/question/518894.