Hi guys. I was wondering if someone could suggest some possible structures for an "Education" table in a database. It will contain at minimum university names, years of attendance, and degrees earned. My problem is that I don't know quite how to set this up for people who have attended multiple universities. I could do:
university text DEFAULT NULL, yearStart integer DEFAULT NULL, yearEnd integer DEFAULT NULL, degreesEarned text DEFAULT NULL But this only allows for one university. (Also not sure if I should split up the years like that.) But mainly I'm looking for a way to construct this table so it can hold multiple universities, if necessary. Thanks. -- http://mail.python.org/mailman/listinfo/python-list