note: give sql software querries that are to be used on the computer for the following question and urgently if possible.

According to the following relational diagram, what would be an output table if you:

a) Retrieve the birth date and address of the employee(s) whose name is John B. Smith

b) Retrieve the name and address of all employees who work for the Research department.

c) For every project located in Stafford, list the project number, the controlling department

number, and the department managers last name, address, and birth date.

d) For each employee, retrieve the employees first and last name and the first and last name

of his or her immediate supervisor.

e) Select all EMPLOYEE Ssn

f) Select all combinations of EMPLOYEE Ssn and DEPARTMENT Dname in the database.

4 EMPLOYEE Frame Minit Lname San Bdate Address Sex Salary Super_san Dno John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5 Joyce English 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 333445555 5 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M55000 NULL Exc 4 A 1 DEPARTMENT Dname Research Administration Headquarters Dnumber 5 4 1 Mgr_ssn 333445005 987654321 888665555 1 WORKS ON DEPT LOCATIONS Mgr_start_date Dnumber Dlocation 1988-05-22 Houston 1995-01-01 4 Stafford 1981-06-19 5 Bellaire 5 Sugarland 5 Houston PROJECT Pame Pnumber Plocation Dnum ProductX 1 Bellaire 5 Product 2 Sugarland 5 Productz 3 Houston 5 Computerization 10 Stafford 4 Reorganization 20 Houston 1 Newbenefits 30 Stafford Esan Pno 1 123456789 123456789 666884444 Hours 32.5 7.5 2 3 400 1 20.0 2 20.0 2 10.0 3 10.0 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 10 10.0 DEPENDENT 20 10.0 Essn 30 30.0 10.0 10 Dependent name Sex Alice F Theodore M Joy F Abner M 333445555 333445555 333445555 987654321 10 35.0 5.0 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse 30 30 20.0 M 987987987 987654321 987654321 888665555 Michael Alice 20 123456789 123456789 123456789 15.0 F 20 NULL Elizabeth F