Question: Write a sequence of operations to answer the query. Also, provide an answer to the query. Use Tables 8 . 1 . 4 - 8

Write a sequence of operations to answer the query. Also, provide an answer to the query.
Use Tables 8.1.4-8.1.7.
Find the names of all employees. (Do not include any managers.)
Find all part numbers.
Find the names of all buyers.
Find the names of all employees who are managed by Jones.
Find all part numbers supplied by department 96.
Find all buyers of part 20A8.
Find all employees in department 04.
Find the part numbers of parts of which there are at least 100 items on hand.
9 Find all department numbers of departments that supply parts to Danny's.
Find the part numbers and amounts of parts bought by United Supplies.
Find all managers of departments that produce parts for ABC Unlimited.
Find the names of all employees who work in departments that supply parts for JCN
Electronics.
Find all buyers who buy parts in the department managed by Jones.
Find all buyers who buy parts that are produced by the department for which Suzuki works.
Find all part numbers and amounts for Zamora's department.
 Write a sequence of operations to answer the query. Also, provide

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 General Management Questions!