Please do this clearly and step by step, easily understandable

1. The table shown below has entries of books, which have been borrowed by children in a small nursery lending library. Child No C002 C025 Child name Child_DOB BOOK_No Copy Date borrowed Book Title Author Also No Borrowed S. Smith 11/03/18 B0470 1 09/08/21 Rain & Cloud T. George DVD B1210 1 08/09/21 Teddy Bears G. Smart Video Game B7777 1 03/03/21 Wild Flowers F. Parker B0470 1 03/03/21 Rain & Cloud T. George Video Game K. Bush 13/06/20 B7777 1 09/07/21 Wild Flowers F. Parker B4433 1 17/08/21 Sewing S. Hunt DVD T. Johns 21/04/19 B1210 2 08/09/21 Teddy Bears G. Smart DVD B3321 1 17/05/21 Wild Flowers M. Venn a) In a stepwise approach derive a set of fully normalised relations (tables), upto the 4th normal form. In your final relation set show clearly the primary keys (underline) and any foreign keys (star). b) Suppose the library wishes to allow the children to reserve books by telephone to be picked up later. Modify and rewrite your relations (only the final set) to incorporate this. Note that a reservation will be for a book title rather than a particular copy. C009