INFO332 Database Management Systems Normal Form 1B

From Un-normalized to 1NF (eliminate repeating groups) 1. The Book table is not in 1NF 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 1NF 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 1NF. Table T1 is not in 1NF. (C, D, E) is a repeating group. T1 (A, B, (C, D, E)) Given the following Dependencies: A B C D A, C E