$\backslash$table$[[\backslash$table$[[$Borrowe$],[$rID$]],\backslash$table$[[$BorrowerN$],[$ame$]],\backslash$table$[[$BorrowerAd$],[$dress$]],\backslash$table$[[$ZipCo$],[$de$]],$City,$\backslash$table$[[$Sta$],[$te$]],\backslash$table$[[$Author$],[$Genre$,],[$GenreDescri$],[$ption$,],[$LoanDate$,],[$DueDate$)]],\backslash$table$[[$PhoneNum$],[$ber$]]],[101,$Alice Monroe,$123$ Maple St$,56001,\backslash$table$[[$Greenwo$],[$od$]],$MN$,\backslash$table$[[($B$1001,$ The$],[$Secret Garden,$],[1911,$ Frances$],[$Burnett$,$ Novel,$],[$Fictional$],[$prose$,2024-],[01-10,2024-],[01-24),],[($B$1003,1984,],[1949,$ George$],[$Orwell$,$ Sci$-$Fi$,],[$Science$],[$fiction$,2024],[01-15,2024-],[01-29),],[($B$1001,$ The$],[$Secret Garden,$],[1911,$ Frances$],[$Burnett$,$ Novel,$],[$Fictional$],[$prose$,2024-],[02-05,2024-],[02-19)]],555-0101],[102,$Bob Carter,$456$ Pine Ave,$56002,$Pineville,MN$,\backslash$table$[[($B$1002,],[$Dracula$,1897,],[$Bram Stoker,$],[$Horror$,$ Fiction$],[$with horror$],[$themes$,2024-],[01-12,2024-],[01-26)]],555-0102],[103,$Carol White,$789$ Birch Rd$,56003,$Oaktown,MN$,\backslash$table$[[($B$1001,$ The$],[$Secret Garden,$],[1911,$ Frances$],[$Burnett$,$ Novel,$]],555-0103]]$ Fictional prose, $2024-$

$01-17,2024-$

$01-31),$

$($B$1004,$ Pride and Prejudice, $1813,$ Jane Austen,

$\backslash$table$[[\backslash$table$[[$Borrowe$],[$rID$]],\backslash$table$[[$BorrowerN$],[$ame$]],\backslash$table$[[$BorrowerAd$],[$dress$]],\backslash$table$[[\backslash$table$[[$ZipCo$],[$de$]]]],$City,$\backslash$table$[[$Sta$],[$te$]],\backslash$table$[[$BorrowedBoo$],[$ks $($BookID$,],[$Title$,$ Year,$],[$Author$,],[$Genre$,],[$GenreDescri$],[$ption$,],[$LoanDate$,],[$DueDate$)]],\backslash$table$[[$PhoneNum$],[$ber$]]],[,,,,,,\backslash$table$[[$Romance$,],[$Romantic$],[$fiction$,2024-],[02-01,2024-],[02-15)]],],[,,,,,,($B$1005,$ The,$]]$ The Rivertown Library: A Hub of Knowledge and Community

In the heart of the picturesque town of Rivertown, the local library stands as a beacon of knowledge and

community spirit. This beloved institution, with its ivy$-$covered walls and quaint reading rooms, is more

than just a collection of books; it's a place where stories come alive, and learning knows no bounds.

The Quandary of Quaintness

However, beneath its charming exterior, the Rivertown Library faces a modern dilemma. Its book

lending system, while rich in history, is tangled in a web of inefficiency. In this system, every time a

patron borrows a book, a detailed record is created. Imagine a patron, let's say Ms$.$ Alice, borrowing 'The

Secret Garden.$\text{'}$ The system not only notes down 'The Secret Garden' and its vivid world of hidden

wonders but also every detail about Alice $-$ her ID$,$ name, the quiet street she lives on$,$ and even her

phone number.

Now, picture this: Alice loves reading so much that she decides to borrow $\text{'}1984\text{'}$ on her next visit. The

system, diligent yet old$-$fashioned, repeats all her details all over again for this new transaction. This

repetition occurs each time, for every patron, for every book borrowed.

A Web of Connections

The library's system is a tapestry of connections. Each book is a unique world, identified by a code that

unlocks its title, the year it whispered its first words, its creator, and the genre it belongs to$.$ Just like the

genres, each with its unique flavor and essence, are described in the system.

The patrons, the heart of the library, are linked to this tapestry. Their identity is tied not just to their

name but also to where they come from $-$ their address and the ZipCode that pins them on the map of

Rivertown, each ZipCode a thread leading to a specific part of town. And when they borrow a book, the

date they take it and the date they promise to bring it back are carefully noted, completing a circle of

trust.

The Challenge of Change

This tale of Rivertown Library is not just about books and records; it's a reflection of a community's

journey through time. The challenge now is to weave this tapestry of tales and transactions into a more

coherent and efficient form, to transform an aged system into a modern marvel that continues to serve

its community with the same warmth but greater efficacy. $\backslash$table$[[\backslash$table$[[$Borrowe$],[$rID$]],\backslash$table$[[$BorrowerN$],[$ame$]],\backslash$table$[[$BorrowerAd$],[$dress$]],\backslash$table$[[$ZipCo$]],$City,$\backslash$table$[[$Sta$],[$te$]],\backslash$table$[[$BorrowedBoo$],[$ks $($BookID$,],[$Title$,$ Year,$],[$Author$,],[$Genre$,],[$GenreDescri$],[$ption$,],[$LoanDate$,],[$DueDate$)]],\backslash$table$[[$PhoneNum$],[$ber$]]],[,,,,,,\backslash$table$[[$Romance$,],[$Romantic$],[$fiction$,2024-],[02-01,2024-],[02-15)]],],[101,$Alice Monroe,$123$ Maple St$,56001,\backslash$table$[[$Greenwo$],[$od$]],$MN$,\backslash$table$[[($B$1005,$ The$],[$Great Gatsby,$],[1925,$ F$.$ Scott$],[$Fitzgerald$,],[$Novel$,],[$Fictional$],[$prose$,2024-],[02-03,2024-],[02-17)]],555-0101]]$

Task Description:

Convert to Third Normal Form $(3$NF$)$