Exercises

Write a sequence of operations to answer the query. Also, provide an answer to the query. Use

Tables $8\mathrm{.}1\mathrm{.}48\mathrm{.}1\mathrm{.}7.$

TABLE $8\mathrm{.}1\mathrm{.}4$ EMPLOYEE

ID Name Manager

$1089$ Suzuki Zamora

$5620$ Kaminski Jones

$9354$ Jones Yu

$9551$ Ryan Washington

$3600$ Beaulieu Yu

$0285$ Schmidt Jones

$6684$ Manacotti Jones

$15|$ P a g e

TABLE $8\mathrm{.}1\mathrm{.}5$ DEPARTMENT

Dept Manager

$23$ Jones

$04$ Yu

$96$ Zamora

$66$ Washington

TABLE $8\mathrm{.}1\mathrm{.}6$ SUPPLIER

Dept Part No Amount

$04335$B$2220$

$232$A $14$

$048$C$200302$

$6642$C $3$

$049007720$

$9620$A$8200$

$961199$C $296$

$2377239$

TABLE $8\mathrm{.}1\mathrm{.}7$ BUYER

Name Part No

United Supplies $2$A

ABC Unlimited $8$C$200$

United Supplies $1199$C

JCN Electronics $2$A

United Supplies $335$B$2$

ABC Unlimited $772$

Danny$$s $900$

$16|$ P a g e

United Supplies $772$

Underhanded Sales $20$A$8$

Danny$$s $20$A$8$

DePaul University $42$C

ABC Unlimited $20$A$8$

Write a sequence of operations to answer the query. Also, provide an answer to the query.

Use Tables $8\mathrm{.}1\mathrm{.}48\mathrm{.}1\mathrm{.}7.$

$1.$ Find the names of all employees. $($Do not include any managers.$)$

$2.$ Find all part numbers.

$3.$ Find the names of all buyers.

$4.$ Find the names of all employees who are managed by Jones.

$5.$ Find all part numbers supplied by department $96.$

$6.$ Find all buyers of part $20$A$8.$

$7.$ Find all employees in department $04.$

$8.$ 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$.$

$10.$ Find the part numbers and amounts of parts bought by United Supplies.

$11.$ Find all managers of departments that produce parts for ABC Unlimited.

$12.$ Find the names of all employees who work in departments that supply parts for JCN

Electronics.

$13.$ Find all buyers who buy parts in the department managed by Jones.

$14.$ Find all buyers who buy parts that are produced by the department for which Suzuki works.

$15.$ Find all part numbers and amounts for Zamora$$s department.