member has a repeating group: phone1, phone2, phone3. Bring it to 1NF.
memberphone1, phone2, phone3
copy each phone
member_phoneone row per phone
then
membermember_id, name
- Before you start: how many rows will
member_phonehold? - Create
member_phone(member_id, phone). - Copy every phone number into it.
INSERT … SELECT(Chapter 6) takes the rows of a query;UNION ALL(Chapter 9) puts three queries together. - Drop the three phone columns from
member.