1. Homepage
  2. Programming
  3. CHC5049 Database Coursework 1: Define Data Application

CHC5049 Database Coursework 1: Define Data Application

Engage in a Conversation
Oxford BrookesCHC5049DatabaseSQLDTDXSLT

CHC5049 Database Coursework 1. CourseNana.COM

Learning Outcomes CourseNana.COM

The two coursework of this module address the following learning outcomes: CourseNana.COM

  • -  Use SQL and XML to define data applications appropriate to a specified problem. CourseNana.COM

  • -  Use a conceptual modeling language to specify and analyze data requirements and apply CourseNana.COM

    database design principles to map system requirements to an efficient (e.g., normalized) CourseNana.COM

    database. CourseNana.COM

  • -  Explain and design transaction-based processing in database systems. CourseNana.COM

  • -  Exploit techniques for storing and querying XML data. CourseNana.COM


    COURSEWORK OUTLINE CourseNana.COM

    A leading multinational corporation with a diverse portfolio of businesses is seeking to enhance its data management and integration capabilities by developing a comprehensive online platform to manage employee and organization information. The company has a vast workforce spread across multiple regions, departments, and subsidiaries, making it crucial to have a centralized system for efficiently managing employee and organizational data. The company has adopted the XML format for efficient data management. They require the information to be consolidated into a single XML document structured by the organization to streamline the process further. Within each organization element, the employee details should be included, ensuring seamless organization and accessibility of the data. CourseNana.COM

    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 given information should also be consolidated into a single JSON document following the above criteria for further in-depth analysis and exploration. CourseNana.COM

DELIVERABLES [20 marks total] CourseNana.COM

You have been asked to:
1) Spot the errors in the given
Organizations_sample.dtdfile. You should provide: CourseNana.COM

a. b. c. CourseNana.COM

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.
A corrected version of the external DTD file. The file should be called
2_Corrected_sample.dtd. CourseNana.COM

Provide a screenshot called 3_Validation_sample.jpegafter validating the Organizations_sample.xmlfile against the corrected external DTD through a validator, proving that they validate with no errors. CourseNana.COM

2) 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 (‘Organizations.xml’ and ‘Employees.xml’) supplied by the company. The following specifications must be followed: CourseNana.COM

a. XML: CourseNana.COM

  1. The XSL file must be called ‘4_Transformation_to_XML.xsl’. CourseNana.COM

  2. It must use XSLT v1.0 as requested by the company. CourseNana.COM

  3. You have to provide comments to explain your reasoning and work. CourseNana.COM

  4. The XML output file must contain a root element called ’eCorporation’. CourseNana.COM

  5. The XML file should contain the organization and the relevant employee data CourseNana.COM

    ordered by the country and then by the organization. CourseNana.COM

  6. The XML file that is provided must be called 5_Output.xml.’ CourseNana.COM

  7. A related external DTD must be automatically referenced in the output.xml file and not be manually added. CourseNana.COM

  8. DTD Details:
    Create a new external DTD file that describes the output XML file. So that the company can validate the XML output file and ensure it is correct. The DTD must adhere to the following requirements:
    CourseNana.COM

1. It must follow a logical structure of the data as follows: CourseNana.COM

eCorporation Country CourseNana.COM

Organization
... Organization details
CourseNana.COM

Employees
... Employee details
CourseNana.COM

Employees
... Employee details
CourseNana.COM

Organization
... Organization details
CourseNana.COM

Employees
... Employee details
CourseNana.COM

Employees
... Employee details
CourseNana.COM

Country Organization CourseNana.COM

... Organization details Employees CourseNana.COM

... Employee details Employees CourseNana.COM

... Employee details CourseNana.COM

  1. Well-written external DTD structure. CourseNana.COM

  2. Logical naming convention of elements and attributes. CourseNana.COM

  3. Nested elements correctly declared. CourseNana.COM

  4. At least one attribute should be used. CourseNana.COM

  5. The DTD file must be called 6_Structure.dtd. CourseNana.COM

  6. It should be validated against the output XML file through a validator, and CourseNana.COM

    a screenshot called 7_Validation_XML.jpegshould be attached, showing that they validate with no errors. CourseNana.COM

b. JSON: CourseNana.COM

  1. The XSL file must be called ‘8_Transformation_to_JSON.xsl’. CourseNana.COM

  2. You have to provide comments to explain your reasoning and work. CourseNana.COM

  3. Ensure that the content of the JSON file accurately represents the data from CourseNana.COM

    the XML files and save the converted file as '9_Output.json'. CourseNana.COM

  4. Validate the JSON file, capture a screenshot of the validation, and save it as CourseNana.COM

    '10_Validation_json.jpeg' to demonstrate that the file has no errors. CourseNana.COM

Submission bundle CourseNana.COM

The specification for the structure of the submission is as follows: CourseNana.COM

  1. A ZIP file uploaded via the online portal. CourseNana.COM

  2. The ZIP bundle must be named coursework1_StudentID.zip. CourseNana.COM

  3. File names must be EXACT, including the specified file extension. CourseNana.COM

Get in Touch with Our Experts

QQ QQ
Wechat WeChat
Whatsapp Whatsapp
Oxford Brookes代写,CHC5049代写,Database代写,SQL代写,DTD代写,XSLT代写,Oxford Brookes代编,CHC5049代编,Database代编,SQL代编,DTD代编,XSLT代编,Oxford Brookes代考,CHC5049代考,Database代考,SQL代考,DTD代考,XSLT代考,Oxford Brookeshelp,CHC5049help,Databasehelp,SQLhelp,DTDhelp,XSLThelp,Oxford Brookes作业代写,CHC5049作业代写,Database作业代写,SQL作业代写,DTD作业代写,XSLT作业代写,Oxford Brookes编程代写,CHC5049编程代写,Database编程代写,SQL编程代写,DTD编程代写,XSLT编程代写,Oxford Brookesprogramming help,CHC5049programming help,Databaseprogramming help,SQLprogramming help,DTDprogramming help,XSLTprogramming help,Oxford Brookesassignment help,CHC5049assignment help,Databaseassignment help,SQLassignment help,DTDassignment help,XSLTassignment help,Oxford Brookessolution,CHC5049solution,Databasesolution,SQLsolution,DTDsolution,XSLTsolution,