question

OraLearner avatar image
OraLearner asked

What is a Parent table in Oracle ?

I'm confused for this simple question. I heard that a table which consist of atleast one primary or Unique key is called as Parent Table. Is it the right definition ? Thank you

oracletabletheory
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

You're not a parent unless you have kids, right?

So your definition would probably be expanded to detail how the unique field is referenced by a 'CHILD' table as an identifying record via a Foreign Key.

Uniqueness in a table doesn't necessarily guarantee normalization of the data throughout the database...

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for the asnwer.
0 Likes 0 ·
KillerDBA avatar image
KillerDBA answered

This isn't an Oracle-specific question. You probably want to look at a book on relational database design.

Here's a very brief primer:

Relational Database Model on Database Journal

And HillbillyToad is right, a unique key isn't what identifies a parent table, it's the relatiohship to another table (or, come to think of it, itself).

3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

i keep asking myself why I continue to answer these questions. I suppose it's fun to see how many i can sound somewhat intelligent on!
0 Likes 0 ·
You're doing well in that regard. :-)
0 Likes 0 ·
Thanks for providing the link.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.