Camel Banana Case Study | Dataford Interview Questions

Solve the Camel Banana problem and then walk me through how you would approach the follow-up case study.

Use the supplied tables to calculate the bananas remaining after every transport stage for problem 1. Assume each camel consumes one banana per kilometer, and every forward or return trip consumes bananas for each camel currently traveling.

Output

One row per transport stage for problem 1
Columns: stage_no, start_bananas, required_trips, bananas_consumed, ending_bananas
Sort by stage_no ascending

Schema

camel_banana_parameters

Column	Type	Description
problem_idPK	INT	Identifier for a Camel Banana problem instance
initial_bananas	INT	Initial number of bananas
camel_capacity	INT	Maximum bananas carried by one camel
consumption_per_km	INT	Bananas consumed by one camel per kilometer
target_distance_km	INT	Total intended travel distance

route_stages

Column	Type	Description
stage_idPK	INT	Unique route stage identifier
problem_id	INT	Related Camel Banana problem
stage_no	INT	Sequential stage number
distance_km	INT	Distance covered in the stage
bananas_at_start	INT	Bananas available at the start of the stage

Your question is Camel Banana Case Study. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem