Using the XML file below write the following queries in XML Q1 Find the name of an employee who lives in Lincoln and works in Omaha Q2 Find salaries of employees who live in the same cities as the companies for which they work Anderson, Susan L 108th Omaha F Brady, Dan L P street Lincoln M Chen, Peter K 124th Omaha M Clemson, Ann M O Lincoln F Dale, Mary K 132th Omaha F Gill, Mary L P Street Lincoln F Harrison, Susan M Old Mill Omaha F Jackson, Kim A 178th Omaha F Jason, Pat M 8th C Bluffs M Kumar, Paul T Dodge Omaha M Anderson, Susan L Mutual of Omaha 48000 Brady, Dan L FDR 42000 Chen, Peter K FDR 53000 Clemson, Ann K First Bank 39000 Dale, Mary K Mutual of Omaha 58000 Gill, Mary L Lincoln Star 48700 Harrison, Susan M Union Pacific (UP) 54320 Jackson, Kim A FDR 68000 Jason, Pat M FDR 83000 Kumar, Paul T FDR 44000 First Bank Omaha FDR Omaha Lincoln Star Lincoln Mutual of Omaha Omaha Union Pacific (UP) Omaha

The Answer is in the image, click to view ...

Question: Using the XML file below write the following queries in XML Q1. Find the name of an employee who lives in Lincoln and works in

Using the XML file below write the following queries in XML

Q1. Find the name of an employee who lives in Lincoln and works in Omaha.

Q2. Find salaries of employees who live in the same cities as the companies for which they work.

Anderson, Susan L

108th

Omaha

Brady, Dan L

P street

Lincoln

Chen, Peter K

124th

Omaha

Clemson, Ann M

Lincoln

Dale, Mary K

132th

Omaha

Gill, Mary L

P Street

Lincoln

Harrison, Susan M

Old Mill

Omaha

Jackson, Kim A

178th

Omaha

Jason, Pat M

8th

C.Bluffs

Kumar, Paul T

Dodge

Omaha

Anderson, Susan L

Mutual of Omaha

48000

Brady, Dan L

FDR

42000

Chen, Peter K

FDR

53000

Clemson, Ann K

First Bank

39000

Dale, Mary K

Mutual of Omaha

58000

Gill, Mary L

Lincoln Star

48700

Harrison, Susan M

Union Pacific (UP)

54320

Jackson, Kim A

FDR

68000

Jason, Pat M

FDR

83000

Kumar, Paul T

FDR

44000

First Bank

Omaha

FDR

Omaha

Lincoln Star

Lincoln

Mutual of Omaha

Omaha

Union Pacific (UP)

Omaha

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 Databases Questions!

Write and execute XML statements for the following queries: Q1. Find the name of an employee who lives in Lincoln and works in Omaha. Q2. Find salaries of employees who live in the same cities as the...

employee (Lastname, FirstName, MidInitial, gender, street, city) works (Lastname, FirstName, MidInitial, company_name, salary) company (company_name, city) manages(Lastname, FirstName, MidInitial,...

1. Create a new database companyx, all the existing the relations implied from tables shown and populate it. 2. From the Wamp, export the PDF that shows all tables and their relations. 4 4 EMPLOYEE...

How can you summarize the compensation and reward system of the three organizations? What do they all have in common, if anything? Look up everything you can find that has been written about Lincoln...

Write a program that handles I/O of Employee objects containing the following data attributes: name (string) id (int) address (string) city (string) state (string) country (string) phone (string)...

Hi how are you? Do you think you can help me answer these questions? ACC 693 Chapter 8 Quiz Note: The material contained within these pages is taken directly from your textbook, Computerized Auditing...

Write a program that handles I/O of Employee objects containing the following data attributes: name (string) id (int) address (string) city (string) state (string) country (string) phone (string)...

P3-XML-Part 1 CS 3370 Program 3 XML-String and Stream Processing Part One Employee Class Write a program that handles I/O of Employee objects containing the following data attributes: name (string)...

I am struggling to do the proper computations for some simple accounting. After i get this down, i will produce a paper on the importance of each number i solved for. Can someone please help me...

Which of the following pairs do not constitute resonating structure (a) (c) Me-N = 0 and Me-O-N=0 09 and OH (b) Me CH and Me- CH (d) Me-CH=CH-Me and MeCHCH=CH

1.00 pint of milk has a volume of how many milliliters? (2 pints = 1 quart) (1 quart = 0.946 L) (1 L =1000 mL) %3D

john wants to set up a 1 0 year grat and does not want to have a taxable gift

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

6. Notify employees of the change. Announce the change to an online handbook in a way that ensures all employees will know about the new format. Consider a mandatory sign-on within the transition...

3. Research the various ADR options to determine which ones are the best fit for the organization. For example, peer review is most successful when there is a high level of trust within the workforce.

7. Immediately notify employees of changes. Be sure to develop a process for maintaining the handbook and letting employees know when things change. While an online handbook can be easily updated, it...