1.Create one XML data file and one DTD file for the entire data set below [Use of ID and IDREF are not required.]

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 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

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