Please help me with this problem and needed correct solution please.... 8. Consider the following relations given by the tablesTABLE 3.6.4 EMPLOYEEIDNameManager1089SuzukiZamoraTABLE 3.6.5 I DEPARTMENT5620KaminskiJonesDeptManager9354JonesYu95513600RyanBeaulieuWashington23JonesYu04Yu0285SchmidtJones96Zamora6684ManacottiJones66WashingtonTABLE 3.6.7 I BUYERNamePart NoUnited SupplicsABC UnlimitedUnited Supplies2ATABLE 3.6.6 SUPPLIER8C2001199CDeptPart NoАтountJCN Electronics2A04335B2220United SuppliesABC Unlimited335B2232A14772048C200302Danny'sUnited Supplies9006642C3כרר049007720Underhanded Sales20A8Danny'sDePaul UniversityABC Unlimited9620A820020A8961199C29642C237723920A8Write a sequence of operations to answer the query "find the names of all employees who work in the departmentthat supply parts for JCN Electronics". You need to provide the relation obtained by executing each operation andprovide the final answer to the query. Use tables 3.6.4-3.6.7 as needed.

We will use the below sequence to find names of all employees who work in the department that…

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

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

Similar questions

Initiative: Implementing Product Inspection and Consumer Engagement Based on the above initiatives created for a company working toward B corp certification and to help strengthen the corporation's commitment to people, planet and profit: 1)Recommend an operational management strategy or technique (e.g., project management, lean manufacturing, or Six Sigma) that is appropriate to implement for each selected initiative, and explain why. 2)Define the requirements for the successful implantation of each selected initiative as well as the scope of each. Describe how changes to the requirements and scope would impact timelines, budget, and risk. 3)Explain the key internal and external stakeholders who would be involved in planning and implementing each selected initiative, as well as why each identified stakeholder is needed to successfully implement the initiatives.
Hi, I need help solving this OM problem. Thank you! Table E.3 is shown in the blue box onscreen.
business function
Can you identify and explain five instrumented items used in the sport of football?
Topic: Management information systems Please read and answer throughly beening a operational manager of the Marketing department The MGMT Insurance Ltd. accepts payments on various insurance policies from employees of businesses across the island. These businesses deduct payments from employees’ salaries and pay the insurance company a lump sum each month. This total amount deducted is shown on each employee’s payslip. Deductions are due at the end of each month and each participating business submits one payment for its employees to the insurance company via online payments through the bank. However, if payments were received after 11:00 a.m., the bank does not process them until the next business day. At the beginning of each month an administrative assistant at MGMT Insurance Ltd. downloads the deductions for each company and allocates payments to the various policies. These payments include the client’s unique number along with his/her relevant policy numbers and amounts due.…
i'm not understanding how the solution should be written in the table, also it would be nice if you explain it more please
Hurry, please 1. Explain the relationship between customer expectations and customer perceptions
A. What does the following scenario suggest to a company CEO? Sales in units are increasing and average price is increasing. Net operating income is increasing. a. The current business environment (external environmental factors) is improving b. Margin of safety is declining c. The integration between marketing and production is poor d. Variable production expenses have declined B. What does the following scenario suggest to a company CEO? Sales in units are decreasing and average price is increasing. Net operating income is increasing. a. The higher average price is hurting the overall company b. Product quality has declined c. The higher average price is making up for the lower volume d. Variable production expenses have increased
What is mean by communicating with line management? What are the issues and solutions for it
5) We offered 50% of our drivers monetary bonuses to increase their activity. Compare the results with the control group and explain if the campaign was successful and should we do it again or not. Condition: Stay online 30 hours and accept 75% of rides. Get 70€ bonus. Control Group Online hours Offline hours Bookings received Bookings successfully completed Bonus Group Online hours Offline hours Bookings received Bookings successfully completed Write here your answer about the results of the campaign Driver 1 15 35 15 13 Driver 55 33 19 29 25 Driver 2 29 21 30 Driver 56 5 55 6 6 Driver 3 17 23 12 10 Driver 57 32 8 19 16 Driver 4 31 19 31 26 Driver 58 32 18 29 26 Driver 5 36 24 44 24 Driver 59 38 22 20 17 Driver 6 14 26 10 12 Driver 60 17 23 10 9 Driver 7 5 40 5 4 Driver 61 4 46 3 3 Driver…
Identify one local service provider and do the following: 1. Describe the services the company provide. 2. Discuss how these services help the community. 3. Choose a particular service of the company and show how the bill or charge for that service is computed. 4. Write a formula for computing the bill or charge. 5. Show computations for three different transactions. 6. Submit a written report.
18. The purpose of a Property Management System is to: A) manage the entire lodging property operation by keeping all of the information regarding all departments in one computer system. B) manage only the guestrooms portion of a lodging property operation by keeping the information regarding the front desk and housekeeping in one computer system C) manage the food and beverage portion of a lodging property business by keeping the information regarding the restaurant and room service in one computer system. D) assist in developing marketing and promotion packages.