Sign In Sign Up Ask an AI advisor
kyle65
kyle65
19.10.2021 • 
Mathematics

1. Find the names of parts for which there is some supplier 2. Find the names of parts supplied by suppliers who are at 1 Central Ave. 3. Find the names of suppliers who supply some red part. 4. Find the SIDs of suppliers who supply some red or green part. 5. Find the SID of suppliers who supply some red part or whose address is '221 Packer Street'. 6. Find the SIDs of suppliers who supply some red part and some green part. 7. Find the PIDs of parts that are red or are supplied by a supplier who is at the city of Newark. 8. Find the PIDs of parts supplied by a supplier who is at the city of Newark and by a supplier who is at the city of Trenton. 9. Find the PIDs of parts supplied by every supplier. 10. Find the PIDs of parts supplied by every supplier who supplies at least one part. 11. Find the PIDs of parts supplied by every supplier who is at the city of Newark or at the city of Trenton (equivalently: find the PIDs of parts supplied by every supplier who is at the city of Newark and by every supplier who is at the city of Trenton). 12. Find the PIDs of parts supplied by every supplier who is at the city of Newark or by every supplier who is at the city of Trenton. 13. Which one of the queries 11 and 12 is more restrictive (if any)

Solved
Show answers

Ask an AI advisor a question

I want advice