proper format for this database table

John Salerno johnjsal at NOSPAMgmail.com
Fri Oct 20 10:57:04 EDT 2006


mensanator at aol.com wrote:

> you should rethink it as
> 
> [id] [university] [yearStart] [yearEnd] [degreeEarned]
> 1     U of I       1971        1975      BS
> 1     U of I       1975        1976      MS
> 1     U of I       1976        1977      PhD
> 

Thanks guys. I do plan to have an id entry for each person as well, I 
just forgot to mention that. But since it's a primary key, I didn't know 
I could list it more than once. Or does primary key not necessarily mean 
unique?



More information about the Python-list mailing list