I think your highschoolrelations table is overkill when there is only a
1-1 relationship. If there were a small, finite number of schools, then
yes, a table of ids and names of those schools would be useful and you
would populate the highschool field of the user with that schools id. But
if there could be more than one school per user (and there certainly could
be depending on the application - ie. What school did you graduate from?
vs. What school(s) have you attended) then your relations table fits the
bill nicely.
> Here is the question. Diod they graduate from high school? If so, which
> high school?
>
> Here is the inference.
>
> Those who have a high school name went to high school, and those who didn't
> have a high school name did not go to high school. i know it's a big DUH,
> but it's important.
>
> here's how i would dersign the database. I would treat the high school name
> as a city, state or zip code, because there are thousands or gagillions of
> em. So, i would put them in the same table as the client name
>
> so the client table would have another field called high school. if it's
> null, then that means that they did not graduate from high school, and u can
> use that as a condition when u need that information.
>
> IF there were like only 10 high schools in the world, I would go about a
> different approach.
>
> I would have 3 tables. 1 table has the name of all the clients and their
> clientID (increment). the 2nd table has the list of all high schools and
> their highschoolID (increment). The third table builds the relationship
> between the clients and their school. the third table would have 3 fields.
> The HighSchoolrelationsID, ClientID, and highschoolID.
>
> So if client Amy Gershen had a clientID of 3, and her high school James
> Brown High had a highschoolID of 12, this is the informationt hat would go
> into the Highschoolrelations table.
>
> HighschoolrelationsID ClientID HighSchoolID
> --------------------- -------- ------------
> 1 3 12
>
>
>
> -----Original Message-----
> From: Julie Clegg [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 3: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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists