Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a XSD schema document for the XML below in which the conditions described below: Field Name: Data definition. Gnumber: A string starting with letter

Create a XSD schema document for the XML below in which the conditions described below:

Field Name: Data definition.

Gnumber: A string starting with letter G and followed by 8 digits for example G12345678.

Residence status: Can be either "In-state" or "Out-of-state"

First name: A string of letters or hyphen of length less than 20 (no other chars is allowed)

Middle initial: Can be 1 letter or empty

Last name: A string of letters or hyphen of length less than 20 (no other chars is allowed)

Student DOB: Between 01/01/1970 and 12/31/2000 inclusive

Program name: Can be one of the following choices: MS Health Informatics, Graduate Certificate in Health Informatics, MS Health Management, MS Senior Living, PhD in Health Services Research

Concentration: Optional element. For MS Health Informatics program has two possible concentrations: Data analytics and Information Management.

Start year: Between 2014 and 2017 inclusive.

Course: For each student, the number of courses taken should not exceed 15. Each course is described with the following data: department code, catalog number, semester, year, and letter grade. All the information must be present.

Department: Can be one of the following values: HAP, NURS, NUTR, MATH, INFS, STAT, SWE, ECON and EPID.

Catalog number: A number between 500 and 999

Semester: Can be one of three values: Spring, Summer, Fall

Year: A number between 2014 and 2017 inclusive

Letter grade: Can be one of the following: A+, A, A-, B+,B, B-, C, F and INCOMP

-- XML --

G12654312

In-state

ALBERTO

L

SMITH

2/3/1981

MS Health Informatics

Data analytics

2014

HAP | INFS

463|700|721|789

SPRING | FALL

2014 | 2016

B+ | A

G1265483

In-state

ABRAHAM

E

JOHNSON

1/15/1982

MS Senior Living

2013

NURS

678

FALLS

2013

B

G1265548

In-state

ADRIAN

T

WILLIAMS

8/30/1994

PhD in Health Services Research

2016

NURR

529

SUMMER

2016

A

G1265605

Jn-state

AHMED

T

BROWN

3/4/1990

MS Health Informatics

Information management

2014

HAP

721

SPRING

2014

A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Microsoft SQL Server 2012 Programming

Authors: Paul Atkinson, Robert Vieira

1st Edition

1118102282, 9781118102282

More Books

Students also viewed these Databases questions

Question

=+iv. Simple promise No ordinary airline (Virgin Atlantic Airway).

Answered: 1 week ago