Cart
[Home] [By Thread] [By Date] [Recent Entries]
Bill, What you are trying to do (enforce that there is at least one occurrence of element TableB whose "relationship" attribute value is "needed") cannot be done with W3C Schema. Someone will be along very shortly to describe how Schematron can enforce this. Kind Regards, Joe Chiusano Booz | Allen | Hamilton Bill Riegel wrote: > > I am trying to define a serialized Database to XML, via a XML Schema. > > Problem > > Table A has two relations two Table B. One is required the other is > optional. > > How do I define that the TableB with relationship="needed" is mandatory. > > I can define a unique constraint under TableA that indicates that > TableB/primaryKey be unique. This would prohibit someone defining > Two TableB's with the same relationship, i.e. two needed or two optional. > > But I do not know how to ensure there is a TableB with the relationship of > "needed". > > Instance Document: > > <TableA xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xsi:noNamespaceSchemaLocation="TestSchema.xsd"> > <primaryKey>xx</primaryKey> > <TableB relationship="needed"> > <primaryKey>yy</primaryKey> > </TableB> > <TableB relationship="optional"> > <primaryKey>yy</primaryKey> > </TableB> > </TableA> > > Schema Document > > <?xml version="1.0" encoding="UTF-8"?> > <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" > elementFormDefault="qualified" attributeFormDefault="unqualified"> > <xs:element name="TableA"> > <xs:complexType> > <xs:sequence> > <xs:element name="primaryKey"/> > <xs:element name="TableB" type="TableB_Type" maxOccurs="2"/> > </xs:sequence> > </xs:complexType> > </xs:element> > <xs:complexType name="TableB_Type"> > <xs:sequence> > <xs:element name="primaryKey" type="xs:string"/> > </xs:sequence> > <xs:attribute name="relationship"> > <xs:simpleType> > <xs:restriction base="xs:token"> > <xs:pattern value="needed|optional"/> > </xs:restriction> > </xs:simpleType> > </xs:attribute> > </xs:complexType> > </xs:schema> > > Bill Riegel > LandMark Graphics > 713-839-3388 > > ----------------------------------------------------------------- > The xml-dev list is sponsored by XML.org <http://www.xml.org>, an > initiative of OASIS <http://www.oasis-open.org> > > The list archives are at http://lists.xml.org/archives/xml-dev/ > > To subscribe or unsubscribe from this list use the subscription > manager: <http://lists.xml.org/ob/adm.pl> begin:vcard n:Chiusano;Joseph tel;work:(703) 902-6923 x-mozilla-html:FALSE url:www.bah.com org:Booz | Allen | Hamilton;IT Digital Strategies Team adr:;;8283 Greensboro Drive;McLean;VA;22012; version:2.1 email;internet:chiusano_joseph@b... title:Senior Consultant fn:Joseph M. Chiusano end:vcard
|
