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

What is multivalued attribute, What is Multivalued Attribute? Multival...

What is Multivalued Attribute? Multivalued Attribute - Multivalued attribute might have more than one value for an entity. For instance, PreviousDegrees of a STUDENT.

Prove that a relation which is 4nf must be bcnf, Prove that a relation whic...

Prove that a relation which is 4NF must be BCNF. Ans Let R be in 4NF. Suppose it is not in BCNF. Hence, there exists an FD X→Y in R such that x is not a super key. Although

Note gate, i want notes on this topic

i want notes on this topic

Draw enhanced er-diagram for hierarchy of a student database, Draw an EER d...

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Draw and explain the three level architecture of database, Draw and explain...

Draw and explain the three level architecture of the database system? A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schem

OLAP CUBES, 1) Define a job scheduling strategy that will meet business req...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

What is the function of a domain, What is the function of a Domain? A d...

What is the function of a Domain? A domain defines the technical settings of a table field. A domain describes a value range, which sets the permissible data values for the

What is object identity, What is object identity? An object retains its...

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Explain interblock gap, Explain Interblock gap? Interblock Gap - A trac...

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Explain the deferred update, Explain the Deferred Update The deferred ...

Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages