Assignment 4: XML Documents and Schema Definitions

Assignment 4:
XML Documents and Schema Definitions

Project 1: XML Document
Assignment Four will demonstrate the use of XML documents in transferring data. This will entail
creating and validating an XML and XSD file and then upload that file to MS Access. Once
successfully uploaded, the database will be completed by enforcing the referential integrity of the
tables.
Your product has been a great success. Sales have grown and your company has grown to match.
You now have moved out into a building to accommodate all the employees you have hired.
And of course, you are great boss. You recognize that most of your employees are millennials and
they expect more than just salary for job satisfaction. Besides daily affirmations that they are the
greatest employees in the whole of the world, they expect a minimal level of perks and awards.
To this end, one of the perks you provide a weekly ‘Friday Lunch Extravaganza’ including free lunch.
You order in a lunch every week from restaurants suggested by your employees.
To this end, you keep a list of all the restaurants that you order from.
So, you will create an XML document and an accompanying XSD Schema definition file so you can
upload the data to your MS Access database. You will start out by importing the three (3) restaurants
in this list as a ‘proof of concept’.
Using a flat text editor (either: Brackets –or- NotePad++) you create an NEW XML data document.
You are given all the data required to fill in to your XML document in a text file called:
XML_Data.txt
(note: you must upload ALL the characters exactly as they appear in the file – no changes)
So, quotation marks and punctuation must match what is in the file.
The data in XML_Data.txt is put into your XML file and MUST be structured with the following
specifications:
Restaurant Name (mandatory) and Restaurant ID (Primary Key to identify each – must be text)
Cuisine (what type of food does the restaurant serve - mandatory)
List of Menu Items (mandatory)
this list contains two data points: Item Type (i.e., Sushi) and Item Name (I.e. Crab)
hint: ALSO - each item on this list will have a Restaurant Association ID
(mandatory – must match the Restaurant ID above)
Delivery Cost (optional)
Number of times we ordered from that restaurant (mandatory)
List of Employees that have ordered from that restaurant
this list contains the data point of the Employee ID that ordered from this restaurant in the past.
(mandatory – at least one (1) but no more than ten (10) employees allowed in this list)
(you MUST use values from your existing database from Assignment Three
hint: ALSO - each item on this list will have a Restaurant Association ID
(mandatory – must match the Restaurant ID above)
Phone Number (mandatory – no dash or brackets – might start with area code 012)
Current (i.e. do you still order from this restaurant - mandatory
– MUST be either ‘true’ or ‘false’ - can not be text or number)
Note: the tag for the major Restaurant’s groupings must have a tag attribute indicating the
Preference of each restaurant as demonstrated in the notes.

The assigned Preference number is also in the XML_Data.txt file before each major grouping.
hint: make sure you read Project 2 before starting.
hint: create the XML file with only ONE (1) Restaurant (use the XMLData_1restaurant.txt file).
test (validate) syntax of the XML file
ONLY after syntax check of the XML file, then create the XSD schema based on the XML file
with only this ONE (1) restaurant.
ONLY after the schema validates the XML then add the other two (2) Restaurants
[ONE AT A TIME] and retest each time.
hint: Read the Assignment 4 MUST READ.pdf file for more suggestions.
This document MUST be validated by the schema in Project 2 by including the following line in your
XML document:
<rootName xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="yourFileName.xsd"
where rootName is the name of the root of your XML document and yourFileName is the name of the
actual XSD Schema document you created in Project 2.
Your XML document must be a text file (NOT a Word Document) saved and submitted as an XML
file (it MUST be a file with the extension .xml). Files with .doc or .txt extension will lose major marks.
The file name must be youraccountname_Restaurants.xml
For example: jdoe3_Restaurants.xml
Note: Tutorials on HTML and XML are available at http://www.w3schools.com.
(HINT: Follow the steps from the class notes – especially in regards to the XML tags)
read the Assignment 4 MUST READ.pdf document.
NOTE: Your XML file must validate, otherwise it cannot be uploaded into MS Access as required in
Project 3. You will lose major marks if it does not validate. In past semesters students expressed
confusion over this requirement. It must be valid as per the validation web site referenced below in
these instructions. No exceptions - even regardless of what a TA may or may not say.
If you are unclear about the ‘must validate’ requirement, please contact me and I will be glad to give a
further definition. I do not want the students to be unclear or feel that this has not been specified in
advance.
You must use the XMLValidation site below. It provides more details on error messages:
http://www.xmlvalidation.com
– it does not matter if another site says it is valid. This site only.
Your XML must be valid as per this web site. Run your XML file and Schema through this site.
(ensure you check the ‘Validate against external XML schema’ box on this page).
If this web site shows errors on your XML or Schema, you will lose almost all of the marks. Again,
contact me, or leave a message in the FORUMS in OWL if this is unclear.
IMPORTANT :
You must identify yourself in the XML documents (BOTH the XML and XSD). Somewhere
towards the top (beginning) in the actual submitted XML and XSD files you must include:
- your first and last name
- your Western ID (see below for a description of your Western ID)
- your student number
- the Date you completed the XML document
Your name and student Number and Student ID MUST MUST MUST appear in both (XML and XSD)
documents or You will lose major marks on this project !!!
– NO EXCEPTIONS.
NOTE: Your XML file must validate, even after you add your name and ID to the document,
otherwise it cannot be uploaded into MS Access as required in Project 2. You will lose major marks if
it does not validate. In past semesters students expressed confusion over this requirement. It must
be valid as per the validation web site referenced below in these instructions. AND! This can NOT be
data. It can NOT be uploaded as part of your database.
STOP and think about how to add your name and ID inside the XML document where it is not data
AND still have the XML validate! (hint: review the notes…)
Adding your identification incorrectly will result in the loss of major marks.
Your XML document must be a FLAT text file (NOT a Word Document (.doc) not a Text (.txt)
Document ) saved and submitted as an XML file (it MUST be a file with the extension .xml).
Files with a .doc or .txt extension will lose major marks.
Project 2: XML Schema
Using a text editor (either: Brackets –or- NotePad++) create an XML Schema (.xsd) document that
will validate the Project 1 XML file you created.
Create the XML Schema using the information from your XML document,
The schema document needs to be designed to define your XML document in Project 1.
The data types must match the specifications on page one (1) of this assignment.
Your schema definition must be a flat text file (NOT a Word Document) saved and submitted as an
XML Schema Definition file (an .xsd file – files with a .doc or .txt extension will lose major marks).
The file name must start with your accountname followed by an underscore and then the word
‘Restaurants’
For example: jdoe3_Restaurants.xsd
IMPORTANT :
You must identify yourself in the XML documents (BOTH the XML and XSD). Somewhere
towards the top (beginning) in the actual submitted XML and XSD files you must include:
- your first and last name
- your Western ID (see below for a description of your Western ID)
- your student number
- the Date you completed the XML document
Your name and student Number and Student ID MUST MUST MUST appear in both (XML and XSD)
documents or You will lose major marks on this project !!!
– NO EXCEPTIONS.
You must use the XMLValidation site below. It provides more details on error messages:
http://www.xmlvalidation.com – it does not matter if another site says it is valid. This site only.
Your XML Schema must be valid as per this web site. Run your XML file and XML Schema through
this site (ensure you check the ‘Validate against external XML schema’ box on this page).
If this web site shows errors on your XML or Schema, you will lose major marks. Again, contact me,
or leave a message in the FORUMS in OWL if this is unclear.
Your XSD document must be a FLAT text file (NOT a Word Document (.doc) not a Text (.txt)
Document ) saved and submitted as an XML file (it MUST be a file with the extension .xsd).
Files with a .doc or .txt extension will lose major marks.
Project 3: Upload your XML Document into YOUR MS Access Database
Import your valid and syntactically correct XML document into the MS Access data base you created
in Assignment Three:
Make a copy your Assignment 3 file youraccountname_business.accdb to:
youraccountname_business_part2.accdb
Use the built in XML Import Utility found under the External Data tab.

Upload your XML document with the three (3) Restaurants into your existing database:

youraccountname_Restaurants.xml (where youraccountname is YOUR UWO User ID)
Once the three (3) tables are uploaded successfully from your XML document:
Use the Relationships utility in Database tools to create a relationship between the existing tables and
the new imported tables (RESTAURANT to MenuItem -and- RESTAURANT to EmployeeOrdered -
and- EMPLOYEE to EmployeeOrdered) and then enforce referential integrity with this tool.

hint: you will need to manually make changes to the Restaurant table before you can enforce
referential integrity. Think about how referential integrity works and look at the Properties view of
each of these tables.

hint: sometimes MS Access will incorrectly import an XML Integer data type as a Double.
you may have to manually change any XML Integer value to an Integer type in Access.
Project 4: Final Exam Multiple Choice Questions
Write five (5) multiple choice questions you think would be appropriate for the final exam. Base these
questions on material covered in the slides or in class.
• Ensure that each multiple choice question has five choices
• Ensure that the majority of questions are framed in a positive context
(do not use questions that ask “Choose the option that does not belong)
• Avoid using “all of the above” or “none of the above” answer options, or answers
consisting of specific option numbers as possible responses.
• Provide the correct answer for each question.
This will help the professor to gage the level of difficulty expected by the students and will
demonstrate the students proficiency in the material.
( …and, if I use your question(s) you will already know the answer(s) )
The format of this document should be identical to format you used in Assignment One (1).
Place your name, followed by the company name at the top.
At the end of the document, include your name, Student number and Western ID (the first part of your
Western email (i.e. if your email is – dernt373@uwo.ca your ID will be – dernt373)
Formatting is not important as long as the document is easy to follow:
This document must be a Word file saved and submitted as a .doc (or .docx) file
The name must be a combination of your Western Account Name and the name of your company.
The file name must be youraccountname_companyname_A4.doc (or .docx)
- example (from above) dernt373_MaggicSoftware_A4.docx
Submission Instructions:
You must upload and submit, via the CS1032 Web Site, the following four (4) files:
youraccountname_Restaurants.xml
youraccountname_Restaurants.xsd
youraccountname_business_part2.accdb (.mdb for Access 2003 or earlier)
youraccountname_companyname_A4.docx (.doc for Word 2003 or earlier)
(remember to check your file names. They MUST match the required conventions above.)
(if you submit files with incorrect extensions (for example: .txt) you will lose marks ! )