10findthepidsofthemostexpensivepartssuppliedbysupplier

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: sids such that the supplier with the first sid charges more for some part than the supplier with the second sid. 9. Find the pids of parts supplied by at least two different suppliers. 10. Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham. Exercise 3 (Relational Calculi) [20pts] Consider the following database schema: EMPLOYEE (emp_name, address_street, address_city, phone_no) DEPARTMENT (dept_name, mgr_name, mgr_start_date) WORKS_ON (emp_name, industry_name, salary) INDUSTRY (industry_name,...
View Full Document

Ask a homework question - tutors are online