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 employeesand their dependents using a Varray. To answer this question, do thefollowing steps: 1.1 Define an Abstract Data Type (ADT) called Dep ADTand include in it the following fields: (1 point) 1.1 Use theCREATE TYPE command to create a Varray called Dependents VA of DepADT and set the size to 5 . (1 point) 1.2 Createthe Emp table and include in it the following attributes (the underlined

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!