Re: Advice on SQL and records
Date: 21 Aug 2005 20:36:18 -0700
Message-ID: <1124681778.000058.189480_at_o13g2000cwo.googlegroups.com>
fran_beta_at_hotmail.com wrote:
>
> I guess the problem is "what exactly are the records in
> 'StudentClasses'"?
The term "records" isn't a great one, as it promotes record-based thinking. Set-based thinking is more native to the relational world.
> 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.
Neiter 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.
> Is it the case that records contain records?
Surprisingly, no.
Marshall Received on Mon Aug 22 2005 - 05:36:18 CEST