there should be just one 1NF table in each solution, underscore/underline the primary key only in each table,

INFO332 Database Management Systems Normal Form 1B From Un-normalized to INF (eliminate repeating groups) 1. The Book table is not in INF because it contains a repeating group, represented by fields within the inner pair of parentheses. The repeating group in the Book table means there could be multiple branches having the book in stock. NumInStock refers to the number of copies of the book in stock at a given branch. Book (BookCode, Title, (BranchNum, BranchName, NuminStock)); Given the following dependencies: BookCode Title BranchNum BranchName BookCode, BranchNum NumInStock 2. The Part table is not in INF because it contains a repeating group, represented by the fields in the inner pair of parentheses. The repeating group indicates that a part can be supplied by multiple suppliers. The price of the part may differ from supplier to supplier, thus the price is jointly determined by PartNum and SupplierNum Part (PartNum, Description, (SupplierNum, SupplierName, PartPrice)) Given the following dependencies: PartNum Description SupplierNum SupplierName PartNum, SupplierNum PartPrice 3. Summary Template from Un-normalized to INF. Table Tl is not in INF. (C, D, E) is a repeating group. TI (A, B, (C, D, E)) Given the following Dependencies: AB CD A,CE