Database Design

Specifications, Macro Micro data

What is design. Purpose of database. Clarity in requirements. Identify macro,micro data

Data sample, relationships

Create data sample. Identify data type and size. Relationship between data.Identify Unique data

Referential Integrity, Constraints

Primary and foreign key. Referential integrity. Remove duplication. Apply constraints

Join, Normalization, Traceability

Join principles. Normalization. Data growth. Data retention, archiving. Denormalization,Database Traceability