Each convict has a unique number $($stenciled on all clothing$).$ For each convict, we need to know the convict's name and date of birth. Some convicts are in jail for multiple crimes. Some convicts are in jail for only one crime. For each crime, we need to know the name of the crime and how many years they are sentenced for that crime.

Example: Al Capone $\backslash$#$123$ dob: Jan $12,1888$ was convicted of Murder $25$ years $-$ Arson $20$ years $-$ Robbery $10$ yrs$.$

The library has many books. Each book in the library has a unique number. So each copy of "War and Peace" has a different unique number. Each book has only one genre $($comedy$,$ drama, history, business$).$ For example: The book "Bomb Making $101"$ has a genre or CAREER$-$ADVANCEMENT For each book, we want to maintain that book's condition $($GOOD$,$ BAD, RIPPED$).$

You also need to have a record of all library transactions. For example, convict $123$ borrowed book $987$ on $\backslash (1/1/2015\backslash )$ and returned it on $2/2/2015.$ If the return date is null, that mean the convict still has the book.

Design the $3$NF tables necessary for this problem: Clearly indicate the field$($s$)$ and the primary key$($s$).$