LISTING 5: XSD Mapping Schema

<schema xmlns="http://www.w3.org/2001/xmlschema"
        xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
  <element name="author" sql:relation="authors">
	<complexType>
	  <sequence>
		<element name="title" sql:relation="titles">
		  <annotation>
			<appinfo>
			  <sql:relationship parent-key="au_id" parent="authors"
				  child-key="au_id" child="titleauthor" />
			  <sql:relationship parent-key="title_id" parent="titleauthor"
					child-key="title_id" child="titles" />
			</appinfo>
		  </annotation>
		  <complexType>
			<attribute name="title" type="string"/>
			<attribute name="type" type="string"/>
		  </complexType>
		</element>
	  </sequence>
	  <attribute name="au_lname" type="string"/>
	  <attribute name="au_fname" type="string"/>
	</complexType>
  </element>
</schema>