what are the objectives and what are the advantages of good database design?

Hi  fahd,

There are some pretty standard measures by which effective databases
are measured.  Rather than reiterate them here, I'm going to give you
some links to some well-written websites which will spell them out for
you.

In very short:  The objective and advantage of a good database design
"is the ability to utilise the information you collect by being able
to quickly view your information using a variety of reports."
http://www.infoage.co.nz/service/database.htm

"..a well-designed database that provides you with convenient access
to the information you want. With a solid design, you'll spend less
time constructing the database and you'll end up with faster, more
accurate results. ... When you organize your data appropriately, you
design flexibility into your database and gain the capability to
combine and present facts in many different ways."

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgUsing_a_Database_Design_Process.asp


This article covers the basics of database design including
normalization, relationships and cardinality. A great tutorial on
database design.
http://www.sqlteam.com/item.asp?ItemID=122

"The problem of effective database design is a complex one. Most
people consider it an art rather than a science. This means that
intuition plays a major role in good design. Nonetheless, there is a
considerable theory of database design, and it can be quite
complicated."
http://www.oreilly.com/catalog/accessdata3/chapter/ch04.html

I hope that these links give you a basic understanding of the
objectives and advantages of a good database design.

K~

Search terms: 
Database important features
Database design

---

Request for Answer Clarification by fahd-ga on 27 Jul 2002 19:17 PDT

in short what would be a 1,2,3,4,5,.... list of Objectives and
advantages of a good database design?

---

Clarification of Answer by knowledge_seeker-ga on 31 Jul 2002 11:57 PDT

Hi Fahd,

I'm sorry you weren't satisfied with my original answer. Below please
find some further links below which should help to answer your
question more fully.

4 Advantages of Good Database Design

1. Provides sound database structures
2. Guides the design process through each step
3. Minimizes design mistakes
4. Helps identify mistakes sooner

http://www.cadence-group.com/newsletter/archive/Vol1Is3DesngDbases.htm

7 Steps to Good database design
http://www.webreview.com/1999/03_26/developers/03_26_99_2.shtml

16 Common Mistakes of Database design
http://www.webreview.com/1999/03_26/developers/03_26_99_3.shtml

6 Qualities of Good Database Design
http://gis.mit.edu/classes/11.521/lectures/lecture7.html#Qualities_of_a_Good_Database_Design


Since this was your first time using Google Answers, I feel there may
have been a misunderstanding regarding our service. In the future,
please give the researcher a chance to clarify his or her answer
BEFORE giving your rating. As you can see, there is no way for you to
raise the rating if you are now satisfied with my answer.

I can assure you that if you are not pleased with your answer, or if
there has been confusion regarding your question, your researcher will
gladly provide further information. Our objective is to have you
remain a "life member" as you so aptly put it. :-)

Finally, do keep in mind that in the case of homework questions,
researchers are certainly willing to help you find the information you
need to complete your own answers, but will not formulate your answer
for you.

Best of luck in your quest to understand database design --

--K~

this is my first time using Google. I hope to be a life member.