| From: | Mike Adams <madams55075(at)comcast(dot)net> |
|---|---|
| To: | Matt <urlugal(dot)mailinglists(at)gmail(dot)com> |
| Cc: | Craig Barnes <cjbarnes18(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: table design |
| Date: | 2011-06-13 02:49:07 |
| Message-ID: | 4DF57AA3.6020204@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2011-02-14 07:25, Matt wrote:
>
>
> I have a few books and have been slowly making my way through
> them and the combination of them and trial and error to see what
> works and what doesn't has proved to be the best way. The ones
> I found helpful for me anyway are "SQL and Relational Theory" by
> CJ Date, The Postgres Documentation, and "The Theory Of
> Relational Databases" David Maier.
>
Now, both of those books are VERY good, but for design from scratch...
give:
http://www.amazon.com/Database-Design-Mere-Mortals-Hands/dp/0201752840
a try, I thought it rather well thought out.
Also read Celko (any and all):
http://www.amazon.com/Joe-Celko/e/B000ARBFVQ/ref=sr_tc_ep?qid=1307931971
Enjoy,
- --
Michael Adams
SQL/Perl/VBA/C??/Java
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk31eqMACgkQFUo+7qhKZejTtQCeK/n6CK2rsq09lRMOyEKjUXCA
GhAAoM7A0RYR8sPupRWv0E5ZZAo4HkXZ
=8eTw
-----END PGP SIGNATURE-----
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1382 / Virus Database: 1513/3699 - Release Date: 06/12/11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Leovey | 2011-06-13 11:58:29 | Need a SQL to find if table has OIDS |
| Previous Message | Jean-Yves F. Barbier | 2011-06-12 21:41:19 | Re: images in one or more tables? |