Managing Child-to-Parent (Reverse) Relationship Instead of Parent-to-Child During Execution of a Transaction in Oracle
Source: IOSR Journal of Engineering
Most of the computer professionals, academicians and students know the traditional way of handling one too many relationship using parent and child table. Whenever, there is a one-to-many relationship in a database, the authors used to define a primary or composite key in the parent table and it is referred as a foreign key in child table. These primary and foreign key constraints are defined at the time of creation of parent and child tables. Once the tables are created successfully with the specific constraints; they insert the record in a parent table and then the related record is entered into child table. If they try to enter child table first, then database software gives an error of violation of referential integrity rule.