XML to DB

gistfile1.xml

<company>
    <building address="123 Main Street">Main</building>
    <legal name="Main Street productions"/>
    <org>
      <manager empID=456>Bob Smith</manager>
          <employee empID=987>Margie Jones</employee>
          <employee empID=721 role="SysAdmin">John Johnson</employee>
      </manager>
    </org>          
</company>


/**
DB tables:
    Company
         company_pk
    Building
         building_pk
         company_fk
         address
         text
    Legal
        legal_pk
        company_fk
        name
    Org
        org_pk
        company_fk
    Manager
        manager_pk
        org_fk
        emp_id
        text
    Employee
        employee_pk
        manager_fk
        emp_id
        role
        text
    
 **/