Database best practice

[Guest julien]

Hi,In this page:http://www.w3schools.com/sql/sql_insert.aspThere is a table example that is not normalised.It's the adress column where there are some street adresses (num) and street names (char) in that same field. I would suggest to simply divide this column to make the column headers look like these:LastName | FirstName | Address number | Street | CityIt's a pretty common error... so I forgive you!! ;)For more info about table normalisation, you should read:http://en.wikipedia.org/wiki/First_normal_formThanks for all the nice tutorials!