How to model data in XML?

[Adam Retter]

I am storing information about community groups. Each group has an XML file
in a collection in eXist.

For each community group I need to be able to store its template type and
then a set of information about services provided.

Each template type has a different set of associated ServiceGroup's.
Each ServiceGroup has a different set of Service's.
Each Service has a different set of possible values.

The original data held in SQL Server looks like this -

Temlate Type Goup Name
Service Name Service Value
=============== =============== =============== =============== =============== =======
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Carers" Yes
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Carers" No
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Carers" Unknown
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Adults" Yes
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Adults" No
"Adaptation s and Maintenance Services" "Beneficiar ies"
"Adults" Unkown
"Adaptation s and Maintenance Services" "Delivery"
"Schedule" Yes
"Adaptation s and Maintenance Services" "Delivery"
"Schedule" No
"Adaptation s and Maintenance Services" "Delivery" "ID
Required" Yes
"Adaptation s and Maintenance Services" "Delivery" "ID
Required" No
"Complement ary Health" "Terms"
"Disclaimer " Yes
"Complement ary Health" "Terms"
"Disclaimer " No
"Complement ary Health" "Terms"
"Disclaimer " Required
"Complement ary Health" "Specialism s"
"Massage" Shiatsu
"Complement ary Health" "Specialism s"
"Massage" Amma
I was thinking of this structure -

<communitygroup >
<services type="templateN ame">
<group name="servicegr oupName1">
<service name="ServiceNa me1">ServiceVal ue1</service>
<service name="ServiceNa me2">ServiceVal ue2</service>
</group>
<group name="servicegr oupName2">
<service name="ServiceNa me3">ServiceVal ue3</service>
</group>
</services>
</communitygroup>

Thee thing I am strugling with is modelling a Schema to fit this, so far I
have -

<xs:simpleTyp e name="groupType ">
<xs:restricti on base="xs:string "/>
</xs:simpleType>
<xs:simpleTyp e name="servicesT ype">
<xs:restricti on base="xs:string ">
<xs:enumerati on value="Adaptati ons and
Maintenance Services"/>
<xs:enumerati on value="Compleme ntary Health"/>
<xs:enumerati on value="Counsell ing and
Therapy"/>
<xs:enumerati on value="Day Care Services"/>
<xs:enumerati on value="Educatio n Services"/>
<xs:enumerati on value="Equipmen t"/>
<xs:enumerati on value="Groups - Services"/>
<xs:enumerati on value="Healthca re services"/>
<xs:enumerati on value="Holidays "/>
<xs:enumerati on value="Home Care Services"/>
<xs:enumerati on value="Housing Providers"/>
<xs:enumerati on value="Meal Delivery Services"/>
<xs:enumerati on value="Mobility and Transport
Services"/>
<xs:enumerati on value="Provisio ns Delivery"/>
<xs:enumerati on value="Resident ial and Nursing
Care"/>
</xs:restriction>
</xs:simpleType>
<xs:element name="services" minOccurs="0">
<xs:complexType >
<xs:sequence>
<xs:element name="group"
maxOccurs="unbo unded">
<xs:complexType >
<xs:sequence>
<xs:element name="service"
maxOccurs="unbo unded">
<xs:complexType >
<xs:attribute
type="xs:string "
name="name"
use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name"
type="groupType " use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="type"
type="servicesT ype" use="required"/>
</xs:complexType>
</xs:element>
Now the problem that I have is that I want to be able to restrict the value
of the "group" elements "name" attribute based on the value of the
"services" elements "type" attribute. For example if the services type
attribute is "A" then the group name attribute can only be "X", "Y" or "Z".
Whilst if the services type attribute is "B" then the group name attribute
can only be "M", "N" or "O".

Any help or suggestions about how to hold such data in an XML format would
be greatly appreciated...

Thanks
--
Adam Retter
Devon Portal Technician

Devon Portal Project
Devon e-Partnership
County Hall
Exeter
Devon, UK.