Editing Database normalization (section)

=== Satisfying 3NF ===
The '''Book''' table still has a transitive functional dependency ({Author Nationality} is dependent on {Author}, which is dependent on {Title}). Similar violations exist for publisher ({Publisher Country} is dependent on {Publisher}, which is dependent on {Title}) and for genre ({Genre Name} is dependent on {Genre ID}, which is dependent on {Title}). Hence, the '''Book''' table is not in 3NF. To resolve this, we can place {Author Nationality}, {Publisher Country}, and {Genre Name} in their own respective tables, thereby eliminating the transitive functional dependencies:
{| class="wikitable"
|+Book
!<u>Title</u>
!Author
!Pages
!Thickness
!Publisher
!Genre ID
|-
|Beginning MySQL Database Design and Optimization
|Chad Russell
|520
|Thick
|Apress
|1
|-
|The Relational Model for Database Management: Version 2
|E.F.Codd
|538
|Thick
|Addison-Wesley
|2
|}

{|
|
{| class="wikitable"
|+Price
!<u>Title</u>
!<u>Format</u>
!Price
|-
|Beginning MySQL Database Design and Optimization
|Hardcover
|49.99
|-
|Beginning MySQL Database Design and Optimization
|E-book
|22.34
|-
|The Relational Model for Database Management: Version 2
|E-book
|13.88
|-
|The Relational Model for Database Management: Version 2
|Paperback
|39.99
|}
|}
{| class="wikitable"
|+Author
!<u>Author</u>
!Author Nationality
|-
|Chad Russell
|American
|-
|E.F.Codd
|British
|}
{| class="wikitable"
|+Publisher
!<u>Publisher</u>
!Country
|-
|Apress
|USA
|-
|Addison-Wesley
|USA
|}
{| class="wikitable"
|+Genre
!<u>Genre ID</u>
!Name
|-
|1
|Tutorial
|-
|2
|Popular science
|}