RELATIONAL ALGEBRA Pilots are employees who are certified on at least one aircraft. An aircraft can...

 

Transcribed Image Text:

RELATIONAL ALGEBRA Pilots are employees who are certified on at least one aircraft. An aircraft can be used for any flight provided it has sufficient range and capacity. Pilots can pilot any flight provided they are certified on an aircraft with sufficient range and capacity. Flight(flightno, from, to, distance, noOfPassengers, departs) Aircraft(aircraftID, name, range, maxcapacity) Certified (EmpID, aircraftID) Employee(EmpID, Employee_name, email, address, salary) Required Using the following symbols copy as required (copy and paste), write expressions in relational algebra to: (, , , x, , , n,) a) Find the aircraft ID and name for all aircrafts that can fly non stop from London to Kingston b) Find the names, email and addresses of all employees who are not pilots c) Find names of pilots who can operate planes with a range between 2,000 and 5,000 miles, but are not certified on any Airbus. d) Give the employee Id, name, email and address of the employee (s) with the lowest salary. [2+2+3+2] 7 A B I RELATIONAL ALGEBRA Pilots are employees who are certified on at least one aircraft. An aircraft can be used for any flight provided it has sufficient range and capacity. Pilots can pilot any flight provided they are certified on an aircraft with sufficient range and capacity. Flight(flightno, from, to, distance, noOfPassengers, departs) Aircraft(aircraftID, name, range, maxcapacity) Certified (EmpID, aircraftID) Employee(EmpID, Employee_name, email, address, salary) Required Using the following symbols copy as required (copy and paste), write expressions in relational algebra to: (, , , x, , , n,) a) Find the aircraft ID and name for all aircrafts that can fly non stop from London to Kingston b) Find the names, email and addresses of all employees who are not pilots c) Find names of pilots who can operate planes with a range between 2,000 and 5,000 miles, but are not certified on any Airbus. d) Give the employee Id, name, email and address of the employee (s) with the lowest salary. [2+2+3+2] 7 A B I