Re: Database Design - how to design table
Posted by: James Gordon
Date: January 03, 2007 09:14AM

When you decide on a primary key you have to work out which columns make you unique.

In your example I would suggest Name, Event and Year?

I often create a surrogate primary key of a number that auto increments and then create a unique key on the above columns.

Options: ReplyQuote


Subject
Written By
Posted
Re: Database Design - how to design table
January 03, 2007 09:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.