MySQL Forums
Forum List  »  Newbie

Re: sakila database design question
Posted by: Peter Brawley
Date: September 29, 2015 11:47PM

> Why would normalization only apply to the city and to the country and not the street address?

Yes, that can be a problem, depending on the scope of the database and the level of normalisation it requires. If data comes mainly from just one city or suburb, you may be able to take street names as is, but if the DB covers many states regions or countries, you may need a more elaborate design. And if you get into the weeds of Boyce-Codd or even Fourth Normal Form, just projecting street names to their own table may not be enough---eg 4NF prohibits multiple instances of one column depending on two other independent columns. Fortunately, the database problems we spend much of our day on don't often require 4NF!

Options: ReplyQuote


Subject
Written By
Posted
September 29, 2015 07:49AM
Re: sakila database design question
September 29, 2015 11:47PM


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.