Question d’entretien chez Melaleuca

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