Re: Advice on SQL and records

Jonathan Leffler wrote:
> Marshall Spight wrote:
> > fran_beta_at_hotmail.com wrote:
> >>It seems implicit from what you say that StudentClasses includes all
> >>ClassID records AND all StudentID records, whereas I assume that only
> >>ClassID records would be in there.
> >
> > Neit[h]er one. The StudentClasses table has only two attributes: a
> > student id and a class id. It exists to model what students are in
> > what classes, and not any facts about students or classes per se.
>
>
> Wouldn't the StudentClasses table also contain information relevant to
> the particular student's achievements in the particular class? That is,
> while it would undoubtedly contain the two attributes you identify, it
> might also contain other information?
>

It *might* but that wasn't specified at the outset, and in any event I'd have thought that should either go in a separate table (eg "achievements" containing an AchievementsID field and an imported StudentID from "Students") or perhaps in the Student table itself.

Fran

>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
> Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
Received on Mon Aug 22 2005 - 07:48:59 CEST