Write the queries in relational algebra, Database Management System

Assignment Help:

Problem:

You are given the following schema

1. Flights(flno, from, to, distance)
2. Aircraft(aid, flno, aname, cruisingRange)
3. Certified(eid, aid)
4. Employees(eid, ename, salary)

‘CruisingRange' is the distance that can be covered by an aircraft in a non-stop mode.

(i) Write the following queries in Relational Algebra.

(a) Find the names of pilots certified for 'Boeing 747' aircraft.

(b) Find the ids of all aircraft that can be used on non-stop flights from New York to Los Angeles.

(c) Find the names of pilots who can operate planes with a range greater than 3000 miles, but are not certified on 'Boeing 747' aircraft.

(ii) Write the following queries in SQL.

(a) Find the ids of employees who are not certified at all.

(b) Find the ids of all aircraft that can be used on non-stop flights from New York to Los Angeles.

Related Discussions:- Write the queries in relational algebra

Create database and define relationships between tables, Instructions: ...

Instructions: Follow the instructions below for completing this project: 1. Creating the Database: · Use the physical table descriptions given below to define and create each t

Working and processing files, 1. Define each of the following IN YOUR OWN ...

1. Define each of the following IN YOUR OWN WORDS: (a) File: (b) Record: (c) Field: (d) Primary Key: (e) Secondary Key: 2. A travel agency wants t

BI, (a) Why did SAP introduce the extended star schema?

(a) Why did SAP introduce the extended star schema?

ERD, A student entity type has the following attributes,name..

A student entity type has the following attributes,name..

Explain saving derived attributes to avoid re-computation, Saving Derived A...

Saving Derived Attributes to Avoid Re-computation As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Organic compounds, #question.explain diversity and magnitude of organic com...

#question.explain diversity and magnitude of organic compounds and general properties?

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Create table statements for original database, MySQL statements for extendi...

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

Implementing a data warehouse, (a) Data warehouse can be defined as "a sub...

(a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea

Which database level is closest to the users, Which database level is close...

Which database level is closest to the users? External database level is closest to the users.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages