Figure Two - Problematic First Normal Form
| TransactionNo |
Forename |
Surname |
AddressOne |
AddressTwo |
City |
Postcode |
TeleNo |
E-mail |
Artist |
Title |
Year |
Label |
No_of_Tracks |
Copy |
Date_Borrowed |
Due_Back |
| 1 |
David |
Findlay |
Davies Lodge |
23 Driven St |
Edinburgh |
EH5 APE |
0131 555 5579 |
david@keithjbrown.co.uk |
Britney Spears |
Britney |
2001 |
Jive |
14 |
1 |
1st Dec |
8th Dec |
| 1 |
David |
Findlay |
Davies Lodge |
23 Driven St |
Edinburgh |
EH5 APE |
0131 555 5579 |
david@keithjbrown.co.uk |
Pink |
Cant Take Me Home |
2002 |
LaFace |
15 |
3 |
1st Dec |
8th Dec |
| 1 |
David |
Findlay |
Davies Lodge |
23 Driven St |
Edinburgh |
EH5 APE |
0131 555 5579 |
david@keithjbrown.co.uk |
Christina Aguilera |
Stripped |
2002 |
RCA |
20 |
1 |
1st Dec |
8th Dec |
| 2 |
Iain |
Brown |
54 Home St,
|
|
Edinburgh |
EH23 8TF |
0131 555 5580 |
iain@keithjbrown.co.uk |
Darius |
Dive In |
2002 |
Mercury |
13 |
2 |
8th Dec |
15th Dec |
| 2 |
Iain |
Brown |
54 Home St,
|
|
Edinburgh |
EH23 8TF |
0131 555 5580 |
iain@keithjbrown.co.uk |
Will Young |
From Now On |
2002 |
RCA |
13 |
2 |
8th Dec |
15th Dec |
| 2 |
Iain |
Brown |
54 Home St,
|
|
Edinburgh |
EH23 8TF |
0131 555 5580 |
iain@keithjbrown.co.uk |
Christina Aguilera |
Stripped |
2002 |
RCA |
20 |
1 |
8th Dec |
15th Dec |