1. How to apply the rules of normalization and normalize the data and display the 1NF, 2NF and 3NF Table structure with Table Names. For each step of normalization, please explain the basis. 
2. How to identify Primary Key and Foreign Key for each step, wherever applicable.

I
 

Transcribed Image Text:

1ST_AUTHOR 2ND_AUTHOR 3RD_AUTHOR PUBLICATIO N_YEAR DEWEY_ID BOOK_BINDING BOOK_CONDITION Chichikov,Cynthia P. Mironov, Zeni Tagore, Rabindranath 2005 2005 500.3000 Leather Excellent 203.2200 Hard Bound Excellent Tagore, Rabindranath 1945, 1978 203.2200 Paper Back Excellent Cellular Biology McMillan, Robert N. Overbeek, Paul S. Smith, Simon 2006 610.3902 Leather Excellent Physics Foundations, 1st Ed Physics Foundations, 2nd Ed Mulligan, Jack R. Smith, Janko 2003 546.2020 Paper Back Good Mulligan, Jack R. Smith, Janko White, Laura 2003 546.2020 Paper Back Excellent Programming Essentials - Book 1 Programming Essentials - Book 2 Calculus Peterson, Franco Y. 1999 334.2300 Paper Back Poor Murphy, Nancy Wilson Victor 1999 2020 334.2301 Hard Bound 333.2765 Paper Back Poor Excellent Organic Chemistry Lawson, Larry Schuster, Simon Organic Chemistry Lawson, Larry Schuster, Simon Doyle, Robert Doyle, Robert 2013 334.2828 Paper Back Excellent 2013 334.2828 Paper Back Hard Bound, Leather, Paper Good How to Draw Easily Who Killed Roger Rabbit Dawson, Crowley Doyle, Arthur Conan 2017, 2019 122.9800 Back Good 1967 Hard Bound, 126.2670 Paper Back Good SI No. LIBRARY_NAME 1 University of Oakland Libraries 2 University of Oakland Libraries 3 University of Oakland Libraries 4 Apple Charities Public Libraries 5 Apple Charities Public Libraries 6 RJW General Public Library 7 RJW General Public Library 8 RJW General Public Library 9 RJW General Public Library LIBRARY_ADDRESS 309 63rd St. # 411,Oakland, CA, USA, ZIP-94618 5420 Telegraph Av., Oakland, CA, USA, ZIP-94609 5420 Telegraph Av.,Oakland, CA, USA, ZIP-94609 309 63rd St. #411,Oakland, CA, USA, ZIP-94618 33, Spring Brook Road, East Windsor, USA, ZIP- 08520 2190 Robins St., Palo Alto, CA, USA, ZIP-94301 2190 Robins St., Palo Alto, CA, USA, ZIP-94301 2190 Robins St., Palo Alto, CA, USA,ZIP-94301 2190 Robins St.,Palo Alto, CA, USA, ZIP-94301 18 Thud Dr. S.,Seattle, WA, USA,ZIP-98198, Ph- 10 Washington State University Library 206 323-4983 2 Bellevue Ave.,Seattle, WA, USA, ZIP-98122, Ph- 11 Washington State University Library 206 434-4949 12 Mercer County Library 13 University of Oakland Libraries 33, West Side Road, Hightstown, NJ 08520, Ph- 201 323-3333 5420 Telegraph Av., Oakland, CA, USA, ZIP-94609 BOOK_TITLE History of England Geetanjali Geetanjali 1ST_AUTHOR 2ND_AUTHOR 3RD_AUTHOR PUBLICATIO N_YEAR DEWEY_ID BOOK_BINDING BOOK_CONDITION Chichikov,Cynthia P. Mironov, Zeni Tagore, Rabindranath 2005 2005 500.3000 Leather Excellent 203.2200 Hard Bound Excellent Tagore, Rabindranath 1945, 1978 203.2200 Paper Back Excellent Cellular Biology McMillan, Robert N. Overbeek, Paul S. Smith, Simon 2006 610.3902 Leather Excellent Physics Foundations, 1st Ed Physics Foundations, 2nd Ed Mulligan, Jack R. Smith, Janko 2003 546.2020 Paper Back Good Mulligan, Jack R. Smith, Janko White, Laura 2003 546.2020 Paper Back Excellent Programming Essentials - Book 1 Programming Essentials - Book 2 Calculus Peterson, Franco Y. 1999 334.2300 Paper Back Poor Murphy, Nancy Wilson Victor 1999 2020 334.2301 Hard Bound 333.2765 Paper Back Poor Excellent Organic Chemistry Lawson, Larry Schuster, Simon Organic Chemistry Lawson, Larry Schuster, Simon Doyle, Robert Doyle, Robert 2013 334.2828 Paper Back Excellent 2013 334.2828 Paper Back Hard Bound, Leather, Paper Good How to Draw Easily Who Killed Roger Rabbit Dawson, Crowley Doyle, Arthur Conan 2017, 2019 122.9800 Back Good 1967 Hard Bound, 126.2670 Paper Back Good SI No. LIBRARY_NAME 1 University of Oakland Libraries 2 University of Oakland Libraries 3 University of Oakland Libraries 4 Apple Charities Public Libraries 5 Apple Charities Public Libraries 6 RJW General Public Library 7 RJW General Public Library 8 RJW General Public Library 9 RJW General Public Library LIBRARY_ADDRESS 309 63rd St. # 411,Oakland, CA, USA, ZIP-94618 5420 Telegraph Av., Oakland, CA, USA, ZIP-94609 5420 Telegraph Av.,Oakland, CA, USA, ZIP-94609 309 63rd St. #411,Oakland, CA, USA, ZIP-94618 33, Spring Brook Road, East Windsor, USA, ZIP- 08520 2190 Robins St., Palo Alto, CA, USA, ZIP-94301 2190 Robins St., Palo Alto, CA, USA, ZIP-94301 2190 Robins St., Palo Alto, CA, USA,ZIP-94301 2190 Robins St.,Palo Alto, CA, USA, ZIP-94301 18 Thud Dr. S.,Seattle, WA, USA,ZIP-98198, Ph- 10 Washington State University Library 206 323-4983 2 Bellevue Ave.,Seattle, WA, USA, ZIP-98122, Ph- 11 Washington State University Library 206 434-4949 12 Mercer County Library 13 University of Oakland Libraries 33, West Side Road, Hightstown, NJ 08520, Ph- 201 323-3333 5420 Telegraph Av., Oakland, CA, USA, ZIP-94609 BOOK_TITLE History of England Geetanjali Geetanjali