|< < 4 > >|

A schema with problems

BadAlbum table

  • "Bad" refers to the schema, not the albums.
  • (Not quite the same schema as this one)
BadAlbum(artist, artist_website, title, year, label, label_website)

Sample data

artist artist_website title year label label_website
Elvis Costelloelviscostello.comMy Aim Is True1977Stiffstiff-records.com
Elvis Costelloelviscostello.comThis Year's Model1978RadarNULL
Elvis Costelloelviscostello.comArmed Forces1979RadarNULL
Elvis Costelloelviscostello.comGet Happy!!1980Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comTrust1981Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comAlmost Blue1981F-BeatNULL
Elvis Costelloelviscostello.comImperial Bedroom1982Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comImperial Bedroom1982Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comPunch the Clock1983Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comGoodbye Cruel World1984Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comKing of America1986Columbiacolumbiarecords.com
Elvis Costelloelviscostello.comBlood and Chocolate1986Columbiacolumbiarecords.com
The Detroit Cobrasthedetroitcobras.comMink Rat or Rabbit1998Sympathy for the Record Industrysympathyrecords.com
The Detroit Cobrasthedetroitcobras.comLife, Love and Leaving2001Sympathy for the Record Industrysympathyrecords.com
The Detroit Cobrasthedetroitcobras.comSeven Easy Pieces2003Rough Traderoughtraderecords.com
The Detroit Cobrasthedetroitcobras.comBaby2004Rough Traderoughtraderecords.com
The Detroit Cobrasthedetroitcobras.comTied & True2007Bloodshotbloodshotrecords.com
The Detroit Cobrasthedetroitcobras.comThe Original Recordings2008Munster Recordsmunster-records.com

|< < 4 > >|