Worker Department Location Manager Department Spiffy Computer Service Div San Jose Spiffy Computer Service Div Hint:...

Transcribed Image Text:

Worker Department Location Manager Department Spiffy Computer Service Div San Jose Spiffy Computer Service Div Hint: Use self join concept to retrieve respective department names The structure of the Employee, Department tables are as below: Employee not null empno firstname midinit lastname char(6) varchar(12) not null char(1) varchar(15) not null char(3) not null Department workdept primary key foreign key check phoneno >= '0000000000' and phoneno <= '9999999999 deptno char(3) char(10) date varchar(36) not null char(6) char(3) char(16 deptname phoneno hiredate job edlevel mgrno char(9) smallint char(1) date admrdept not null location sex birthdate salary decimal(9,2) decimal(9,2) decimal(9,2) bonus comm Worker Department Location Manager Department Spiffy Computer Service Div San Jose Spiffy Computer Service Div Hint: Use self join concept to retrieve respective department names The structure of the Employee, Department tables are as below: Employee not null empno firstname midinit lastname char(6) varchar(12) not null char(1) varchar(15) not null char(3) not null Department workdept primary key foreign key check phoneno >= '0000000000' and phoneno <= '9999999999 deptno char(3) char(10) date varchar(36) not null char(6) char(3) char(16 deptname phoneno hiredate job edlevel mgrno char(9) smallint char(1) date admrdept not null location sex birthdate salary decimal(9,2) decimal(9,2) decimal(9,2) bonus comm