denormalized tables and enhanced coding accordingly