Who can help me in relational algebraic expression and sql statment
CREATE TABLE Faculty(
FacSSN char(11) not null primary key,
FacFirstName varchar(30) not null,
FacLastName varchar(30) not null,
FacCity varchar(30) not null,
FacState char(2) not null,
FacZipCode char(10) not null,
FacRank char(4),
FacHireDate datetime,
FacSalary decimal(10,2),
FacSupervisor char(11),
FacDept char(6),
Constraint FacltyFK
Foreign Key (FacSupervisor)
references Faculty(FacSSN)
on delete no action
on update no action
)
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ('543-21-0987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','P ROF',120000.0,Null,'15-Apr-1996','98011-2242')
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ( '765-43-2109','NICKI','MACON','BELLEVUE','WA','FIN','PROF' ,65000.00,Null,'11-Apr-1997','98015-9945')
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ('654-32-1098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC' ,70000.00,'543-21-0987','01-May-1994','98121-0094')
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ('098-76-5432','LEONARD','VINCE','SEATTLE','WA','MS','ASST' ,35000.00,'654-32-1098','10-Apr-1995','98111-9921')
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ('876-54-3210','CRISTOPHER','COLAN','SEATTLE','WA','MS','AS ST',40000.00,'654-32-1098','01-Mar-1999','98114-1332')
Insert into Faculty
(FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
Values ('987-65-4321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC', 75000.00,'765-43-2109','15-Mar-2000','98114-9954')
A Theta-join operation between Faculty and itself to retrieve faculty members who have a higher salary than their supervisor.
who can help thanks!!need urgently..
