473,218 Members | 1,435 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 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 3351
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: srinivas | last post by:
hey can u tell me the rules of making a data flow diagram,i need to draw these in my project,i have studied it before but i am not able to understand it properly,can u please make it clear for me,i...
1
by: Jaunty Edward | last post by:
Hi, I am to make a DB that will handle over a million inserttions every month. Right Now I am to design it. I was wondering if any of you have a tutorial or some guide that can talk about the best...
3
by: zlst | last post by:
Many technological innovations rely upon User Interface Design to elevate their technical complexity to a usable product. Technology alone may not win user acceptance and subsequent marketability....
3
by: Dave Veeneman | last post by:
Are there any good tutorials out there on how to actually design a Web Form in VS.Net? I'm an experienced .NET WinForms developer, and I am just getting started with ASP.Net. So far, it's pretty...
2
by: JIM.H. | last post by:
Hello, I am not experienced in designing database and building web application. However my manager want me to search this: I need to develop a web interface and database for a dental clinic. Is...
105
by: Christoph Zwerschke | last post by:
Sometimes I find myself stumbling over Python issues which have to do with what I perceive as a lack of orthogonality. For instance, I just wanted to use the index() method on a tuple which does...
10
by: charlie | last post by:
I posted this at Macromedia Dreamweaver newsgroup but go no response. I've been trying to learn CSS. Below is a link to a couple of designs that I managed to do using absolute position. ...
10
by: vital | last post by:
Hi, I am designing the middle tier of a project. It has 6 classes and microsoft application data access block. The six classes are DBServices, Logger, ProjectServices ... etc. and all these...
11
by: tokcy | last post by:
Hi everyone, I am new in php and ajax, i am facing the prob while i click on element of first drop down then in second dropdown all element showl come from database. I mean i have three dropdown 1....
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.