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: 6
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: 7901
Registered: March 2000
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: Fri Mar 29 01:20:56 CDT 2024