Database Table Structures$-$ Database Name $-$ KeyToneIncEmployee Field NameData TypeKeyfnametext$(15)$MinittextLnametext$(15)$ssntext$(9)$PrimaryBdatedateAddresstext$(30)$Sextext$,$SalaryNumber $-$ decimal$(10,2)$Super$\_$ssntext$(9)$Foreign $($Ssn in Employee$)$DnoNumber Foreign $($Dnumber in Department$)$DepartmentField NameData TypeKeyDnametext$(15)$DnumberNumberPrimaryMgr$\_$ssntext$(9)$Foreign $($Ssn in Employee$)$Mgr$\_$start$\_$date dateDept$\_$LocationsField NameData TypeConstraintKeyDnumberNumbernot nullprimary,foreign $($Dnumber in Department$)$Dlocationtext$(15)$not nullprimaryProjectField NameData TypeKeyPnametext$(15)$PnumberNumberPrimaryPlocationtext$(15),$DnumNumberForeign $($Dnumber in Department$)$Works$\_$OnField NameData TypeKeyEssntext$(9)$Primary$,$ Foreign $($Ssn in Employee$)$PnoNumberPrimary$,$ Foreign $($Pnumber in Project$)$HoursNumber decimal$(3,1)$DependentField NameData TypeKeyEssntext$(9)$PrimaryDependent$\_$nametext$(15)$PrimarySextextBdatedateRelationshiptext$(8)$Create appropriate relations among tables,The Tables' DataEmployeeFnameMinitLnameSsnBdateAddressSexSalarySuper$\_$ssnDnoJohnBSmith$1234567891965-01-09731$ Fondren, Houston, TXM$30000\mathrm{.}003334455555$FranklinTWong$3334455551955-12-08638$ Voss, Houston, TXM$40000\mathrm{.}008886655555$JoyceAEnglish$4534534531972-07-315631$ Rice, Houston, TXF$25000\mathrm{.}003334455555$RameshKNaranyan$6668844441962-09-20975$ Fire Oak, Humble, TXM$38000\mathrm{.}003334455555$JamesEBorg$8886655551937-11-10450$ Stone, Houston, TXM$55000\mathrm{.}00$NULL$1$JenniferSWallace$9876543211941-06-20291$ Berry, Bellaire, TXF$43000\mathrm{.}008886655554$AhmadVJabbar$9879879871969-03-29980$ Dallas, Houston, TXM$25000\mathrm{.}009876543214$AliciaJZelaya$9998877771968-01-193321$ Castle, Spring, TXF$25000\mathrm{.}009876543214$DepartmentDnameDnumberMgr$\_$ssnMgr$\_$start$\_$dateHeadquarters$18886655551981-06-19$Administration$49876543211995-01-01$Research$53334455551988-05-22$Dept$\_$LocationsDnumberDlocation$1$Houston$4$Stafford$5$Bellaire$5$Houston$5$SugarlandProjectPnamePnumberPlocationDnumProductX$1$Bellaire$5$ProductY$2$Sugarland$5$ProductZ$3$Houston$5$Computerization$10$Stafford$4$Reorganization$20$Houston$1$Newbenefits$30$Stafford$4$DependentEssnDependent$\_$nameSexBdateRelationship$123456789$AliceF$1988-12-30$Daughter$123456789$ElizabethF$1967-05-05$Spouse$123456789$JohnM$2000-01-01$Son$123456789$MichaelM$1988-01-04$Son$333445555$AliceF$1986-04-05$Daughter$333445555$JoytF$1958-05-03$Spouse$333445555$TheodoreM$1983-10-25$Son$987654321$AbnerM$1942-02-28$SpouseWorks$\_$OnEssnPnoHours$123456789132\mathrm{.}512345678927\mathrm{.}5333445555210\mathrm{.}0333445555310\mathrm{.}03334455551010\mathrm{.}03334455552010\mathrm{.}0453453453120\mathrm{.}0453453453220\mathrm{.}0666884444340\mathrm{.}0888665555200\mathrm{.}09876543212015\mathrm{.}09876543213020\mathrm{.}09879879871035\mathrm{.}0987987987305\mathrm{.}09998877771010\mathrm{.}09998877773030\mathrm{.}0$queries :List the first name, last name, Supervisor's first and last name, Department number and the average salary for everyone in AdministrationFor every the employee with a dependent, list the dependent's first name, the employee's last name, and relation to the employee.List the name of employees with a dependent named "Alice" and the relationship to the employee.List everyone who works in Research $($name and salary$).$For each project, list project name, location, department and the superior of everyone working on that project.