CIBC interview question

Again, scenario of a schema for which I needed to design the whole schema.?