HARMAN interview question

SQL, Joins, Data warehouse, normalisation,denormalisation