I am creating a form in Flex so a person can enter in information for a Credit Crawl at the end of a show. I also have create the db to house the data. The client sent over some sample xml of what they want delivered as xml. Now I am trying to figure out the best schema to set up my tables in from the given xml. Here is a sample of the xml:

PHP Code:

<Credits ID="BOB01">
  <
ShowName>Bob Jones Show</ShowName>
  <
Comments>Bob Jones Show
    
FINAL 12/27/09
    CREDITS
    EPISODE 
#1</Comments>
  
<Copyright></Copyright>
  <
Page>
    <
Category>
      <
Title>Producer</Title>
      <
Name>Bob Jones</Name>
    </
Category>
    <
Category>
      <
Title>Supervising Producer</Title>
      <
Name>Bob Jones</Name>
    </
Category>
    <
Category>
      <
Title>Field Producers</Title>
      <
Name>Bob Jones</Name>
      <
Name>Bob Jones</Name>
    </
Category>
    <
Category>
      <
Title>Segment Producers</Title>
      <
Name>Bob Jones</Name>
      <
Name>Bob Jones</Name>
      <
Name>Bob Jones</Name>
    </
Category>
    <
Category>
      <
Title>Cast</Title>
      <
Role>
        <
Title>Bobbin</Title>
        <
Name>Bob Jones</Name>
      </
Role>
      <
Role>
        <
Title>BobBobbyBobsterDas Bob</Title>
        <
Name>Bobina Jones</Name>
      </
Role>
      <
Role>
        <
Title>Lil BobBig Bob</Title>
        <
Name>Bobish Jonish</Name>
      </
Role>
    </
Category>
    <
Category>
      <
Title>&#169; 2009 Bob Jones Entertainment, LLC  
        
All Rights Reserved</Title>
    </
Category>
    <
Category>
      <
Title>The characters and events depicted in this photoplay are fictitious.
        
Any similarity to actual personsliving or deadis purely coincidental.</Title>
    </
Category>
    <
Category>
      <
Logo>Bob_Logo_01</Logo>
    </
Category>
    <
Category>
      <
Logo>Bob_Logo_02</Logo>
    </
Category>
  </
Page>
</
Credits
I am trying to get the clients table schema from them but they are big and slow to act and Xmas is just around the corner
My first guess was that there would be a table of shows, obviously, with unique information on each show then a relative table of names and titles that would be associated with a show table id. But as you can see there are also the <role> tags that have Title, Name children of their own, so I was not sure how to handle that. Also how would you handle the one title to many names situation? Would I need an Order field to them in proper order and how would that apply to the Role tags. Any help or references to pertinent sites would be appreciated