Ultimate access to all questions.
You are designing a data model for a healthcare application that requires lookup tables for patient information. Describe the trade-offs between using a normalized data model versus a denormalized data model for these lookup tables and explain which one you would choose and why.