Database - Design

Database design is one of the key areas in product design. This session is useful for all analysts.

Data sample, relationships. Create data sample. Identify data type and size. Relationship between data. Identify unique data

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

Referential Integrity, Constraints. Primary and foreign key. Referential integrity. Remove duplication. Apply constraints

Specifications, Macro Micro data. What is design. Purpose of database. Clarity in requirements. Identify macro, micro level data