Question

1. Create one XML data file and one DTD file for the entire data set (using a subset of SQL assignment – see below). [Use of ID and IDREF are not required.]

2. Write and execute XML statements for the following two 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 companies for which they work.

[You can replace one of the above with a query of your own choice – but it must not be too simple. If this is the case, state the English statement before present the XML query and the result.]

Data to be used for this assignment

Employee

Name                            street          city               gender

--------------------------------------------------------

Anderson, Susan L          108th        Omaha           F

Brady, Dan L                  P street     Lincoln         M

Chen, Peter K                124^th           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

Works: employee_name         company_name      salary

------------------------------------------------

Anderson, Susan L     Mutual of Omaha   48000

Brady, Dan L          FDR               42000

Chen, Peter K                FDR                 53000

Clemson, Ann M        First Bank        39000

Dale, Mary K          Mutual of Omaha   58000

Gill, Mary L                  Union Pacific     48700

Harrison, Susan M          Union Pacific 54320     

Jackson, Kim A        FDR               68000

Jason, Pat M          FDR               83000

Kumar, Paul T          FDR               44000

Company:

company_name          city

-----------------------------

First Bank                       Omaha

FDR                   Omaha

Lincoln Star                    Lincoln

Mutual of Omaha       Omaha

Union Pacific     (UP)                 Omaha

Answer 1