Describe 1NF violation and how to redesign the table to correct it.
|
BookID |
CustID |
Name |
Phone |
DateTimeRented |
DateTimeReturned |
|
1 |
10 |
Henry Lawson |
(802)218-7318 (802)584-8249 |
7/22/2006 7:00:00 PM |
7/23/2006 10:00:00 PM |
|
2 |
3 |
Bob O'Connor |
(802)918-7565 |
7/21/2006 1:00:00 PM |
7/22/2006 5:00:00 PM |
|
3 |
6 |
Cary Jones |
(603)536-8739 |
7/21/2006 6:00:00 PM |
7/22/2006 10:00:00 AM |
|
4 |
4 |
Harry Salomon |
(603)536-7565 |
7/12/2006 10:00:00 AM |
7/13/2006 9:00:00 AM |
|
5 |
5 |
Mary Combs |
(603)536-3632 |
7/17/2006 4:00:00 PM |
7/18/2006 3:00:00 PM |
|
6 |
7 |
Mary Tyler |
(603)669-7431 |
7/10/2006 8:00:00 PM |
7/11/2006 10:00:00 AM |
|
7 |
2 |
Bonnie Artest |
(603)819-0387 |
7/1/2006 5:00:00 PM |
7/2/2006 11:00:00 AM |
|
8 |
9 |
Bobby Lamson |
(603)347-5592 |
7/11/2006 4:00:00 PM |
7/12/2006 10:00:00 PM |
|
9 |
1 |
Lorry Kovacs |
(603)536-0987 (603)536-1294 |
7/23/2006 7:00:00 PM |
7/24/2006 6:00:00 PM |
|
10 |
4 |
Harry Salomon |
(603)536-7565 |
7/20/2006 5:00:00 PM |
7/21/2006 4:00:00 PM |
|
11 |
8 |
Johny Milano |
(603)536-4733 |
7/31/2006 8:00:00 PM |
8/1/2006 6:00:00 PM |
|
12 |
1 |
Lorry Kovacs |
(603)536-0987 |
7/30/2006 1:00:00 PM |
7/30/2006 5:00:00 PM |
|
13 |
2 |
Bonnie Artest |
(603)819-0387 |
7/18/2006 8:00:00 PM |
7/19/2006 2:00:00 PM |
|
14 |
6 |
Cary Jones |
(603)536-8739 |
7/16/2006 6:00:00 PM |
7/17/2006 3:00:00 PM |
|
15 |
9 |
Bobby Lamson |
(603)347-9225 |
7/25/2006 1:00:00 PM |
7/26/2006 11:00:00 AM |
Describe 1NF violation and how to redesign the table to correct it.
Step by step
Solved in 3 steps with 2 images
