Yardi Systems interview question

What is normalization? What is the relation between the tables?