Normalization of Database

Normal Forms
Normal forms are used for the process of normalization of data and therefore for the
database design. In theory, there are at least five different normal forms, of which the
first three are the most important for practical use. The third normal form for a table
can be achieved by testing the first and second normal forms at the intermediate states,
and as such, the goal of good database design can usually be fulfilled if all tables of a
database are in the third normal form.
 
First Normal Form
First normal form (1NF) means that a table has no multivalued attributes or composite
attributes. (A composite attribute contains other attributes and can therefore be divided
into smaller parts.) All relational tables are by definition in 1NF, because the value of
any column in a row must be atomic—that is, single valued.
 
Second Normal Form
A table is in second normal form (2NF) if it is in 1NF and there is no nonkey column
dependent on a partial primary key of that table. This means if (A,B) is a combination
of two table columns building the key, then there is no column of the table depending
either on only A or only B.
 
Third Normal Form
A table is in third normal form (3NF) if it is in 2NF and there are no functional
dependencies between nonkey columns.
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值