> From: Thomas F. Maher, Jr.[SMTP:[EMAIL PROTECTED]]
>
>
> Right now I have:
>
> Student Advisee
> ----------- ---------------- Faculty
> StudentID (1)- - - - - - (8) StudentID ------------------
> [More] FacultyID (8) - - - - - - - - (1)
> FacultyID
> [More]
>
> .... while I chanted the mantra "One student can have many faculty
> advisers.
> One Faculty member can have many student advisees. Many students can have
> many faculty" I entered test data, and the database -seems- to work....
>
>
YES -- at least this looks correct to me. In the prior example, you were
creating an unnecessary variable, advisee ID -- the relationship is
student-to-faculty, which this many-to-many schema shows. Me, I would have
made it one-to-many as I wouldn't have remembered double-majors!
> Kathy E. Gill
> DCAC/MRM Production Visibility Support -- 425.234.2004, pager 425.568.0195
> The biggest mistake people make in life is not trying to make a living at
> doing what they most enjoy. ~ Malcomb S. Forbes
> Microsoft Exchange: the perfect name for its users' greatest desire!
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
