Re: proper format for this database table

2006-10-20 Thread [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote: > John Salerno wrote: > > [EMAIL PROTECTED] wrote: > > > > > [Eid] [Sid] [university] [yearStart] [yearEnd] [degreeEarned] > > > 5 1 U of I 19711975 BS > > > 6 1 U of I 19751976 MS > > > 7 1 U of I 1976

Re: proper format for this database table

2006-10-20 Thread [EMAIL PROTECTED]
John Salerno wrote: > [EMAIL PROTECTED] wrote: > > > [Eid] [Sid] [university] [yearStart] [yearEnd] [degreeEarned] > > 5 1 U of I 19711975 BS > > 6 1 U of I 19751976 MS > > 7 1 U of I 19761977 PhD > > > > where [Eid

Re: proper format for this database table

2006-10-20 Thread John Salerno
[EMAIL PROTECTED] wrote: > [Eid] [Sid] [university] [yearStart] [yearEnd] [degreeEarned] > 5 1 U of I 19711975 BS > 6 1 U of I 19751976 MS > 7 1 U of I 19761977 PhD > > where [Eid] is the primary key of the Educat

Re: proper format for this database table

2006-10-20 Thread [EMAIL PROTECTED]
John Salerno wrote: > Carsten Haese wrote: > > >>> [id] [university] [yearStart] [yearEnd] [degreeEarned] > >>> 1 U of I 19711975 BS > >>> 1 U of I 19751976 MS > >>> 1 U of I 19761977 PhD > >>> > >> Thanks guys. I do plan to have

Re: proper format for this database table

2006-10-20 Thread John Salerno
Neil Cerutti wrote: > On 2006-10-20, John Salerno <[EMAIL PROTECTED]> wrote: >> Bruno Desthuilliers wrote: >>> John Salerno a écrit : Hi guys. I was wondering if someone could suggest some possible structures for an "Education" table in a database. >>> Wrong newsgroup, then. comp.databa

Re: proper format for this database table

2006-10-20 Thread John Salerno
Carsten Haese wrote: >>> [id] [university] [yearStart] [yearEnd] [degreeEarned] >>> 1 U of I 19711975 BS >>> 1 U of I 19751976 MS >>> 1 U of I 19761977 PhD >>> >> Thanks guys. I do plan to have an id entry for each person as well

Re: proper format for this database table

2006-10-20 Thread Neil Cerutti
On 2006-10-20, John Salerno <[EMAIL PROTECTED]> wrote: > Bruno Desthuilliers wrote: >> John Salerno a écrit : >>> Hi guys. I was wondering if someone could suggest some possible >>> structures for an "Education" table in a database. >> >> Wrong newsgroup, then. comp.database.* is right next door

Re: proper format for this database table

2006-10-20 Thread Carsten Haese
On Fri, 2006-10-20 at 10:57, John Salerno wrote: > [EMAIL PROTECTED] wrote: > > > you should rethink it as > > > > [id] [university] [yearStart] [yearEnd] [degreeEarned] > > 1 U of I 19711975 BS > > 1 U of I 19751976 MS > > 1 U of I 1976

Re: proper format for this database table

2006-10-20 Thread John Salerno
Bruno Desthuilliers wrote: > John Salerno a écrit : >> Hi guys. I was wondering if someone could suggest some possible >> structures for an "Education" table in a database. > > Wrong newsgroup, then. comp.database.* is right next door... > I know, I'm sorry. It's just that this newsgroup serve

Re: proper format for this database table

2006-10-20 Thread John Salerno
[EMAIL PROTECTED] wrote: > you should rethink it as > > [id] [university] [yearStart] [yearEnd] [degreeEarned] > 1 U of I 19711975 BS > 1 U of I 19751976 MS > 1 U of I 19761977 PhD > Thanks guys. I do plan to have an id entry

Re: proper format for this database table

2006-10-19 Thread Jordan Greenberg
John Salerno wrote: > 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 wh

Re: proper format for this database table

2006-10-19 Thread [EMAIL PROTECTED]
Gabriel Genellina wrote: > At Thursday 19/10/2006 17:07, John Salerno wrote: > > >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 > >pro

Re: proper format for this database table

2006-10-19 Thread Bruno Desthuilliers
John Salerno a écrit : > Hi guys. I was wondering if someone could suggest some possible > structures for an "Education" table in a database. Wrong newsgroup, then. comp.database.* is right next door... -- http://mail.python.org/mailman/listinfo/python-list

Re: proper format for this database table

2006-10-19 Thread Gabriel Genellina
At Thursday 19/10/2006 17:07, John Salerno wrote: 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

proper format for this database table

2006-10-19 Thread John Salerno
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