Re: [GENERAL] Employee modeling question

2014-09-23 Thread Nelson Green
On Fri, Sep 5, 2014 at 11:39 AM, Rich Shepard rshep...@appl-ecosys.com wrote: On Fri, 5 Sep 2014, John McKown wrote: They are excellent. They are _not_ for beginners. The For Smarties portion is not just a play against the For Dummies series. Joe does some high powered SQL. For the

Re: [GENERAL] Employee modeling question

2014-09-05 Thread Nelson Green
I could store the department and business attributes with the employee, but without proper constraints the referenced department could conceivably not correspond to the referenced business. Or I could ensure that all businesses have at least one department, defaulting to the business

Re: [GENERAL] Employee modeling question

2014-09-05 Thread John McKown
On Fri, Sep 5, 2014 at 7:52 AM, Nelson Green nelsongree...@gmail.com wrote: Thanks Robin. Ironically enough, our little local library has three books by Joe Celko, so looks like I may have a weekend of reading ahead of me. I'm impressed that your library has him. But, unless you are _very_

Re: [GENERAL] Employee modeling question

2014-09-05 Thread Nelson Green
On Fri, Sep 5, 2014 at 9:46 AM, John McKown john.archie.mck...@gmail.com wrote: On Fri, Sep 5, 2014 at 7:52 AM, Nelson Green nelsongree...@gmail.com wrote: Thanks Robin. Ironically enough, our little local library has three books by Joe Celko, so looks like I may have a weekend of

Re: [GENERAL] Employee modeling question

2014-09-05 Thread Rich Shepard
On Fri, 5 Sep 2014, John McKown wrote: They are excellent. They are _not_ for beginners. The For Smarties portion is not just a play against the For Dummies series. Joe does some high powered SQL. I read Joe Celko's columns in Database Advisor and a couple of other magazines in the '80s,

[GENERAL] Employee modeling question

2014-09-04 Thread Nelson Green
Good morning, Hopefully this is the correct place to ask this type of question. I am in the early stages of designing a system to track employee information, including some aspects of their payroll, one of which is the source of the salary funds within the business. I need to make this generic

Re: [GENERAL] Employee modeling question

2014-09-04 Thread François Beausoleil
Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green nelsongree...@gmail.com a écrit : Good morning, Hopefully this is the correct place to ask this type of question. I am in the early stages of designing a system to track employee information, including some aspects of their payroll, one

Re: [GENERAL] Employee modeling question

2014-09-04 Thread Nelson Green
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil franc...@teksol.info wrote: Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green nelsongree...@gmail.com a écrit : Good morning, Hopefully this is the correct place to ask this type of question. I am in the early stages of designing a

Re: [GENERAL] Employee modeling question

2014-09-04 Thread Robin
Robin St.Clair On 04/09/2014 20:44, Nelson Green wrote: On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil franc...@teksol.info mailto:franc...@teksol.info wrote: Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green nelsongree...@gmail.com mailto:nelsongree...@gmail.com a écrit :