Dave...you're obviously more experienced at db design than I am, but if I put showtime and showdate in the ShowArtist table, wouldn't that be duplicating the information from the Show table?
Originally posted by DaveMaxwell
I am working on the assumption that you are following the same basic design I worked up except you combined the show and events table. IF this list that shane posted is reminiscient(sp?) of the types of shows that you will be tracking, how will you track of the dates that each artist are playing in the club shows? If you don't want to keep my design (which is cool since it's your job and I can kinda see your point), then you will at the very least need to include time and date on the ShowArtist table.