|< < 16 > >|

Natural Join

  • Combines two relations.
  • Connects rows via references.

Example — Schema

Artist(artist_id, name, website) Album(album_id, artist_id, title, year, label_id) Track(album_id, track, title, length)

Primary keys

Primary keys are underlined.

  • Artist: artist_id
  • Album: album_id
  • Track: album_id, track

Foreign keys

  • Album(artist_id)Artist(artist_id)
  • Track(album_id)Album(album_id)

|< < 16 > >|