<?xml version="1.0" ?>
<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd" >
<XMLToDBMS Version="1.0">
   <Options>
   </Options>
   <Maps>
      <ClassMap>
         <ElementType Name="Part"/>
         <ToClassTable>
            <Table Name="Parts"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="PartNumber"/>
            <ToColumn>
               <Column Name="PartNumber"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Description"/>
            <ToColumn>
               <Column Name="Description"/>
            </ToColumn>
            <OrderColumn Name="Description" Generate="Yes"/>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Price"/>
            <ToColumn>
               <Column Name="Price"/>
            </ToColumn>
            <OrderColumn Name="Price" Generate="Yes"/>
         </PropertyMap>
      </ClassMap>
      <ClassMap>
         <ElementType Name="Line"/>
         <ToClassTable>
            <Table Name="Lines"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="LineNumber"/>
            <ToColumn>
               <Column Name="LineNumber"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Quantity"/>
            <ToColumn>
               <Column Name="Quantity"/>
            </ToColumn>
            <OrderColumn Name="Quantity" Generate="Yes"/>
         </PropertyMap>
         <RelatedClass KeyInParentTable="Candidate">
            <ElementType Name="Part"/>
            <CandidateKey Generate="Yes">
               <Column Name="PartNumber"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="PartNumber"/>
            </ForeignKey>
            <OrderColumn Name="PartNumber" Generate="Yes"/>
         </RelatedClass>
      </ClassMap>
      <ClassMap>
         <ElementType Name="Customer"/>
         <ToClassTable>
            <Table Name="Customers"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="CustNumber"/>
            <ToColumn>
               <Column Name="CustomerID"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="CustName"/>
            <ToColumn>
               <Column Name="Name"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Street"/>
            <ToColumn>
               <Column Name="Street"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="PostCode"/>
            <ToColumn>
               <Column Name="PostalCode"/>
            </ToColumn>
          </PropertyMap>
         <PropertyMap>
            <ElementType Name="City"/>
            <ToColumn>
               <Column Name="City"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="State"/>
            <ToColumn>
               <Column Name="State"/>
            </ToColumn>
          </PropertyMap>
      </ClassMap>
      <ClassMap>
         <ElementType Name="SalesOrder"/>
         <ToRootTable>
            <Table Name="Sales"/>
         </ToRootTable>
         <PropertyMap>
            <Attribute Name="SONumber"/>
            <ToColumn>
               <Column Name="SalesOrderID"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Date"/>
            <ToColumn>
               <Column Name="OrderDate"/>
            </ToColumn>
            <OrderColumn Name="OrderDate" Generate="Yes"/>
         </PropertyMap>
         <RelatedClass KeyInParentTable="Candidate">
            <ElementType Name="Line"/>
            <CandidateKey Generate="Yes">
               <Column Name="SalesOrderID"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="SalesOrderID"/>
            </ForeignKey>
            <OrderColumn Name="LineNumber" Generate="Yes"/>
         </RelatedClass>
         <RelatedClass KeyInParentTable="Candidate">
            <ElementType Name="Customer"/>
            <CandidateKey Generate="Yes">
               <Column Name="CustomerID"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="CustomerID"/>
            </ForeignKey>
            <OrderColumn Name="CustomerID" Generate="Yes"/>
         </RelatedClass>
      </ClassMap>
   </Maps>
</XMLToDBMS>