Fourth Normal Form Criteria: not 2 multi-valued dependencies - PowerPoint PPT Presentation

Introduction Good Relational Design Normalization Fourth Normal Form Criteria: not ≥ 2 multi-valued dependencies Consider: Customer ( name , address , loan number ) Relational Database Design

Introduction Good Relational Design Normalization Fourth Normal Form Criteria: not ≥ 2 multi-valued dependencies Consider: Customer ( name , address , loan number ) Primary key? Relational Database Design

Introduction Good Relational Design Normalization Fourth Normal Form Criteria: not ≥ 2 multi-valued dependencies Consider: Customer ( name , address , loan number ) Primary key? Multi-valued dependencyies name ։ address name ։ loan number Relational Database Design

Introduction Good Relational Design Normalization Fourth Normal Form Criteria: not ≥ 2 multi-valued dependencies Consider: Customer ( name , address , loan number ) Primary key? Multi-valued dependencyies name ։ address name ։ loan number Solution: separate into two relations Relational Database Design

Introduction Good Relational Design Normalization Fourth Normal Form Another example: Pizaa Delivery ( Restaurant , Pizza Variety , Delivery Area ) Relational Database Design

Introduction Good Relational Design Normalization Fourth Normal Form Another example: Pizaa Delivery ( Restaurant , Pizza Variety , Delivery Area ) Relational Database Design