$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\mathrm{.}1$ Define an Abstract Data Type $($ADT$)$ called Dep$\_$ADT and include in it the following fields: $(1$ point$)$

Attribute Data Type

Name VARCHAR$(20)$

DOB DATE

Relationship VARCHAR$(20)$

$1\mathrm{.}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\mathrm{.}2$ Create the Emp table and include in it the following attributes $($the underlined attribute refers to the primary key$)$: $(1$ point$)$

Attribute Data Type

EmpID NUMBER

Name VARCHAR$(20)$

Dependents Dependents$\_$VA

$1\mathrm{.}3$ Insert, in the table Emp, the following employees and their dependents: $(2$ points$)$

Employee Details Dependents Details

EmpID$=0517001$

Name$=$ Andy Mirza Name$=$Ron

DOB$=01-$JAN$-92$

Relationship$=$Son

EmpID$=0517002$

Name$=$ Tim Anderson Name$=$Nancy

DOB$=22-$MAY$-86$

Relationship$=$Daughter

Name$=$Rob

DOB$=11-$NOV$-99$

Relationship$=$Son

EmpID$=0517003$

Name$=$ Rob Dickson Name$=$Mary

DOB$=11-$JUN$-99$

Relationship$=$Daughter

Name$=$Alex

DOB$=11-$OCT$-95$

Relationship$=$Son

EmpID$=0517004$

Name$=$ Mike Reagan Name$=$Alfred

DOB$=14-$MAY$-80$

Relationship$=$Son

Name$=$Jane

DOB$=09-$DEC$-85$

Relationship$=$Daughter

Name$=$Timothy

DOB$=19-$MAR$-93$

Relationship$=$Daughter