Following the success of Chin & Beard Suds Co, we’ve been informed by our distribution company that they’re having some technical difficulties, so we’d like to step in and offer our professional assistance.
The Scenario
A shipping distribution company transports valuable cargo for customers all around the world using three different types of boat. They keep the basic details for each departure in a table called Departure Details.
 |
| A snippet of the Departure Details table. |
They sell and allocate space on their departures based on the weight and volume of the cargo. They keep the details of each allocation in a table called Allocation Details.
 |
| A snippet of the Allocation Details table. |
In the last 3 months they’ve begun noticing issues where more weight or volume is being allocated than the boats can actually carry. This means customers are turning up at the port with cargo which the company is then having to turn away and refund. They want to identify and flag departures with weight or volume allocation issues before the day of departure.
The Requirements
- Download the input file.
- Figure out how much weight and volume has been allocated for each departure in the Allocation Details table.
- Find a way to flag departures on the Departure Details table which have had too much cargo weight or volume allocated.
The Output
- One table designed to replace the original Departure Details table.
- 8 fields total (4 original & 4 new).
- 58 rows.
- Two new fields called [Allocated Weight] & [Allocated Volume] which contain the allocated weight and volume for each departure.
- Two more new fields called [Overweight?] & [Overvolume?] which contain TRUE or FALSE depending on if there’s an issue.
For comparison, here's
our output file. Don't to forget to fill in
our participation tracker!
