Editing Database normalization (section)

=== Satisfying 1NF ===
In the [[first normal form]] each field contains a single value. A field may not contain a set of values or a nested record. '''Subject''' contains a set of subject values, meaning it does not comply. To solve the problem, the subjects are extracted into a separate '''Subject''' table:<ref name=":0" />

{| class="wikitable"
|+Book
!<u>Title</u>
!Author
!Author Nationality
!<u>Format</u>
!Price
!Pages
!Thickness
!Publisher
!Publisher Country
!Genre ID
!Genre Name
|-=
|Beginning MySQL Database Design and Optimization
|Chad Russell
|American
|Hardcover
|49.99
|520
|Thick
|Apress
|USA
|1
|Tutorial
|}
{| class="wikitable"
|+'''Title - Subject'''
!'''<u>Title</u>'''
!'''<u>Subject name</u>'''
|-
|Beginning MySQL Database Design and Optimization
|MySQL
|-
|Beginning MySQL Database Design and Optimization
|Database
|-
|Beginning MySQL Database Design and Optimization
|Design
|}

Instead of one table in [[unnormalized form]], there are now two tables conforming to the 1NF.