Figure Six - Third Normal Form
| TransactionNo | borrowerID | Date_Borrowed | Due_Back |
| 1 | 1 | 1st Dec | 8th Dec |
| 2 | 2 | 8th Dec | 15th Dec |
loans Relation
| borrowerID | Forename | Surname | AddressOne | AddressTwo | City | Postcode | TeleNo | |
| 1 | David | Findlay | Davies Lodge | 23 Driven St | Edinburgh | EH5 APE | 0131 555 5579 | david@keithjbrown.co.uk |
| 2 | Iain | Brown | 54 Home St, |
Edinburgh | EH23 8TF | 0131 555 5580 | iain@keithjbrown.co.uk |
Borrower Relation
| TransactionNo | cdID |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 4 |
| 2 | 5 |
| 2 | 3 |
Borrowed CDs Relation
| cdID | releaseID | Copy |
| 1 | 1 | 1 |
| 2 | 2 | 3 |
| 3 | 3 | 1 |
| 4 | 4 | 2 |
| 5 | 5 | 2 |
| 6 | 6 | 12/12/2002 |
| 7 | 3 | 12/12/2002 |
CDs Bought Relation
| releaseID | Artist | Title | Year | Label | No_of_Tracks |
| 1 | Britney Spears | Britney | 2001 | Jive | 14 |
| 2 | Pink | Cant Take Me Home | 2002 | LaFace | 15 |
| 3 | Christina Aguilera | Stripped | 2002 | RCA | 20 |
| 4 | Darius | Dive In | 2002 | Mercury | 13 |
| 5 | Will Young | From Now On | 2002 | RCA | 13 |
| 6 | Robbie Williams | Escapology | 2002 | Chrysalis |
14 |
CD Releases Relation