XML and relational database mapping

Wed, 05 May 2010 07:59:17 -0700

Hi
I'm very new to XML, and have the following question.
I have XML file like this:

<?xml version="1.0"?>
<Company>
<Department>
<Name>Enterprise Development</Name>
<Employee>
<Name>Jeff</Name>
</Employee>
<Employee>
<Name>Mike</Name>
</Employee>>
</Department>
<Department>
<Name>Foundation Services</Name>
<Employee>
<Name>Sam</Name>
</Employee>
</Department>
</Company>

There is a one to many relationship between 'Department' and 'Employee'. When I import this file into Access DB, it creates the two tables with the data in it, but it does not seem to know there is such a relationship between the two tables. The schema is inferred.
How do I fix this.?? Do I include the primary key of the Department in both the Department and the Employee, and then manually set up the relationship in Access, or is there a more 'correct' solution.??
Thanks
Anton

'XML and relational database mapping' Thread RSS Feed

XML and relational database mapping