before database normalized