Yardi Systems interview question

SQL join related queries,normalization concepts,Database and table designs for a given scenario