加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MsSql教程 > 正文

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

发布时间:2020-12-12 08:30:44 所属栏目:MsSql教程 来源:网络整理
导读:鉴于状态信息隐含在邮政编码中并不存储他们的第三种正常形式的一些提法?可以还是应该简单地将它们组合成一个字段? 解决方法 根据 this post,有几个邮政编码跨越国界.所以不,不违反3NF. Actually,there are a few rare cases where a ZIP Code crosses state
鉴于状态信息隐含在邮政编码中并不存储他们的第三种正常形式的一些提法?可以还是应该简单地将它们组合成一个字段?

解决方法

根据 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.

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读