Richard Warr (4/27/2011)
Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in 1NF?
No, but you could normalize the Phone number type.
Defining a table to store the repeating types of phone numbers.
You could start by adding another Table called Phone_Number_Types with an Id coulumn.
Then you could use a lookup table to match the repeating Phone_Numbers to the repeating Phone_Number_Types for each Employee.