|< < 16 > >|

Functional Dependencies

The BadAlbum schema was improved by decomposition

• First decomposition: BadAlbum decomposed to Artist and LessBadAlbum.
  Artist = project(BadAlbum, [artist, artist_website]) LessBadAlbum = project(BadAlbum, [artist, title, year, label, label_website]) BadAlbum = join(LessBadAlbum, Artist)
  
  
• Second decomposition: LessBadAlbum decomposed to Album and Label.
  Album = project(LessBadAlbum(artist, title, year, label) Label = project(LessBadAlbum(label, label_website) LessBadAlbum = join(Album, Label)

|< < 16 > >|