Re: Which 'Intro to SQL' book?

Thanks for answering. I was referred to `SQL for Smarties' in an old post many months ago--by the author himself. I may investigate these books that were mentioned below. However, in the meantime, I'm plowing ahead with the planning process, however archaic it may seem to the OOP and SQL ppl. :)

On Wed, 25 Jul 2001, Van Messner wrote:

>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 Thu Jul 26 2001 - 04:35:30 CEST