Figure Five - Partial 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 | Date_Borrowed | |
| 1 | David | Findlay | Davies Lodge | 23 Driven St | Edinburgh | EH5 APE | 0131 555 5579 | david@keithjbrown.co.uk | 1st Dec |
| 2 | Iain | Brown | 54 Home St, |
Edinburgh | EH23 8TF | 0131 555 5580 | iain@keithjbrown.co.uk | 8th Dec |
Borrower Relation
| TransactionNo | cdID |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 4 |
| 2 | 5 |
| 2 | 3 |
Borrowed CDs Relation
| cdID | Artist | Title | Year | Label | No_of_Tracks | Copy |
| 1 | Britney Spears | Britney | 2001 | Jive | 14 | 1 |
| 2 | Pink | Cant Take Me Home | 2002 | LaFace | 15 | 3 |
| 3 | Christina Aguilera | Stripped | 2002 | RCA | 20 | 1 |
| 4 | Darius | Dive In | 2002 | Mercury | 13 | 2 |
| 5 | Will Young | From Now On | 2002 | RCA | 13 | 2 |
CDs Bought Relation