数据库 – 邮政编码和邮政编码是否违反第三种正常格式?

前端之家收集整理的这篇文章主要介绍了数据库 – 邮政编码和邮政编码是否违反第三种正常格式?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
鉴于状态信息隐含在邮政编码中并不存储他们的第三种正常形式的一些提法?可以还是应该简单地将它们组合成一个字段?

解决方法

根据 this post,有几个邮政编码跨越国界.所以不,不违反3NF.

Actually,there are a few rare cases where a ZIP Code crosses state boundaries. Usually it is due to access problems,such as being on a military base or due to constraints of the transporation network.

One such case is Protem,Missouri (ZIP Code 65733). Some of the Arkansas roads north of Bull Shoals Lake can best be accessed by the Protem delivery unit rather than an Arkansas post office. Some examples of such roads include Ann Street,Kalijah Road,McBride Road,Red Oak Lane,and Vance Road on Highway Carrier Route H002 in ZIP Code 65733. McBride Road actually crosses across the state boundary. If you look at the road network in an online mapping program,you can see that a rural carrier from say,nearby Diamond City,AR (ZIP code 72644),on the south side of Bull Shoals Lake,would need to drive several miles to be able to access the roads listed above.

For another example,Fort Campbell,Kentucky (ZIP Code 42223) also has some roads that exist within Tennessee.

原文链接:https://www.f2er.com/mssql/75971.html

猜你在找的MsSQL相关文章