USING WINRDBI

1) Retrieve the names of all employees in department 5 who work more

than 10 hours per week on the ProductX project.

2) List the names of all employees who have a dependent with the same first

name as themselves.

3) Retrieve the names of all employees who do not work on any project.

4) Find the names and addresses of all employees who work on at least one

project located in Houston but whose department has no location in Houston.

5) List the last names of all department managers who have no dependents.

6) Retrieve the first and last names of all employees who work on every project.

7) Write the first and the last names of all employees who have exactly 2 dependents.

-----------------------------COMPANY DATABASE GIVEN-----------------------------

@employee(fName/char,mInit/char,lName/char,eSSN/char,eBdate/char,eAddress/char,eSex/char,eSalary/numeric,superSSN/char,dNumber/numeric):eSSN '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','J','Zelaya','999887777','1968-01-19','3321 Castle, Spring, TX','F',25000,'987654321',4 'Jennifer','S','Wallace','987654321','1941-06-20','291 Berry, Bellaire, TX','F',43000,'888665555',4 'Ramesh','K','Narayan','666884444','1962-09-15','975 Fire Oak, Humble, TX','M',38000,'333445555',5 'Joyce','A','English','453453453','1972-07-31','5631 Rice, Houston, TX','F',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','M',55000,'',1

@department(dName/char,dNumber/numeric,mgrSSN/char,mgrStartDate/char):dName 'Research',5,'333445555','1988-05-22' 'Administration',4,'987654321','1995-01-01' 'Headquarters',1,'888665555','1981-06-19'

@deptLocation(dNumber/numeric,dLocation/char):dNumber, dLocation 1,'Houston' 4,'Stafford' 5,'Bellaire' 5,'Sugarland' 5,'Houston'

@projects(pName/char,pNumber/numeric,pLocation/char,dNumber/numeric):pNumber 'ProductX',1,'Bellaire',5 'ProductY',2,'Sugarland',5 'ProductZ',3,'Houston',5 'Computerization',10,'Stafford',4 'Reorganization',20,'Houston',1 'Newbenefits',30,'Stafford',4

@worksOn(eSSN/char,pNumber/numeric,wHours/numeric):eSSN, pNumber '123456789',1,32.5 '123456789',2,7.5 '123456789',3,15 '123456789',10,4 '123456789',20,5 '123456789',30,1 '666884444',3,40 '453453453',1,20 '453453453',2,20 '333445555',2,10 '333445555',3,10 '333445555',10,10 '333445555',20,10 '999887777',30,30 '999887777',10,10 '987987987',10,35 '987987987',30,5 '987654321',30,20 '987654321',20,15

@dependent(eSSN/char,dependentName/char,dSex/char,dBdate/char,relationship/char):eSSN, dependentName '333445555','Alice','F','1986-04-05','daughter' '333445555','Franklin','M','1983-10-25','son' '333445555','Joy','F','1958-05-03','spouse' '987654321','Abner','M','1942-02-28','spouse' '987654321','Marcos','M','1944-02-28','son' '123456789','Michael','M','1988-01-04','son' '123456789','Alice','F','1988-12-30','daughter' '123456789','Elizabeth','F','1967-05-05','spouse'