Re: Dreaming About Redesigning SQL
From: mikepreece <member31023_at_dbforums.com>
Date: Tue, 28 Oct 2003 07:10:21 -0500
Message-ID: <3530846.1067343021_at_dbforums.com>
Date: Tue, 28 Oct 2003 07:10:21 -0500
Message-ID: <3530846.1067343021_at_dbforums.com>
Originally posted by andrewst
> How about an example of Employees and Projects: an Employee may be
> assigned to many Projects, and a Project may have many Employees
> assigned to it. Personnel managers are interested in an Employee-
> centric view; project managers are interested in a Project-centred
> view.
Yeah OK. I guess we could use the same kind of file structure as you gave and that I more or less replicated towards the end of my post - EmployeesProjects indexed on each Employee & Project. Maintaining indexes is a function of the DBMS btw - no application code needed.
Cheers
Mike.
-- Posted via http://dbforums.comReceived on Tue Oct 28 2003 - 13:10:21 CET