1.Create one XML data file and one DTD file for the entire data set below [Use o
ID: 3919403 • Letter: 1
Question
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
Explanation / Answer
*****************************Answers**************************
******************Xml File************************
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<record>
<Name>Anderson</Name>
<street>Susan L 108th</street>
<city>Omaha</city>
<gender>F</gender>
<company_name>Susan L Mutual of Omaha</company_name>
<salary>48000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Brady</Name>
<street>Dan L P street</street>
<city>Lincoln</city>
<gender>M</gender>
<company_name>Dan L FDR</company_name>
<salary>42000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Chen</Name>
<street>Peter K 124th</street>
<city>Omaha</city>
<gender>M</gender>
<company_name>Peter K FDR</company_name>
<salary>53000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Clemson</Name>
<street>Ann M O</street>
<city>Lincoln</city>
<gender>F</gender>
<company_name>Ann M First Bank</company_name>
<salary>39000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Dale</Name>
<street>Mary K 132th</street>
<city>Omaha</city>
<gender>F</gender>
<company_name>Mary K Mutual of Omaha</company_name>
<salary>58000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Gill</Name>
<street>Mary L P street</street>
<city>Lincoln</city>
<gender>F</gender>
<company_name>Mary L Union Pacific</company_name>
<salary>48700</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Harrison</Name>
<street>Susan M Old Mill</street>
<city>Omaha</city>
<gender>F</gender>
<company_name>Susan M Union Pacific</company_name>
<salary>54320</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Jackson</Name>
<street>Kim A 178th</street>
<city>Omaha</city>
<gender>F</gender>
<company_name>Kim A FDR</company_name>
<salary>68000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Jason</Name>
<street>Pat M 8th</street>
<city>C.Bluffs</city>
<gender>M</gender>
<company_name>Pat M FDR</company_name>
<salary>83000</salary>
<company_city>Omaha</company_city>
</record>
<record>
<Name>Kumar</Name>
<street>Paul T Dodge</street>
<city>Omaha</city>
<gender>M</gender>
<company_name>Paul T FDR</company_name>
<salary>44000</salary>
<company_city>Omaha</company_city>
</record>
</root>
*******************Xml dtd file***********************
<?xml encoding="UTF-8"?>
<!ELEMENT root (record)+>
<!ATTLIST root
xmlns CDATA #FIXED ''>
<!ELEMENT record (Name,street,city,gender,company_name,salary,
company_city)>
<!ATTLIST record
xmlns CDATA #FIXED ''>
<!ELEMENT Name (#PCDATA)>
<!ATTLIST Name
xmlns CDATA #FIXED ''>
<!ELEMENT street (#PCDATA)>
<!ATTLIST street
xmlns CDATA #FIXED ''>
<!ELEMENT city (#PCDATA)>
<!ATTLIST city
xmlns CDATA #FIXED ''>
<!ELEMENT gender (#PCDATA)>
<!ATTLIST gender
xmlns CDATA #FIXED ''>
<!ELEMENT company_name (#PCDATA)>
<!ATTLIST company_name
xmlns CDATA #FIXED ''>
<!ELEMENT salary (#PCDATA)>
<!ATTLIST salary
xmlns CDATA #FIXED ''>
<!ELEMENT company_city (#PCDATA)>
<!ATTLIST company_city
xmlns CDATA #FIXED ''>
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.