Re: Which 'Intro to SQL' book?

Thank you for listing the books. I'll check them out further on amazon.com.

On 25 Jul 2001, DaveChristman wrote:

>A book which helped me when I first started doing SQL is SQL Queries
>for Mere Mortals by Hernandez/Viescas. Extremely well written and easy
>to understand. Que has an intro to SQL book that is excellent too!
>Hope this helps.
>
>DaveChristman
>
>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 Thu Jul 26 2001 - 04:36:06 CEST