identifying what the business needs to track, classifying attributes (simple, composite, derived, multi-valued), defining domains, and choosing primary keys.