Pergunta de entrevista da empresa Yardi Systems

How can the database schema be made more effective?