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

▶

fourth normal form

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

Oct 05, 2023 332 likes •409 views

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

slide-1

SLIDE 1

Introduction Good Relational Design Normalization

Fourth Normal Form

Criteria: not ≥ 2 multi-valued dependencies Consider: Customer(name, address, loan number)

Relational Database Design

slide-2

SLIDE 2

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

slide-3

SLIDE 3

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

slide-4

SLIDE 4

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

slide-5

SLIDE 5

Introduction Good Relational Design Normalization

Fourth Normal Form

Another example: Pizaa Delivery(Restaurant, Pizza Variety, Delivery Area)

Relational Database Design

slide-6

SLIDE 6

Introduction Good Relational Design Normalization

Fourth Normal Form

Another example: Pizaa Delivery(Restaurant, Pizza Variety, Delivery Area)

Relational Database Design