Re: sakila database design question
> 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!
Subject
Written By
Posted
September 29, 2015 07:49AM
September 29, 2015 11:42AM
September 29, 2015 08:17PM
September 29, 2015 08:34PM
Re: sakila database design question
September 29, 2015 11:47PM
September 30, 2015 06:12AM
September 29, 2015 12:16PM
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.