Home » Developer & Programmer » Designer » Primary keys in child tables (Oracle 10.2.0.3)
Primary keys in child tables [message #312637] Wed, 09 April 2008 08:57 Go to next message
martin41339
Messages: 1
Registered: April 2008
Location: London, UK
Junior Member
Can you give me your thoughts on the following proposition: "A primary key on a child table is superfluous"
Re: Primary keys in child tables [message #312764 is a reply to message #312637 ] Wed, 09 April 2008 13:29 Go to previous message
Frank
Messages: 5230
Registered: April 2002
Location: NL
Senior Member
Nonsense.
In a relational database, each and every tuple needs a unique identifier.

Just my opinion; no idea if it's backed by any theory.
Previous Topic:db design problem
Next Topic:Batch data type changing. Please Help!
Goto Forum:
  


Current Time: Sat May 17 00:22:12 CDT 2008

Total time taken to generate the page: 0.04001 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.