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
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...
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:
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).
No one has followed this question yet.