XSD to SQL schema translation

Closed - This job posting has been filled and work has been completed.

Job Description

I would like to have the attached XSD changed to represent the relationships between the levels of the data it represents. I will be using it to import data into a SQL Server database (From XML to the SQL server) from .NET C#. (Using a fill command on a dataset)

So to be specific - each of the complex types needs to have a relationship key to its parent that is named in such a way that it is unique to the document and makes sense logically by the name. (Has some relation to the object)

If XSD is your world this probably makes alot of sense. If it isn't, then this is clear as mud. Be sure you are comfortable in it before you proceed.

Skills: import, .net

Open Attachment