Very nice explanation! > The correct way to do this is to normalize the table This is true for transactional dbs, but in data warehouses it's widely accepted

Very nice explanation! > The correct way to do this is to normalize the table This is true for transactional dbs, but in data warehouses it's widely accepted that some degree of denormalization is the way to go