How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Use Tuple Relational Calculus (TRC) and Domain Relational

Customer Question

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.
Use both
Submitted: 3 months ago.
Category: Homework
Customer: replied 3 months ago.
added an image containing the tables
Expert:  Bruce Wilner replied 3 months ago.

You haven't specified a particular notation for your "tuple relational calculus."

Some use PROJECT, SELECT, JOIN.

Some use pi, sigma, x.

Some use postfix notation, others use infix.

Please provide one (1) example for your supposed distinction between TRC and DRC.

? ? ?

Customer: replied 3 months ago.
PROJECT, SELECT, JOIN.
Customer: replied 3 months ago.
something like TRC> {S.sname, C.cname |S in Student and C in Course };
DRC> {SNAME, CNAME |
(exists S#,AGE,C#,LOC)(
Student(S#,SNAME,AGE) and
Course(C#,CNAME,LOC)) };
Customer: replied 3 months ago.
i need befor 11 bw