This blog has moved here: woorkup.com | FOLLOW ME ON TWITTER @woork
Tuesday, September 30, 2008

10 Useful articles about Database design

This is a list of ten useful articles about database design which includes some tips and practical suggests to help you to design quickly databases for your web projects.

The list includes some tips to define relationships-entities model, common database design mistakes, database normalization, how to use PHP and SQL to create tables and relationships and a correct approach to define relationships between tables.

1. Ten Common Database Design Mistakes
By Louis Davidson - No list of mistakes is ever going to be exhaustive. People (myself included) do a lot of really stupid things, at times, in the name of "getting it done." This list simply reflects the database design mistakes that are currently on my mind, or in some cases, constantly on my mind.
Read More...

2. Define relationships-entities model (tables, attributes, and relationships)
This post explains step-by-step how to design a typical database relationships-entities model.
Read More...

3. Database Design and Modeling Fundamentals
This article covers the basics of database design including normalization, relationships and cardinality. A great tutorial on database design.
Read More...


4. Create tables and relationships with SQL
A simple tutorial which illustrates how to implement a database using SQL and phpMyAdmin.
Read More...

5. Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF).
Read More...

6. How to use PHP and SQL to create tables and relationships
A simple tutorial which explains how to use PHP and SQL to create quickly tables and relatioships.
Read More...

7. Table and Database Operations in PHP
In this article by Marc Delisle, we will learn how to perform some operations that influence tables or databases as a whole. We will cover table attributes and how to modify them, and also discuss multi-table operations.
Read More...


8. Practical database design, normalization, history, and event logging
What are the best choices when designing the schema for a relational database? What is the rationale in deciding in favor of one and against some other alternative? Given the amount of vendor-specific recommendations, it is all too easy to overlook basic relational database fundamentals. In this second of two parts, author Philipp K. Janert presents an introduction to database normalization and to the five Normal Forms. He also discusses other possible uses for a database in a project, for example as a repository for configurational or logging data.
Read More...

9. Relational Database Design
Many web designers understand what a database is. Some have even written queries to access a database or even designed their own database. Unfortunately, many web designers suffer from unnecessary problems and setbacks because they do not understand the basics of relational database design. This tutorial teaches the basics of relational database design.
Read More...

10. A correct approach to define relationships between tables
This post explains how to adopt a correct approach to define database relationships.
Read More...

If you want to suggest other interesting links add a comment! Thanks!

blog comments powered by Disqus
Anonymous said...

Thanks!

soulsdesign said...

I will read this articles with much pleasure ;)
Thank you for the resources!

AJK said...

Nice post :)

Xeon Xai said...

Now this is the reason I've had you in my RSS, Facebook, and reading your site for the past few months.

The CSS and AJAX was the start, but the PHP/MySQL database stuff, that's the real kicker to keep my eyes wide open when I see updates on your site.

Thanks for these links.

- Xeon

Jamie said...

agree with xeon this is the reason i get excited when your daily posts pops up in my RSS.. fantastic resource keep up the XLNT woork!!!

Darshan Chande said...

That's cool! Will spare time and read it if you suggest them..

satishmotwani said...

Thanks.

I will add one more..

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Short and simple.

Franco said...

My suggestion: Database Modelling in UML
http://www.methodsandtools.com/archive/archive.php?id=9

Vijay said...

Hi, thanks for this really great article.

tiago said...

Thanks, really thanks, this post will be very usefull... thnx from Brazil!

Tanju Yıldız said...

Thanks Antonio! Really useful source.

Danny Sanchez said...

Nice. Printed myself out a nice little book of all these articles just now.

spiderman05 said...

Great compilation, thank you. I am listening to the podcast of the first article right now and will definitely check the other ones as well.

Binny V A said...

Might I also suggest Naming Conventions in Database Design

dakull said...

Very usefull list of articles, i'll surely enjoy reading it :)

Michael said...

Thanks ! Looks very, very interesting.
Bookmarked it for reading later.

Anonymous said...

Thanx! It really helps alot ;)

mustafa said...

This is very good work. i will read when i find time...

web design India said...

Thanks ur information

it very useful

bollywood girls said...

i like your blog ....

Website Designer said...

Thanks for this nice post.

Juan said...

Thanks Antonio! very useful

website design said...

I love it! great tips!

  • Twitter Follow woork on Twitter
  • RSS Feed Subscribe to stay up to date
  • Podcast Coming soon...
  • 0 delicious lovers save
Share your links. Do you want to suggest any interesting link about web design or tech news? Submit your link.
Submit a News