| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Employee modeling question |
| Date: | 2014-09-05 16:39:47 |
| Message-ID: | alpine.LNX.2.11.1409050935270.13049@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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, and have read most of his books.
For the purpose of developing an employee schema with departments for
some, his "SQL For Smarties" provides very sound advice on how to proceed.
Having separate company, department, and employee tables is a given. But,
you might need many-to-many tables to keep track of the complex
relationships. This is all covered in the chapters on DDL (Data Definition
Language) and is separate from the chapters on DML (Data Manipulation
Language).
Good luck,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eildert Groeneveld | 2014-09-05 16:49:15 | count on cascading deletes |
| Previous Message | David G Johnston | 2014-09-05 15:44:57 | Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. |