Question: A. Create schema for the below XML Patient Lab records. See below the XML file. Create a schema to detect errors in the XML file.

A. Create schema for the below XML Patient Lab records. See below the XML file.

  1. Create a schema to detect errors in the XML file.
  2. Run the schema to detect the errors (submit a screenshot of the validation)
  3. Fix the errors and re-run the validation against a schema (submit screenshot)

The constraints that must be described are

  • Patient info must include "mrn" attribute.
  • The name includes 3 parts
    • First name (must be present)
    • Middle name (optional - some folks do not have middle names)
    • Last name (must be present)
    • The length of name components (first or middle or last) cannot be more than 50 chars
  • The medical test should be one of three choices: Blood, Stool, and Sputum.
  • DOB
    • The day should be in the range of 1-31
    • The month should be in the range of 1-12
    • Year should be in the range from 1900 to 2016
  • Test cost is a positive number and less than 10,000

XLM code:

John

F

Robertson

12

1

1990

Blood

10/10/2009

2000

Jack

Smith

30

12

1900

Stool

12/01/1999

2000

Smith

33

12

1800

Sputum

12/01/1999

20000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!