Data Redundancy & Functional Dependency
Learn Data Redundancy & Functional Dependency (Normalization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Redundancy is the same fact stored in more than one place. A functional dependency (FD) A -> B means: if two rows have the same A they must have the same B (product_id determines product_name). Normalization is the discipline of removing redundancy that FDs reveal.