Designing Databases
Conceptual (logical) design: abstract model from business perspective
Physical design: How database is arranged on direct-access storage devices
Design process identifies
Relationships among data elements, redundant database elements
Most efficient way to group data elements to meet business requirements, needs of application programs
Normalization
Streamlining complex groupings of data to minimize redundant data elements and awkward many-to-many relationships