Question: (A) Consider the following schema: Suppliers(sid: integer, sname: varchar(20), address: varchar(50)) Parts(pid: integer, pname: varchar(20), color: varchar(15)) Catalog(sid: integer, pid: integer, cost: real) The key

Parts(pid: integer, pname: varchar(20), color: varchar(15)) Catalog(sid: integer, pid: integer, cost: real)

(A) Consider the following schema: Suppliers(sid: integer, sname: varchar(20), address: varchar(50)) Parts(pid: integer, pname: varchar(20), color: varchar(15)) Catalog(sid: integer, pid: integer, cost: real) The key fields are underlined Domains of each field are listed after field name The Catalog relation lists prices charged for parts by Suppliers . . Write the following queries in relational algebra (30 points): (i) Find the names of suppliers who supply some blue part (ii) Find the sids of suppliers who do not supply a red part (ii) Find the sids of suppliers who supply some blue or red part (iv) Find the sids of suppliers who supply some blue part and some red part

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!

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:...

CIS 631: DATA MANAGEMENT SYSTEMS DESIGN ASSIGNMENT 1 Consider the following schema: SUPPLIERS (SID: integer , SNAME: string, STREET: string, CITY: string, ZIP: string) PARTS (PID: integer , PNAME:...

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: integer....

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:integer,...

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:...

EXERCISE 1 (SQL Queries) Consider the following schema: SUPPLIERS (SID : integer, SNAME : string, CITY : 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:...

Innovative Systems (IS) is a division of Global Electronics, Inc. IS produces videogame systems. These systems are sold to retailers. IS recently approached the manager of the Laptop Computer...

A firm's Inverse demand curve is P(Q) = 100 - 4Q and its total cost curve is C(Q) = 20Q where P is price and Q is quantity. Find the optimal price and optimal quantity

Which balance sheet items does not represent an asset of a bank? Question 1 3 Answer a . Overdrafts b . Lease finance c . Certificates of deposit d . Credit card draw - downs e . All of them

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

What is the difference between Needs and GAP Analyses?

What are ERP suites? Are HCMSs part of ERPs?

An economy is operating with output $400 billion below its natural rate, and fiscal policymakers want to close this recessionary gap. The central bank agrees to adjust the money supply to hold the...