grr!! it does fit in right. it said GRADUATED FROM. i've never known of
anyone who has graduated from more than one high school :P
----- Original Message -----
From: Tony Schreiber <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 10:36 PM
Subject: RE: database design question
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
