An external private DTD to describe pteputputXPAL file that can be used by the r° party vendor to validate: Databases Coursework, TUE, UK

Learning Outcomes
1 Use SOL and XML to define data applications. appropriate to a specified problem

2 Use a conceptual modeling language to specify and analyze data requirements and apply the principles of database design to map a set of system requirements to an efficient (e.g. normalized)database

3 Explain and design transaction-based processing in database systems

4 Exploittechtiiquesforstoring and querying XML data

1) An external private DTD to describe the pteputput XPAL file that the r° party vendor can use to validate the XML p913,02, logical structure of the data should be as follows:

The DTD must adhere to the klisudamsuotOcetRU

• Well-structured DTD file
• The logical naming convention of elements and attributes
• Nested elements correctly declared
• Logical element cardinality set throughout
• The whole of the DTD must be contained in a single file called ‘transactions  At least 2 attributes and an entity were used.

2) Discuss the following key issues that could apply to the system above.

a. Discuss what data protection legal issues the company needs to consider in creating this system and mention anyways these risks can be mitigated. In your discussion, consider the impact that leaving the European(aa, and the effects that Covid-19 has had on working conditions, may have on the company’s data operations.

b. Analyse the benefits and limitations of XML and JSON, considering the data to be transmitted and the distribution methods note that you do not need to decide which is ‘best’).