A transport company wishes to computerize various book keeping activities associated with its operations. A transport company owns a number of trucks. The transport company has its head office located at the capital and has branch offices at several other cities. The transport company receives consignments of various sizes at (measured in cubic meters) its different offices to be forwarded to different branch offices across the country.
Once the consignment arrives at the office of the transport company, the details of the volume, destination address, sender address, etc. are entered into the computer. The computer would compute the transport charge depending upon the volume of the consignment and its destination and would issue a bill for the consignment. Once the volume of any particular destination becomes 500 cubic meters, the computerization system should automatically allot the next available truck. A truck stays with the branch office until the branch office has enough cargo to load the truck fully.
The manager should be able to view the status of different trucks at any time. The manager should be able to view truck usage over a given period of time. When a truck is available and the required consignment is available for dispatch, the computer system should print the details of the consignment number, volume, sender's name and address, and the receiver's name and address to be forwarded along with the truck. The manager of the transport company can query the status of any particular consignment and the details of volume of consignments handled to any particular destination and the corresponding revenue generated.
The manager should also be able to view the average waiting period for different consignments. This statistics is important for him since he normally orders new trucks when the average waiting period for consignments becomes high due to non-availability of trucks. Also, the manager would like to see the average idle time of the truck in the branch for a given period for future planning.
Major Entities: trucks management, offices, consignments etc.
Major functionalities: consignment details, status of the consignments, truck details etc.