<?xml version='1.0' encoding='UTF-8' ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
        xmlns:dt="urn:schemas-microsoft-com:datatypes"
        xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<ElementType name="title" sql:relation="titles">
	<AttributeType name="title" dt:type="string"/>
	<AttributeType name="type" dt:type="string"/>
	<attribute type="title" sql:field="title"/>
	<attribute type="type" sql:field="type"/>
</ElementType>
<ElementType name="author" order="many" sql:relation="authors">
	<element type="title" maxOccurs="*" >
          <sql:relationship key="au_id" key-relation="authors"
                        foreign-key="au_id" foreign-relation="titleauthor" />
          <sql:relationship key="title_id" key-relation="titleauthor"
                        foreign-key="title_id" foreign-relation="titles" />
        </element>
	<AttributeType name="au_lname" dt:type="string"/>
	<AttributeType name="au_fname" dt:type="string"/>
	<attribute type="au_lname"/>
	<attribute type="au_fname"/>
</ElementType>
</Schema>