A 3.2.5 Worksheet Normal form Answers Key
Part 1: Understanding 1NF | ProductID | ProductName | SupplierID | SupplierName | | A123 | Widget | S1 | Alpha | | A123 | Widget | S2 | Beta | | B456 | Gadget | S3 | Gamma | 3. 1NF violations to identify:CustomerName is not atomic — it holds first name and surname in one cell.Address is not atomic — it holds street, city and state in one cell.PhoneNumbers is not atomic — it holds a repeating group (more than one...