QubeHealth interview question

was asked to design a SQL database for a mentioned scenario.