Redundancy in Nested Schemes

• The redundancy definition is the same as for flat relations.

• If a value change causes a constraint violation, the value is redundant.

NrBeds (RoomNr (View)* )*

2 1 Sea

Forest

City

2 Sea

Forest

3 City

View (RoomNr NrBeds)*

Sea 1 2

2 2

Forest 1 2

2 2

City 1 2

3 2

Previous slide

Next slide

Back to first slide

View graphic version