   database design
  Here is the situation ive been making a database for night life.I have a table venue which has information about a venue such a nightclub.I then have a table event which represents an event.The problem is an event can be frequent e.g. every tuesday its jazz night at lizard lounge. But events can also be unique e.g. John Lennon is playing on 21/06/06. Their both events and they may clash obivously the unique event should overwrite the default event.But the database has to link the event to the venue. Ive come up with some solutions but none feel correct. I was wondering if there was a standard way to deal with problems like this.One other thing to bear in mind is that an event has a sort of forum where people can post on. But the messages are only attached to a paticular night. E.g. jazz night is every tuesday so if some write's a message today it will be associatioed with the 27th of june 2006. Afterwards it can be deleted!any help whats so ever would be greatly appreciated. Thanks in advanceIain Fraser   
  google/wikipedia: "database NORMALIZATION"