proper format for this database table

John Salerno johnjsal at NOSPAMgmail.com
Fri Oct 20 21:16:52 CEST 2006


mensanator at aol.com wrote:

> [Eid] [Sid] [university] [yearStart] [yearEnd] [degreeEarned]
> 5      1     U of I       1971        1975      BS
> 6      1     U of I       1975        1976      MS
> 7      1     U of I       1976        1977      PhD
> 
> where [Eid] is the primary key of the Education table and
> [Sid] is the foreign key from the Student table so that the
> single student record (1) links to three education records
> (5,6,7).
> 

Hmmm. I think I'm lost. My table will have a key that represents the 
persons ID, in my case it would be salerjo01. This will be what ties 
this table to that person. Can I repeat this key multiple times in the 
Education table?



More information about the Python-list mailing list