Question
Database Systems EXERCISES ON RELATIONAL ALGEBRA (NEEDS TO USE ORACLE LANGAUGE SOFTWARE) - ORACLE PLEASE DO NOT NOT WRITE IN SQL ORACLE SOFTWARE ONLY!! Use
Database Systems
EXERCISES ON RELATIONAL ALGEBRA
(NEEDS TO USE ORACLE LANGAUGE SOFTWARE) - ORACLE PLEASE
DO NOT NOT WRITE IN SQL
ORACLE SOFTWARE ONLY!!
Use the following schema to write relational algebra statements for the questions that follow. The primary keys are underlined in the schema.
Pilot(pid: integer,pname: char,salary: integer)
Aircraft(aid: integer,aname: char,cruisingrange: integer)
Flight(flightno: integer,aid: integer,pid: integer,day: date)
1. Find the names of pilots who use the aircraft (aname) Boeing 727.
2. Find the id and name of the pilot who operated flightno CO103 on 01/01/99 with a cruising range of 3000 miles.
3. Find the cruising range of the aircraft operated by Jeffery Jones on 12/23/97.
4. Find the ids and names of pilots who can operate aircrafts with a range greater than 5000 miles with salaries more than $100,000.
5. List all the flights on 02/22/98.
6. List all the pilots.
7. Find the names pilots who operate of aircrafts with a cruising range between 4000 miles and 6000 miles.
8. List the id and name of the aircraft used for flightno NW111.
9. List all the Boeing 757 (aname) aircrafts.
10. Find the names of all pilots who receive a salary greater than $150,000.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started