Re: [GENERAL] Employee modeling question

2014-09-23 Thread Nelson Green
On Fri, Sep 5, 2014 at 11:39 AM, Rich Shepard 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 purpose of de

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,

Re: [GENERAL] Employee modeling question

2014-09-05 Thread Nelson Green
On Fri, Sep 5, 2014 at 9:46 AM, John McKown wrote: > On Fri, Sep 5, 2014 at 7:52 AM, Nelson Green > 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

Re: [GENERAL] Employee modeling question

2014-09-05 Thread John McKown
On Fri, Sep 5, 2014 at 7:52 AM, Nelson Green 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_ good with SQL, you're go

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 t

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 mailto:franc...@teksol.info>> wrote: Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green mailto:nelsongree...@gmail.com>> a écrit : > Good morning, > > Hopefully this

Re: [GENERAL] Employee modeling question

2014-09-04 Thread Nelson Green
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil wrote: > Hello Nelson, > > Le 2014-09-04 à 10:39, Nelson Green 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 > >

Re: [GENERAL] Employee modeling question

2014-09-04 Thread François Beausoleil
Hello Nelson, Le 2014-09-04 à 10:39, Nelson Green 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 of which is > the s

[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 en