[SOLVED] Chc5049 database coursework 1. p0

Learning Outcomes
The two coursework of this module address the following learning outcomes:
– Use SQL and XML to define data applications appropriate to a specified problem.
– Use a conceptual modeling language to specify and analyze data requirements and apply database design principles to map a set of system requirements to an efficient (e.g., normalized) database.
– Explain and design transaction : -based processing in database systems.
– Exploit techniques for storing and querying XML data.

IMPORTANT INFORMATION
– This coursework is to be carried out individually.
– You have been given one DTD file (transactions_sample) and three XML files
(transactions_sampleQQ: 749389476, retail_customers, and retail_transactions) to be used for the coursework.

COURSEWORK OUTLINE
You work for a company that has a large visitor attraction with several gift shops located on-site. The retail system creates a list of transactions made. The company has engaged a 3rd party vendor to do data analysis who has requested that they be sent the transaction data combined with the customer data. The data is to be sent as XML files. It is decided to create a single submission file that can be uploaded via FTP (the files will be dropped into an FTP folder on the client’s server) to both systems.
The company is now looking to employ the advantages of the JSON format to enhance data management, interoperability, and seamless integration with various systems across the company. Accordingly, the information should also be consolidated into a single JSON document following the above criteria for further in-depth analysis and exploration.

You have been asked to:
1) Spot the errors in the given ‘transactions_sample.dtd’ file. You should provide:
a. An image of the DTD with the errors circled in red, along with a brief note of each error.
The file should be called ‘1_DTD_sample_Errors.jpeg’.
b. A corrected version of the external DTD file. The file should be called
‘2_Corrected_sample.dtd’.
c. Provide a screenshot called ‘3_Validation_sample.jpeg’ after validating the
‘transactions_sample.xml’ file against the corrected external DTD through a validator, proving that they validate with no errors : .

2) Submit two XSLT transformation and output files, one to export the XML data, and the other to export the JSON data. Your XSLT files must be correctly formatted and be able to run against the XML files (retail_customers, and retail_transactions) supplied by the
company. The following specifications must be followed:

a. XML:
I. The XSL file must be called ‘4_Transformation_to_XML.xsl’. II. It must use XSLT v1.0 as requested by the company.
III. You have to provide comments to explain your reasoning and work.
IV. The XML output file must contain a root element called ’Transactions’.
VI. The provided XML file must be called ‘5_Output.xml.’
VII. A related external DTD must be automatically referenced in the output.xml file and not be manually added.
VIII. DTD Details:
Create a new external DTD file that describes the output XML file. So that the 3rd party vendor can validate the XML output file and ensure it is correct. The DTD must adhere to the following requirements:
1. It must follow a logical structure of the data as follows:
Transactions
Shop
Transaction
…Transaction and customer details
Transaction
…Transaction and customer details
Transaction
…Transaction and customer details
Shop
Transaction
…Transaction and customer details
Transaction
…Transaction and customer details

2. Well : -written external DTD structure.
3. Logical naming convention of elements and attributes.
4. Nested elements correctly declared.
5. At least one attribute should be used.
6. The DTD file must be called ‘6_Structure.dtd’.
7. It should be validated against the output XML file through a validator, and a screenshot called ‘7_Validation_XML.jpeg’ should be attached, showing that they
validate with no errors.

b. JSON:
I. The XSL file must be called ‘8_Transformation_to_JSON.xsl’.
II. You have to provide comments to explain your reasoning and work.
III. Ensure that the content of the JSON file accurately represents the data from the XML files and save the converted file as ‘9_Output.json’.
IV. Validate the JSON file, capture a screenshot of the validation, and save it as ’10_Validation_json.jpeg’ to demonstrate that the file has no errors.

Submission bundle
The specification for the structure of the submission is as follows: a.
A ZIP file should be uploaded via the online portal.
b. The ZIP bundle must be named ‘Coursework1_StudentID.zip.’
c. File names must be EXACT, including the specified file extension.

JPEG file Image with DTD errors + errors description 1_DTD_sample_Errors.jpeg 2
DTD file Your corrected DTD file 2_Corrected_sample.dtd 2
JPEG file Image of your XML validation 3_Validation_sample.jpeg 1
XSL file Your XSL to XML transform file 4_Transformation_to_XML.xsl 4
XML file The result :
cstut of your XML transform orcs5_Output.xml 1
DTD file The DTD that validates the XML output file 6_Structure.dtd 3
JPEG file Image of your XML validation 7_Validation_XML.jpeg 1
XSL file Your XSL to JSON transform file 8_ Transformation_to_JSON.xsl 4
JSON file The result of your JSON transform t Project Exa
p9_Output.json 1
m
JPEG file Image of your JSON validation 10_Validation_json.jpeg 1

程序代写代做 CS 编程辅导