Yardi Systems Interview Question

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