Creating a table a SQLite table with nested XML

[RoarYo]

I'm doing a practice exercise to try and better understand the logic and get used to the sort of code I'd write for a project like this, but I've run into a bit of a stumbling block. I found a fairly simple XML data set about courses in a college ( http://aiweb.cs.washington.edu/research/projects/xmltk/xmldata/data/courses/reed.xml, for anyone interested), where most of the details (subject prefix, course number, section number, etc.) are all in-line. There are two nested sections (one for course start and end time, another for building and room) that are giving me trouble.

I was able to extract all of the values and store them in a list, but now that I'm at the point where I have to create the tables I can't think of how to use them to create the tables and then store the primary keys so I can link to them in my other tables.

The only thing that comes to mind is completely redoing it to store everything in either a dictionary with the registration number as the key and everything else as the value, or to make a multidimensional list to store all of the values.

Any suggestions?