Cardinal Health Interview Question

Given some scenarios, design a database