While Juile obviously understands the idea of relational databases, I
think the question is more along the lines of balancing the number of
fields in a table with the number of tables you have. This is related to
the recent thread regarding, dang what was it?, well anyway, it's the same
thing.
If it's just ONE field that may or may not be null, I'd say put it in the
same table as your user data.
If that Education information was more than just ONE field (School,
Degree, Specialty, Location ,etc), then you'd probably want to move all
the Education information to a separate table.
> time for a book on relational databases....
>
>
> Terry Bader
>
> > -----Original Message-----
> > From: Julie Clegg [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 28, 2001 4:25 PM
> > To: CF-Talk
> > Subject: database design question
> >
> >
> >
> > hello,
> >
> > I am putting together a database and I cannot decide what to
> > do with the
> > Education Table. I have 1000 clients who I need to enter
> > their education
> > level. For example, did they graduate from highschool and if
> > so, what is
> > the name of their highschool. Should I put that info on the
> > same table or
> > create a new table with the clientid and the name of the
> > highchool attended
> > if they did attend. I know that if I put it all on one table
> > there will be
> > a lot of empty fields but I also didnt know if it was
> > "wasteful" to create
> > such a small table just for highschool name.
> >
> > What do you think? Will the system slow down if I have ALOT
> > of tables?
> >
> > Thanks,
> >
> > Julie
> >
> > >From: "Julia Green" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Subject: Re: CF Books
> > >Date: Tue, 20 Mar 2001 20:00:26 -0500
> > >
> > >Julie --
> > >
> > >This is late in coming, bu I have a great Adobe Acrobat
> > Documentation book:
> > >
> > >http://www.allaire.com/documents/cf45docs/acrobatdocs/45dwa.pdf
> > >
> > >Julia Green
> > >Julia Computer Consulting
> > >PO Box 279
> > >Watertown MA 02471-0279
> > >http://www.juliagreen.com
> > >Email: [EMAIL PROTECTED]
> > >Phone: 617-926-3413
> > >FAX: 413-771-0306
> > >
> > >----- Original Message -----
> > >From: Julie Clegg <[EMAIL PROTECTED]>
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Sent: Monday, March 19, 2001 11:05 AM
> > >Subject: CF Books
> > >
> > >
> > > > Hello,
> > > >
> > > > Can anyone recommend a good CF developers book...we will
> > be building a
> > >new
> > > > application using CF 4.5 and I need something that will be a good
> > >reference
> > > > book for a new CF developer!
> > > >
> > > > Thanks,
> > > >
> > > > Julie
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
