So i have an assignment that requires me to program and create freight Id and update the status for every new order.
Freight ID: This should be a unique number auto generated using the following simple algorithm.
• Use the numbers '1939' as the first freight Id. Increment it by 1 for the next freight.
Freight status: can be one of the codes: ‘D’,’P’, or ‘W’. “D”: Delivered to the destination “P”: Processing “W”: Waiting at the ware house to be delivered.
When a new freight order is created, its initial status should be recorded as ‘W’.