Melaleuca interview question

How would you design and query a database for this case study?