Please Consider the Following Table and Answer the Questions. Suppliers (sid: integer, name: string, address: string) Parts
Fantastic news! We've Found the answer you've been seeking!
Question:
Please Consider the Following Table and Answer the Questions.
- Suppliers(sid: integer, name: string, address: string)
- Parts(pid: integer, pname: string, color: string)
- Catalog(sid: integer, pid: integer, cost: real)
- Find the IDs of suppliers who supply some red or green part.
- Find the IDs of suppliers who supply some red part or are based at 21 George Street.
- Write down the Statement for the following query
- πsname (σcolour=0 red0 (Part) ✶ σcost<100 (Catalog) ✶ Supplier)
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date: