Question: Write the following queries in Relational Algebra. Question 2 (20 points) Consider the following three relational schemas: Supplier (sid, sname, address) Catalog (sid, pid, count)

Write the following queries in Relational Algebra.

Write the following queries in Relational Algebra. Question 2 (20 points) Consider

Question 2 (20 points) Consider the following three relational schemas: Supplier (sid, sname, address) Catalog (sid, pid, count) Product (pid, pname, price) - sid is the key for Supplier " pid is the key for Part sid and pid together form the key for Catalog. Catalog.sid refers to Supplier.sid and Catalog.pid refers to Product.pid Write the following queries in Relational Algebra. 1) Find the names of suppliers who supply a product which price is greater than $100 2) Find the names of products supplied by at least one supplier 3) Find the sids of suppliers who do not supply "laptop" 4) Find the sids of supplier who supply both "laptop" and "desktop". 5) Find the pids of products supplied by all suppliers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Simulation and analysis subject Two-piece suits are processed by a dry cleaner as follows. Suits arrive with exponential interarrival times having mean 10 minutes, and are all initially served by...

Write the following queries in Relational Algebra. Question 2 (20 points) Consider the following three relational schemas Supplier (sid, sname, address) Catalog (sid, pid, count) Product (pid, pname,...

Supplier (sid, sname, age) Catalog (sid, pid, count) Product (pid, pname, price) - sid is the key for Supplier. . pid is the key for Part. - sid and pid together form the key for Catalog. -...

Supplier (sid, sname, age) Catalog (sid, pid, count) Product (pid, pname, price) sid is the key for Supplier pid is the key for Part. - sid and pid together form the key for Catalog. Catalog.sid...

6 - 1 0 only Consider the following schema: SUPPLIERS ( SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string ) PARTS ( PID: integer, PNAME: string, COLOR: string ) CATALOG ( SID:...

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID:integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Consider the following schema: SUPPLIERS (SID: integer, SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer, PNAME: string, COLOR: string) CATALOG (SID: integer, PID:...

Question No: 0 2 This is a subjective question, hence you have to write your answer in the Text - Field given below. Consider the following relations that have Suppliers information, Product...

Visit the link given below See IT sourcing and cloud strategy Find 2 peer-reviewed articles from academic journals on information technology sourcing. Summarize each article and compare and contrast...

Surj has just inherited his small family farm. He is new to the business and knows little about finding consumers for cattle as well as wheat grown on the farm. What channel type would you recommend...

mila caballero has taken a 2 0 year, $ 2 9 0 0 0 0 mortgage on her house at an interst rate of 6 % per year. What is the remaining balance of the mortgage after the payment of the fifth annual...

You are a financial analyst for ABC Company. The director of capital budgeting has asked you to analyze two proposed capital investments for project X. The project has a cost of Tk. 30,000 and the...

3 The Amish forgive those involved in conflict with them because of their deeply held religious beliefs. Are there other reasons for forgiveness that can be useful in a conflict?

4 What is your reaction to the information on Amish forgiveness in light of what we learned about Amish shunning earlier in the chapter?

Think of an attitude you have about conflict that is making it difficult for you to talk productively about disagreements with someone in your life. For example, do you believe that discussing...