Re: i am looking for help in database design
Posted by: Peter Brawley
Date: November 02, 2007 09:57AM

First you need to have the basics of relational design & normalisation firmly in your head, eg from...

http://www.htmlgoodies.com/beyond/reference/article.php/3472691
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html
http://en.wikipedia.org/wiki/Relational_model
http://articles.techrepublic.com.com/5100-22-1050416.html
http://www.onlamp.com/pub/ct/19

Then ...

analyse your particular in terms of its use cases,

from those use cases derive a list of required entities, their attributes & interrelationships;

from that model, write the table defs as CREATE TABLE statements

from that, create the database

populate it with sample data

prove you can write the query for every required database action, or revise the schema for cases which the model fails

There is discussion & an example at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch05.pdf.

PB



Edited 1 time(s). Last edit at 11/02/2007 10:00AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: i am looking for help in database design
November 02, 2007 09:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.