Database Design - how to design table
Hey guys,
I want to create a table that will have duplicate entries, the primary key is the name of a person, but that person may take part in many events so will appear more than once in the table. how should i desin this.
example:
Name Event score year
Jay soccer 4 2005
jay swimming 1 2005
But when i do it like this i get error for duplicate entry please advise on how to design around this properly.
Subject
Written By
Posted
Database Design - how to design table
January 03, 2007 09:04AM
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.