ShowingTime.com interview question

gave one case and asked to design the oracle db tables. Use Java to do some coding to handle one complex case.