Question: 1) This question is about implementing a 1-to-many relationship between employees and their dependents using a Varray. To answer this question, do the following steps:







1) This question is about implementing a 1-to-many relationship between employees and their dependents using a Varray. To answer this question, do the following steps: 1.1 Define an Abstract Data Type (ADT) called Dep ADT and include in it the following fields: (1 point) 1.1 Use the CREATE TYPE command to create a Varray called Dependents VA of Dep ADT and set the size to 5 . (1 point) 1.2 Create the Emp table and include in it the following attributes (the underlined attribute refers to the primary key): (1 point) 1.3 Insert, in the table Emp, the following employees and their dependents: (2 points) \begin{tabular}{|l|l|} \hline & \begin{tabular}{l} Relationship=Daughter \\ Name=Alex \\ DOB=11-OCT-95 \\ Relationship=Son \end{tabular} \\ \hline EmplD=0517004 & Name=Alfred \\ Name= Mike Reagan & DOB=14-MAY-80 \\ Relationship=Son \\ Name=Jane \\ & DOB=09-DEC-85 \\ & Relationship=Daughter \\ & Name=Timothy \\ & DOB=19-MAR-93 \\ & Relationship=Daughter \\ \hline \end{tabular} 1.4 Write a query to show the employee name, his/her dependent name, date of birth and relationship but only for those dependents whose names do not start with the letter A. That is, the query should display the following output: (2 points) 1.5 Write an anonymous block to display the following content which is for the employee whose id is 517004: (2 points) Employee ID:517004 Employee Name:Mike Reagan Name = Alfred DOB =14MAY80 Relationship=Son Name=Jane DOB =09DEC85 Relationship=Daughter Name=Timothy DOB=19-MAR-93 Relationship=Daughter 1.6 This question requires the COMPANY schema. Write a statistical query that can infer the salary of a newly hired employee in department 1 assuming that all you know about him is that his salary is above the average salary of department 4 employees by 20%. If your solution is right, the salary should be 37200 . (2 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
