NORMALIZE ALL DATA BELOW TO 3NF. AND FOR EACH STEP OF THE PROCESS (1NF/2NF/3F)

1. DRAW DEPENDANCE DIAGRAM
2. DESCRIBE NORMALIZATION RULES THAT YOU USED
3. WRITE THE TABLE STRUCTURE IN RELATIONAL NOTATION
4.  

Transcribed Image Text:

Chckout# CheckoutDate BookISBN t3331212 t3331215 t3332122 t3332150 t3332280 2019-09-10 9781430242093 9780929306452 2019-10-10 9781943980482 Title Beginning database d esign Database Administrat The database book : principles & practice Narain using MySQL ors The devil in paradise: 2019-10-15 9780399171123 Captain Putnam in Hawaii 2019-10-24 9780316251303 The burning white AuthorFName AuthorLName 2019-10-28 9780316477406 Perfect shadow Clare Kelly James L. Brent Brent Churcher Gehani Daniels Haley Weeks Weeks Authorinfo senior lecturer, Lincoln University, New York Time bestselling author New York Time bestselling author Publisher apress Silicon Press Seed Learning G. P. Putnam's Sons Orbit Orbit Pub Year Return Date 2012 2019-09-17 2011 2019-09-20 2018 2019-10-20 2019 2019-10-21 2019 2019-10-30 2017 2019-11-08 UserNum UserName 1124673 John Doe 1124673 John Doe 1124673 John Doe 1125555 Mary Black 1142233 Jessica Johnson 1153312 Jack Lee UserEmail jdoe@gmail.com jdoe@gmail.com jdoe@gmail.com mblack@gmail.com jjohnson@shaw.ca jlee@shaw.ca Chckout# CheckoutDate BookISBN t3331212 t3331215 t3332122 t3332150 t3332280 2019-09-10 9781430242093 9780929306452 2019-10-10 9781943980482 Title Beginning database d esign Database Administrat The database book : principles & practice Narain using MySQL ors The devil in paradise: 2019-10-15 9780399171123 Captain Putnam in Hawaii 2019-10-24 9780316251303 The burning white AuthorFName AuthorLName 2019-10-28 9780316477406 Perfect shadow Clare Kelly James L. Brent Brent Churcher Gehani Daniels Haley Weeks Weeks Authorinfo senior lecturer, Lincoln University, New York Time bestselling author New York Time bestselling author Publisher apress Silicon Press Seed Learning G. P. Putnam's Sons Orbit Orbit Pub Year Return Date 2012 2019-09-17 2011 2019-09-20 2018 2019-10-20 2019 2019-10-21 2019 2019-10-30 2017 2019-11-08 UserNum UserName 1124673 John Doe 1124673 John Doe 1124673 John Doe 1125555 Mary Black 1142233 Jessica Johnson 1153312 Jack Lee UserEmail jdoe@gmail.com jdoe@gmail.com jdoe@gmail.com mblack@gmail.com jjohnson@shaw.ca jlee@shaw.ca

Answer rating: 100% (QA)

1 Normalization Rules 1NF A table is in 1NF if it has no ... View the full answer