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

Data base design for a museum information system, In this practical assignm...

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

What is called remapping of bad sectors, What is called remapping of bad se...

What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto

Benefits of views-data control, Benefits: It limits data access. ...

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

Select statement-data manipulation language, SELECT Statement This stat...

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Integrity of a database enforced by integrity rules, Question: This Que...

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

Queries, Find the names of all Albums that have more than 30 tracks. Result...

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

School portal design and development, Project Description: This is going...

Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re

Types of attributes, Attributes attached to an entity can be of various typ...

Attributes attached to an entity can be of various types. Simple The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a

Responsibilitied of DBA, explain five responsibilities of DBA?

explain five responsibilities of DBA?

ER Modeling, explain ER Modeling?

explain ER Modeling?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages