Reference no: EM13189374
Introduction
This is an individual assignment in which you can explore the use of extensible files in web programming, using PHP and XML.
Details of the weight of the assignment and due date are given in the course description.
Task Description
Introduction
A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour. There are constraints placed on the data that are described below.
The assignment tasks are closely associated with the lab work of topics 8 to 10. Code which is provided in the topic 10 lab work should be a useful guide throughout this assignment. The assignment requires a number of files and a report to be produced. The report should respond to written tasks that are included below.
Initial task
Document the data that you have chosen by adding a table to your report. The table should have about 6 records with no NULLs. Document also the names of the table and the fields.
Tasks supported by Topics 7 and 8
Mark up the table of data using XML tags and save it as an .xml file. Check that the file is well-formed and report the method used. Make a deliberate error and report the error message.
Create a corresponding XMLSchema file (.xsd) that contains the following constraints:
• the car registration number consists of 3 uppercase alphabetic letters, followed by a hyphen and 3 digits;
• the year of manufacture is between 1995 and 2013 inclusive
• for the purposes of this exercise, the colour is restricted to red, white, black and silver
Use the .xsd file to validate your .xml file. Test the validation of the .xml file by breaking each constraint in turn and report the results. Also deliberately invalidate the .xml file and report the response.
Task supported by Topic 9
Create an XSLT stylesheet file (.xsl) that supports the display of the data. The data is to be displayed in alphabetic order of car make.
Task supported by Topic 10
Create new DOM documents for each of your .xml file and .xsl file. Use these to generate output to the
browser. Comment on the result.
|
How many cartons were left over
: Juan's first-grade class received 82 half-pint cartons of milk to distribute evenly to his 22 students. How many cartons were left over?
|
|
What are the dimensions of the corral of maximum area
: a rancher wishes to enclose a rectangular corral with 320 feet of fencing. the fencing only required 3 sides because of an existing wall. what are the dimensions of the corral of maximum area?
|
|
Compute a consumer price index for apples for each year
: Abby consumes only apples. In year 1, red apples cost 1$ each, green apples 2$ each, and Abby buys ten red apples. In year 2, red apples cost $2, green apples cost $1, and Abby buys 10 green apples.
|
|
What was the amount of each loan
: Cole's student loans totaled $31,000. One of his loans was at 2.8% simple interest and the other at 4.5%. After one year, Cole owed $1024.40 in interest. What was the amount of each loan.
|
|
Create a corresponding xmlschema file
: A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour
|
|
What is the volume in cubic centimeters of a tablet
: what is the volume in cubic centimeters of a tablet weighing 330mg that has density of 1.40cm ?
|
|
Where the is curve and the lm curve are of normal shapes
: During the recent recession, when countries around the world suffered high unemployment rates and the governments were experiencing huge budget deficits, economists debated whether to raise or cut taxes or to raise or cut government spending.
|
|
Find the steady-state temperature at the center of the plate
: The rod satisfies the heat equation Ut = Uxx + f(x) and its ends are kept at zero temperature. Find the steady-state temperature.
|
|
Did the labor productivity ratio increase or decrease
: The ABC Company has a large order for special uniforms to be used in an urgent operation. Working the normal two shifts of 40 hours each per week, the ABC production process usually produces 2, 500 uniforms per week at a standard cost of $120 each..
|