471,306 Members | 837 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

databse design tutorial

Hi everybody,

i need a free tutorial on database design can any help ??

thx
---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Nov 12 '05 #1
3 3287
Nagib Abi Fadel wrote:
Hi everybody,

i need a free tutorial on database design can any help ??


How about "A Simple Guide to Five Normal Forms in Relational Database
Theory, Communications of the ACM 26(2), Feb. 1983":

http://209.197.234.36/db/simple.html

Mike Mascari
ma*****@mascari.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2
On Mon, 2003-10-06 at 16:52, Mike Mascari wrote:
Nagib Abi Fadel wrote:
Hi everybody,

i need a free tutorial on database design can any help ??


How about "A Simple Guide to Five Normal Forms in Relational Database
Theory, Communications of the ACM 26(2), Feb. 1983":

http://209.197.234.36/db/simple.html


Note that, the vast majority of the time, and especially for young
DBAs, only the 1st 3 NFs are necessary.

Thanks for the link.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

"Whatever may be the moral ambiguities of the so-called demoratic
nations and however serious may be their failure to conform
perfectly to their democratic ideals, it is sheer moral
perversity to equate the inconsistencies of a democratic
civilization with the brutalities which modern tyrannical states
practice."
Reinhold Nieburhr, ca. 1940
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #3
Ron Johnson wrote:
Hi everybody,

i need a free tutorial on database design can any help ??


On the slightly more intermediate level to db design would be:

http://www.therationaledge.com/rosea...904/RATL-2.PDF

It is written from the perspective of Object Oriented Programming, so it
might be a better starting point for those with more OO experience.

Especially useful are points on:
- Discussions on Existence-based (sequences) vs Value-based (real world
value) primary keys
- Different approaches to handling enums
- Discouraging designs that leads to huge number of columns
- Various implementations of associations
- Implementing inheritance (alas, not pgsql's)

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
5:00pm up 285 days, 8:32, 10 users, load average: 6.13, 6.12, 6.12

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/goWVNYbTUIgzwfARAmosAJ4m2UDro82KncUaDsc8wKCb8thfzA CgzMdB
AtJw0s7OWXTLgZ5Yj3V3WS8=
=nePG
-----END PGP SIGNATURE-----

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by srinivas | last post: by
1 post views Thread by Jaunty Edward | last post: by
3 posts views Thread by zlst | last post: by
3 posts views Thread by Dave Veeneman | last post: by
2 posts views Thread by JIM.H. | last post: by
105 posts views Thread by Christoph Zwerschke | last post: by
10 posts views Thread by charlie | last post: by
10 posts views Thread by vital | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.