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.
3.  

Transcribed Image Text:

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 9RJW General Public Library 10 Washington State University Library 11 Washington State University Library 12 Mercer County Library 13 University of Oakland Libraries 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- 206 323-4983 2 Bellevue Ave.,Seattle, WA, USA,ZIP-98122, Ph- 206 434-4949 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 Cellular Biology Physics Foundations, 1st Ed Physics Foundations, 2nd Ed Programming Essentials - Book 1 Programming Essentials - Book 2 Calculus Organic Chemistry Organic Chemistry How to Draw Easily Who Killed Roger Rabbit 1ST_AUTHOR Chichikov,Cynthia P. Tagore, Rabindranath Tagore, Rabindranath McMillan, Robert N. Overbeek, Paul S. Mulligan, Jack R. Mulligan, Jack R. Peterson, Franco Y. Murphy, Nancy Wilson Victor Lawson, Larry Lawson, Larry 2ND AUTHOR Mironov, Zeni Dawson, Crowley Doyle, Arthur Conan Smith, Janko Smith, Janko Schuster, Simon Schuster, Simon 3RD_AUTHOR Smith, Simon White, Laura Doyle, Robert Doyle, Robert PUBLICATIO N_YEAR 2005 2005 1945, 1978 2006 2003 2003 1999 1999 2020 2013 2013 2017, 2019 1967 DEWEY_ID BOOK_BINDING 500.3000 Leather 203.2200 Hard Bound 203.2200 Paper Back 610.3902 Leather. 546.2020 Paper Back 546.2020 Paper Back 334.2300 Paper Back 334.2301 Hard Bound 333.2765 Paper Back 334.2828 Paper Back 334.2828 Paper Back Hard Bound, Leather, Paper 122.9800 Back Hard Bound, 126.2670 Paper Back BOOK_CONDITION Excellent Excellent Excellent Excellent Good Excellent Poor Poor Excellent Excellent Good Good 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 9RJW General Public Library 10 Washington State University Library 11 Washington State University Library 12 Mercer County Library 13 University of Oakland Libraries 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- 206 323-4983 2 Bellevue Ave.,Seattle, WA, USA,ZIP-98122, Ph- 206 434-4949 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 Cellular Biology Physics Foundations, 1st Ed Physics Foundations, 2nd Ed Programming Essentials - Book 1 Programming Essentials - Book 2 Calculus Organic Chemistry Organic Chemistry How to Draw Easily Who Killed Roger Rabbit 1ST_AUTHOR Chichikov,Cynthia P. Tagore, Rabindranath Tagore, Rabindranath McMillan, Robert N. Overbeek, Paul S. Mulligan, Jack R. Mulligan, Jack R. Peterson, Franco Y. Murphy, Nancy Wilson Victor Lawson, Larry Lawson, Larry 2ND AUTHOR Mironov, Zeni Dawson, Crowley Doyle, Arthur Conan Smith, Janko Smith, Janko Schuster, Simon Schuster, Simon 3RD_AUTHOR Smith, Simon White, Laura Doyle, Robert Doyle, Robert PUBLICATIO N_YEAR 2005 2005 1945, 1978 2006 2003 2003 1999 1999 2020 2013 2013 2017, 2019 1967 DEWEY_ID BOOK_BINDING 500.3000 Leather 203.2200 Hard Bound 203.2200 Paper Back 610.3902 Leather. 546.2020 Paper Back 546.2020 Paper Back 334.2300 Paper Back 334.2301 Hard Bound 333.2765 Paper Back 334.2828 Paper Back 334.2828 Paper Back Hard Bound, Leather, Paper 122.9800 Back Hard Bound, 126.2670 Paper Back BOOK_CONDITION Excellent Excellent Excellent Excellent Good Excellent Poor Poor Excellent Excellent Good Good Good