database - Are zip code and postal code violation of 3rd normal form? -
Given that state information is contained in the zip code, neither of them is being violated third common form is? Can you add them to an area? According to
, some zip codes are not cross-state boundaries, it is not a violation of 3 NF .
Actually, in some rare cases where zip code crosses state boundaries, it is usually due to problems facing such as due to the barriers to the military base or on the transport network .
One such case is Proteet, Missouri (ZIP code 65733). Bulk Shoals can be best utilized by the Protem Delivery Unit on the north of the lake instead of the Archacus Post Office on some roads of Arkansas. Some examples of such roads include Zip Code 65733, En Street, Kalyan Road, McBride Road, Red Oak Lane and Vance Road on Highway Carrier Route 00 002. McBride Road actually crosses the state boundary. If you look at the road network in an online mapping program, you can see that a rural carrier, south of the bull shawls lake, near Diamond City, AR (ZIP code 72644) to drive several miles away
For another example, there are some roads in Fort Campbell, Kentucky (ZIP code 42223) that are located within Tennessee.
Comments
Post a Comment