
✐
✐
“4137X˙CH04˙Akerkar” — 2007/9/17 — 11:02 — page 124 — #6
✐
✐
✐
✐
✐
✐
124 CHAPTER 4 Classification and Association
Customer e-mail Product Price
Pawan pawan@yahoo.ca Bicycle pump $19.99
Pawan pawan@yahoo.ca Bicycle helmet $24.99
Paul paul@gmail.ca Bicycle helmet $24.99
Robert robert@halifax.ca Bicycle pump $19.99
(a) Original database
Customer e-mail Customer Product Product Price
Pawan pawan@yahoo.ca Pawan Bicycle pump Bicycle pump $19.99
Paul paul@gmail.ca Pawan Bicycle helmet Bicycle helmet $24.99
Robert robert@halifax.ca Paul Bicycle helmet
Robert Bicycle pump
(b) Database in 2NF
Table 4.2 Illustration of 2NF
records), but also maintain database integrity. F ...