Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USING WINRDBI 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,

USING WINRDBI

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'

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Web Database Development Step By Step

Authors: Jim Buyens

1st Edition

0735609667, 978-0735609662

More Books

Students also viewed these Databases questions