Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Consider the following relations given by the tables TABLE 3.6.4 EMPLOYEE ID Name Manager 1089 Suzuki Zamora TABLE 3.6.5 I DEPARTMENT 5620 9354 Kaminski Jones Jones Yu Dept Manager 9551 Ryan Beaulieu Washington Yu 23 Jones 3600 04 Yu 0285 Schmidt Jones 96 Zamora 6684 Manacotti Jones 66 Washington TABLE 3.6.7 BUYER Name Part No United Supplies ABC Unlimited 2A 8C200 TABLE 3.6.6 SUPPLIER United Supplies JCN Electronics 1199C Dept Part No Amount 2A 335B2 772 900 04 335B2 220 United Supplies ABC Unlimited 23 2A 14 04 8C200 302 Danny's United Supplies 420 900 66 3 772 04 7720 Underhanded Sales 20A8 20A8 1199C 772 200 Danny's DePaul University 96 20A8 96 296 42C 20A8 23 39 ABC Unlimited /rite a sequence of operations to answer the query "find the names of all employees who work in the depar at supply parts for JCN Electronics". You need to provide the relation obtained by executing each operation rovide the final answer to the query. Use tables 3.6.4-3.6.7 as needed.

Consider the following relations given by the tables TABLE 3.6.4 EMPLOYEE ID Name Manager 1089 Suzuki Zamora TABLE 3.6.5 I DEPARTMENT 5620 9354 Kaminski Jones Jones Yu Dept Manager 9551 Ryan Beaulieu Washington Yu 23 Jones 3600 04 Yu 0285 Schmidt Jones 96 Zamora 6684 Manacotti Jones 66 Washington TABLE 3.6.7 BUYER Name Part No United Supplies ABC Unlimited 2A 8C200 TABLE 3.6.6 SUPPLIER United Supplies JCN Electronics 1199C Dept Part No Amount 2A 335B2 772 900 04 335B2 220 United Supplies ABC Unlimited 23 2A 14 04 8C200 302 Danny's United Supplies 420 900 66 3 772 04 7720 Underhanded Sales 20A8 20A8 1199C 772 200 Danny's DePaul University 96 20A8 96 296 42C 20A8 23 39 ABC Unlimited /rite a sequence of operations to answer the query "find the names of all employees who work in the depar at supply parts for JCN Electronics". You need to provide the relation obtained by executing each operation rovide the final answer to the query. Use tables 3.6.4-3.6.7 as needed.

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
Please help me with this problem and needed correct solution please....
8. Consider the following relations given by the tables TABLE 3.6.4 EMPLOYEE ID Name Manager 1089 Suzuki Zamora TABLE 3.6.5 I DEPARTMENT 5620 Kaminski Jones Dept Manager 9354 Jones Yu 9551 3600 Ryan Beaulieu Washington 23 Jones Yu 04 Yu 0285 Schmidt Jones 96 Zamora 6684 Manacotti Jones 66 Washington TABLE 3.6.7 I BUYER Name Part No United Supplics ABC Unlimited United Supplies 2A TABLE 3.6.6 SUPPLIER 8C200 1199C Dept Part No Атount JCN Electronics 2A 04 335B2 220 United Supplies ABC Unlimited 335B2 23 2A 14 772 04 8C200 302 Danny's United Supplies 900 66 42C 3 כרר 04 900 7720 Underhanded Sales 20A8 Danny's DePaul University ABC Unlimited 96 20A8 200 20A8 96 1199C 296 42C 23 772 39 20A8 Write a sequence of operations to answer the query "find the names of all employees who work in the department that supply parts for JCN Electronics". You need to provide the relation obtained by executing each operation and provide the final answer to the query. Use tables 3.6.4-3.6.7 as needed.
Transcribed Image Text:8. Consider the following relations given by the tables TABLE 3.6.4 EMPLOYEE ID Name Manager 1089 Suzuki Zamora TABLE 3.6.5 I DEPARTMENT 5620 Kaminski Jones Dept Manager 9354 Jones Yu 9551 3600 Ryan Beaulieu Washington 23 Jones Yu 04 Yu 0285 Schmidt Jones 96 Zamora 6684 Manacotti Jones 66 Washington TABLE 3.6.7 I BUYER Name Part No United Supplics ABC Unlimited United Supplies 2A TABLE 3.6.6 SUPPLIER 8C200 1199C Dept Part No Атount JCN Electronics 2A 04 335B2 220 United Supplies ABC Unlimited 335B2 23 2A 14 772 04 8C200 302 Danny's United Supplies 900 66 42C 3 כרר 04 900 7720 Underhanded Sales 20A8 Danny's DePaul University ABC Unlimited 96 20A8 200 20A8 96 1199C 296 42C 23 772 39 20A8 Write a sequence of operations to answer the query "find the names of all employees who work in the department that supply parts for JCN Electronics". You need to provide the relation obtained by executing each operation and provide the final answer to the query. Use tables 3.6.4-3.6.7 as needed.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 23 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS