Task
Week 5: Worksheet CSC 343 Winter 2021
University of Toronto Mississauga February 11/12, 2021
Given the following relations:
Suppliers(sid:integer, sname:string, address:string)
Parts(pid:integer, pname:string, colour:string)
Catalog(sid:integer, pid:integer, cost:real)
Please note: keys for each relation are denoted with an underlined. Additionally, the Catalog rela- tion lists the prices charged for parts by Suppliers (i.e. cost).
Find the sids of suppliers who supply some red or green part.
Find the pids of parts supplied by at least two different suppliers.
1