[Solved] CSIT128 Assignment 6

Task 1

1. Read the situation below and prepare XML document to store relevant data.

The patient at INTI hospital receives medications prescribed by the doctor(s). The patient is described by their unique medical number, first name, last name, gender and medication received. The patient can receive one or many medications in a day. The medication is described by the name, company manufacture and drug registration number. The patient may be treated by one or more doctor. The doctor can be recognized by their registered number, their first name, last name and specialization.

1. Additional requirement:
   1. Provide at least THREE (3) sample data for patient, doctor and medication.
   2. Use IDREF to reference between patient, doctor and medication.

• Store data about gender and IDREF in XML attribute.

1. Use XML entity to store doctors specialization.

Task 2

1. From your XML document in Task 1, create a DTD document.
2. Use the XML Exchanger Editor to help validate DTD document.

Task 3

1. Based from your XML in Task 1, create XML Schema document.
2. Use the XML Exchanger Editor to help validate XML Schema document.

Task 4

1. Prepare XSLT document to display the XML data (from Task 1). Read the following requirements, and include them in your XSLT.
   1. Prepare THREE different table to display data about patient, doctor and medication.
   2. Sort the patients table by their last name.

• Sort the doctors table by the doctors registration number.

1. Sort the medications table by the registration number (in descending order).
2. Change the background color for each Table heading. Use three different color.
3. Display the doctors first name and last name in a single column.

• If the patient being treated by more than one doctor/ received more than one medication, then include a comma (,) to separate each data.