Editing Database normalization (section)

=== Initial data ===
Let a database table exist with the following structure:<ref name=":0" />
{| class="wikitable"
!Title
!Author
!Author Nationality
!Format
!Price
!Subject
!Pages
!Thickness
!Publisher
!Publisher Country
!Genre ID
!Genre Name
|-
|Beginning MySQL Database Design and Optimization
|Chad Russell
|American
|Hardcover
|49.99
|
{| class="wikitable"
|MySQL
|-
|Database
|-
| Design
|}
|520
|Thick
|Apress
|USA
|1
|Tutorial
|}

For this example it is assumed that each book has only one author.

A table that conforms to the relational model has a [[primary key]] which uniquely identifies a row. In our example, the primary key is a [[composite key]] of '''{Title, Format}''' (indicated by the underlining):

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