I'm a beginner in database designing. I just want to know some best practices included in designing a database. I use MySql as my server.
I'm a beginner in database designing. I just want to know some best practices included in designing a database. I use MySql as my server.
HERB is the healing of a nation. ALCOHOL is the destruction.
Have you tried googling 'Database Design best practices'? It returns over 9 million results and many on the first page are very helpful.
James
Some more terms to include in searches for specific topics: "relational model", "normalization", "normal form", "denormalization", "anomaly", "foreign key", "functional dependency". See also the thread "sql database".
Last edited by misson; 12-07-2010 at 11:10 PM.
Be sure to read all pages linked in this post; they have further information that should prove useful. When asking for help, make sure you follow Eric Raymond's and Jon Skeet's guidelines for prompt, accurate responses. Please answer any questions I ask; they're not rhetorical (probably). Any posted code is intended as illustrative example, rather than a solution to your problem to be copied without alteration. Study it to learn how to write your own solution.Misson, not Mission.