You are given the following Book Rental information. The da…
You are given the following Book Rental information. The data is currently in First Normal Form (1NF). customer_id (PK) f_Name l_Name email book_id (PK) book_title author_fst author_lst genre rental_date return_date 1 Sarah Johnson alice@at.co 1 The Great Gatsby F. Scott Fitzgerald Fiction 01/10 1/17 1 Sarah Johnson alice@at.co 2 Fahrenheit 451 Ray Bradbury Dystopian 02/15 2/22 2 Mark Smith bob@gmail.com 3 1984 George Orwell Dystopian 1/10 1/17 3 Emily Davis ed@gmail.com 4 To Kill a Mockingbird Harper Lee Fiction 1/15 1/22 4 Lisa White lisa@gmail.com 1 The Great Gatsby F. Scott Fitzgerald Fiction 1/18 1/25 Your job is to complete the following: Normalize this table to Second Normal Form (2NF) by breaking it into three separate tables. Describe the normalization process for 1NF to 2NF. Explain what changes you made at each step and why they were necessary. Present the final set of tables in 2NF