Database principles

n-normaized bramch, book, and inventery data talble Branch pe Book Branch Name Lecation Branch Book Title Descriptio Quantit Type Six People in Scarsh Guide to SOL ow6 Riverv s of Wrath 13.0O FIC Fiction Henry On The 1289 2 138X 295 FIC Fictien he Soul of a N1.16 SC 1295 FIC he s of Wrath he Soul of a New 116 SCI 3 3906 enry all ast of Eden odel, Escher, Bach 4.OO PHI of Solomon 140K FIC|Fiction s of Wrath 4 5790 Eastshore Henry astshore Ca-22 FIC Fiction of Solommon 14.00 FIC s of Wrath 13.0O FIC Fiction He wants to design his relational database by following steps in the data normalization process. Before following the steps, he found that there are the following associations (i.e. functional dependencies) for the attributes of branches and books. - Branch Number->Branch Name - Branch Number->Branch Location - Book Code - Book Title - Book Code -Book Price - Book CodeBook Type Book Code> Type Description Book Type >Type Description Branch Number, Book Code->Book Quantity Using the un-normalized data table and the functional dependencies of the attributes, do the following tasks. a. Explain what the First Normal Form ( NF) is. Then convert the un-normalized data table into 1 NF table and explain the nversion process in detail (HINT: you wll need to create o table with data). b. Explain what the Second Normal Form (2 NF) is. Then convert the I NF table created previously into 2 NF tables (HINT: you will need to create 3 tables with data) and explain the conversion process in detail