Which 'Intro to SQL' book?

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 - 10:21:12 CEST