Normalization of Database Tables

1
Normalization of Database Tables
Name
Institution
Normalization of Database Tables

2
Normalization of Database Tables
1. Dependency diagram
ISB
N
Titl
e
Author_LastNam
e
Author_FirstNam
e
Publishe
r
Dat
e
Editio
n
Medi
a
The title, date and edition are fully dependant on the ISBN of the book,
The media through which the is transitively dependant on the publisher.
2. Decompose the home library into a set of 3NF relations
1st Normal Form – rules
ISBN Title Publisher Date Edition Media
369852 Cosmos Random
House
1980 1 Book
741258 No Secrets Elektra 1972 1 CD
654789 Symphony
No 3 Dur
Eroica Op 55
1805 1 CD
789654 On the Decay
of the art of
Lying
Project
Gutenberg
1880 1 eBook
258963 The
Adventures
of Sherlock
Holmes
Project
Gutenberg
1 eBook
125896 The Devine
Comedy
Project
Gutenberg
1 eBook
357951 The
Hitchhickers
Guide to the
Galaxy
Pan books 1979 1 Book
852369 The Return of
the king,
soundtrack
Reprise 2003 1 CD
831975 Unseen Doubleday 2009 1 Book

3
Normalization of Database Tables
Academicals
AuthorID ISBN Author _LastName Author_FirstName
A1 369852 Sagan Carl
A2 741258 Simon Carly
A3 654789 Beethoven Ludwig
A4 789654 Twain Mark
A5 258963 Conan Doyle Arthur
A6 125896 Alighieri Dante
A7 357951 Adams Douglas
A8 852369 Shore Howard
A9 831975 Pratchett Terry
2nd NormallForm – it must abide by the rules of 1st NormalForm + non-key columns
should be dependent on the primary key Coronel & Morris (2016.
ISBN Title Date Edition PublisherID
369852 Cosmos 1980 1 P1
741258 No Secrets 1972 1 P2
654789 Symphony No 3
Dur Eroica Op
55
1805 1 P3
789654 On the Decay of
the Art of Lying
1880 1 P4
258963 The Adventures
of Sherlock
Holmes
1 P5
125896 The Divine
Comedy
1 P6
357951 The
Hitchhickers
Guide to the
Galaxy
1979 1 P7
852369 The Return of
the king,
soundtrack
2003 1 P8
831975 Unseen
Academicals
20009 1 P9
PublisherID Publisher Media
P1 Random House Book