I did not create any SQL trigger or procedure before. What I need is that I have 6 tables as: 1- Parent1 [Employee]: EmpID (PK), EmpName ...etc. 2- Child1 [EmpCourse]: EmpID (FK), CourseName, ...etc 3- Child2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.
CopyofParent1 columns is superset of Parent1 columns. Similarly for CopyofChild1 and CopyofChild2.
As soon as a record in Parent1 is inserted and meets a certain criterion, the record shd be inserted in CopyofParent1 using EmpID . At this time, records from Child1 and Child2 for the same Parent shd be inserted in CopyofChild1 and CopyofChild2 resp.