Expressing queries using Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC)

use Tuple Relational Calculus (TRC) and Domain Relational Calculus (DRC) to express the following queries. You should include each question with its number and the two kinds of queries, and also query results.

Get the part names that Adams provides.

Get supplier names for suppliers who supply part P2.

Get supplier names and the quantity of parts supplied.

Get supplier names for suppliers who supply parts with quantity less than 300 (instead of 500)

Get supplier names for suppliers who supply either blue or green parts.

Get supplier name/part name pairs such that the indicated supplier does not supply the indicated part.

Get supplier names for suppliers who does not supply any parts.

Get supplier names for suppliers who supply all parts.

Get supplier names for suppliers who supply all parts except P1.

Get supplier names and the number of parts and total quantity supplied.

Among other benefits, we guarantee:

  • Essays written from scratch – 100% original,

  • Timely delivery,

  • Competitive prices and excellent quality,

  • 24/7 customer support,

  • Priority on customer’s privacy,

  • Unlimited free revisions upon request, and

  • Plagiarism free work.

Providing quality essays, written from scratch, delivered on time, at affordable rates!

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: