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"

Report message to a moderator

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.

Report message to a moderator

Previous Topic: db design problem
Next Topic: Batch data type changing. Please Help!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 16 05:34:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.