Re: [school-discuss] Collecting Assessments at District Level

[Alan Chen <alan@digikata.com>]

On Wed, Mar 13, 2002 at 04:52:33PM -0600, Les Richardson wrote:
> Hi,
> 
> Sorry, I misunderstood your question.
> 
> So you want reports by:
> student, class, location
> 
> There are a couple of approaches in terms of data structures:
> a) Fewer larger tables that simplify querying but complicate entry.
> b) More smaller tables that make querying harder. 

What i've done in the past is to define sql views which create
the larger "virtual" tables from the smaller tables for common queries.

This also lets less advanced sql users perform simpler queries against what
looks like a plain table without having to really know about joins, etc...

-- 
Alan Chen
Digikata LLC
http://digikata.com