[Solved] Assignment 8-2 SQL Lab 5: XML (25 points)

The purpose of this lab is to give you some experience in creating eXtensible Markup Language(XML) documents and Document Type Declaration (DTD) files.

Resources:

XML link: (XML stands for EXtensible Markup Language) http://www.w3schools.com/xml/default.asp

DTD link: http://www.w3schools.com/xml/xml_dtd_intro.asp

1- In this Lab, you are only creating the XML and DTD documents. There is no requirement to execute them.

2- Turn in 4 files: Part1.xml, Part2.dtd, Part3.xml & Part3.dtd. 1 Zip all files into a single submission and turn your zipped file into the drop box.

Part 1: Create a well-formed XML document that adheres to the following XML DTD called customer.dtd.

You should include at least 3 customers in your XML document (you will create the specific data associated with each customer). Use Notepad or WordPad and save your document as Part1.xml. 2 1 All of these files need to have the proper extension.

CUS_ID is a 4-digit number

CUS_DATEIN is the effective membership date of the customer in the company in <2-digit year> format CUS_STATE is a 2-character state abbreviation (all caps)

CUS_ZIP is a 5-digit zip code

CUS_PHONE is in the format xxx-xxx-xxxx

CUS_TAXID is a 9-digit number similar to a social security number (numbers only)

CUS_MBRTYPE can be any of these: DIAMOND, GOLD or SILVER

Part 2: Create the corresponding XML DTD document to which the following partial wellformed XML document adheres (first lines are missing) for Orders. Make sure to include the proper +, *, and ? signs when needed in your DTD. Use Notepad or WordPad and save your document as Part2.dtd.

Part 3: We need to store the following product inventory list in a well-formed XML document which adheres to a DTD. First, convert the table data into a well-formed XML document. Then, create the corresponding XML DTD document to which your created XML document adheres. Use Notepad or WordPad and save your documents as Part3.xml and Part3.dtd, respectively.

Resources: http://www.w3.org/TR/REC-xml http://www.w3schools.com/xml/default.asp http://www.w3schools.com/xml/xml_dtd_intro.asp http://web.archive.org/web/20050322041150/http://www.oracle.com/technology/oramag/oracle/03- may/o33xml.html This assignment is worth up to 25 points.