A good basic book on general SQL is Introduction to SQL ISBN 0-201-62425-7
and a more advanced book is SQL for Smarties ISBN 1-55860-576-2. But the
questions you raised below are business rule and database design questions
rather than SQL questions. Knowing SQL can't help you to decide what to do
about the CEO's wife.
Van
"Cannon Fodder" <technews_at_invalid.sorry> wrote in message
news:Pine.LNX.4.21.0107250437030.4429-100000_at_charlie.mygroup...
> Hi,
>
> Which book 'out there' on understanding SQL is the best? Would
> the free documentation from the postgresql web sites be just as
> good?
>
> I'm trying to create a system that keeps track of items in an
> organizational fashion. It's something similar to keeping track
> of a fictional company's internal staff
> organization. Questions for which I'm thinking up
> procedural-based algorithmic functions:
>
> Who is the CEO, the floor manager, the immediate supervisor, and
> the co-workers, and who has supervisory rights over which people?
> What fundamental fields might be used to achieve this:
> 'PersonID', 'ImmediateSupervisorID', 'StaffLevelID', 'FirstName'
> and 'LastName'?
>
> What happens if a person gets promoted? Who has to be notified
> about the promotion, and what would be the most efficient method
> for doing that notification? Conversely, what entities need to
> be 'notified' about a demotion? How should those entities be
> notified in either case (promotion or demotion).
>
> What if a supervisor (from any level) decides to go
> to another department and leaves his underlings behind?
>
> What if new staff gets hired? What if old staff gets fired?
>
> What if the CEO's spouse takes a domineering interest in the
> company, and becomes the Immediate Supervisor of the CEO? Would
> the spouse have the following values: PersonID='-1',
> ImmediateSupervisorID=NULL, StaffLevelID='-1', and
> 'FirstName="MrsCEO"?
>
> There are scores of other questions that I am attempting to
> study for algorithms. But if a free linux-based SQL engine
> (mySQL, postgresql) could solve most of these questions already,
> I'm all for it...in the meantime, any comments or advice about
> any the questions I've posted are quite welcome.
>
> Please post messages back to the NG, or they'll bounce.
>
> -CF
>
>
>
Received on Wed Jul 25 2001 - 17:24:57 CEST
