proper format for this database table
John Salerno
johnjsal at NOSPAMgmail.com
Fri Oct 20 15:16:52 EDT 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