I am creating a database for a mining company. There are trucks carrying materials from one place to another. In the database there is the table Trips with the following fields:
Record_ID
Date_ID
Time_ID
Truck_ID
Trip_Count
Each time a truck loads materials a record is created specyfying the...