代写XML Documents、代做HTML/CSS语言、代写HTML/CSS/web设计、代做Schema Definitions

日期：2018-11-08 10:06

Assignment 4:

XML Documents and Schema Definitions

Due Date: Wednesday, November 07 by 6:00 pm.

Late Policy: This assignment will be accepted up to one (1) day late.

Assignments submitted after Nov 07 at 6:00 PM but before Nov 08 at 6:00 AM

will be deducted 10% of the total grade.

Assignments submitted after Nov 08 at 6:00 AM but before Nov 08 at 6:00 PM

will be deducted 25% of the total grade.

Assignments submission will be closed at 6:00 PM on Nov 08

and no assignments can be submitted to OWL after that time.

PLEASE READ ALL ( EVERY ONE ) OF THE INSTRUCTIONS CAREFULLY !!!!

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.

You have a list of all the companies that supply you the materials you use in your business.

This list is comprised of a flat text file that contains over 100 suppliers. Obviously, you do not want to

type them all into your database.

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 just importing the first four (4)

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

XMLData.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 XMLData.txt is put into your XML file and MUST be structured with the following

specifications:

Supplier Name (mandatory)

Supplier ID (Primary Key to identify each supply company entry – must be text)

Street (optional)

City (optional)

Province (optional)

Postal Code (optional)

Sales Person Data (mandatory – at least one (1) but no more than six (6) persons allowed)

Last Name (mandatory)

First Name (mandatory)

Phone Number (mandatory – no dash or brackets – might start with area code 012)

Supplier ID Association (mandatory – must match the Supplier ID above)

Supplier Rating (mandatory – number between 0.0 and 10.0 – can have decimals i.e. 4.3)

Material ID (mandatory – MUST match one of your Material IDs from your Assignment Two)

Active (mandatory – MUST be true/false - cannot be text or number)

Note: the tag for the major supplier’s groupings must have an optional tag attribute indicating the

Order of Preference as demonstrated in the notes.

The assigned order number is also in the XMLData.txt file before each major grouping.

hint: make sure you read Project 2 before starting.

hint: create the XML file with only ONE (1) supplier (use the XMLData_1company.txt file).

test (validate) syntax of the XML file

ONLY after syntax check create the XSD schema based on the XML file with ONE (1) supplier.

ONLY after the schema validates the XML then add the other three (3) suppliers

[ONE AT A TIME] and retest.

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_suppliers.xml

For example: jdoe3_suppliers.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

‘vendors’

For example: jdoe3_suppliers.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 four (4) suppliers into your existing database:

youraccountname_suppliers.xml (where youraccountname is YOUR UWO User ID)

Once the two 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 (SUPPLIER to SALESPERSON -and- SUPPLIER to MATERIALS) and then

enforce referential integrity with this tool.

hint: you will need to manually make changes to the Supplier table before you can enforce referential

integrity. Think about how referential integrity works and look at the Properties view of each of these

tables.

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_suppliers.xml

youraccountname_suppliers.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 ! )

AND PLEASE: Do not cheat or copy.

It takes up a lot of time and energy going through the, ‘no, I did not phase’

followed by the ‘okay, but I need a break phase’

to finally the ‘what if I promise never to do it again phase’.