Evaluate PKassignments and naming conventions
•Refine attribute atomicity
Atomic attribute: Cannotbe further subdivided
Atomicity: Characteristic of an atomic attribute
•Identify new attributesand new relationships
•Refine primary keys as required for data granularity
Granularity: Level of detail represented by the values stored in a table’s row
•Maintain historical accuracyand evaluate using derived attributes