Database Normalization Process for Home Library Table

Title Page
1

Table of Contents
Background......................................................................................................................................3
Database Normalization...................................................................................................................3
Task 1...........................................................................................................................................3
Task 2...........................................................................................................................................4
Task 3...........................................................................................................................................4
References........................................................................................................................................6
2

Background
The aim of this paper is to present the step by step normalization process applied on the given
Home Library table. Normalization in the context of databases, is a process that restructures a
database to reduce create, update, and delete or CUD anomalies from the database (Fong, 2015),
(Christopher Allen, 2013). It also helps in optimizing the physical database design by reducing
redundancy and by improving the data integrity. Data normalization process has some normal
forms and each normal form has certain rules. When a database is restructured and fulfills the
rules of a normal form, then the database is said to be in that normal form (Harrington, 2016). In
this assignment, normalization up to 3NF or third normal form has been considered.
The given Home Relation table is,
ISBN Title Author_LastName Author_FirstName Publisher Date Edition Media
369852 Cosmos Sagan Carl Random House 1980 1 Book
741258 No Secrets Simon Carly Elektra 1972 1 CD
654789 Symphony No 3 Dur Eroica Op
55 Beethoven Ludwig 1805 1 CD
789654 On the Decay of the Art of Lying Twain Mark Project
Gutenberg 1880 1 eBook
258963 The Adventures of Sherlock
Holmes Conan Doyle Arthur Project
Gutenberg 1 eBook
125896 The Divine Comedy Alighieri Dante Project
Gutenberg 1 eBook
357951 The Hitchhikers Guide to the
Galaxy Adams Douglas Pan books 1979 1 Book
852369 The Return of the King,
Soundtrack Shore Howard Reprise 2003 1 CD
831975 Unseen Academicals Pratchett Terry Doubleday 2009 1 Book
Currently, the relation Home Library has not fulfilled the condition of any normal form.
Database Normalization
Task 1
An FDD or Functional Dependency Diagram shows the functional dependencies of a relation in
a graphical format. A functional dependency constraint exists between two sets of attributes of a
relation. One set must functionally determine the other set (Silberschatz, Korth, & Sudarshan,
2014).
3