|< < 8 > >|

Fixing a bad schema

Connection between the old and new schemas

project(BadAlbum, [artist, artist_website]) → Artist project(BadAlbum, [artist, title, year, label, label_website]) → LessBadAlbum BadAlbum == join(LessBadAlbum, Artist)

  • We have decomposed BadAlbum to Artist and LessBadAlbum.

  • The decomposition is done using a join which is lossless: Table = join of projections

|< < 8 > >|