f

If a database contains the tables below, it will have a limitation in that the structure implemented would not allow multiple items to be rented for the same transaction.

Modify the structure so that there can be multiple rentals of multiple items.

Draw the relational diagram to show the tables given and the modification made to allow $M$:$N$ relationship between RENTAL and ITEM.

CUSTOMER TABLE

$\backslash$table$[[$Customer$\_$ID$,$PK$],[$Customer$\_$FName,$],[$Customer$\_$LName,$],[$Customer$\_$MI$,]]$

RENTAL TABLE

$\backslash$table$[[$Rental$\_$ID$,$PK$],[$Customer$\_$ID$,$FK$],[$Rental$\_$ChkOut$\_$Date,$],[$Item$\_$ID$,],[$Item$\_$Copy$\_$Number,$],[$Rental$\_$Charge$\_$Day,$],[$Rental$\_$Charge,$],[$Rental$\_$Return$\_$Date,$]]$

ITEM TABLE

$\backslash$table$[[$Item$\_$ID$,$PK$],[$Item$\_$Copy$\_$Number,$],[$Item$\_$Desc,$],[$Item$\_$Cost,$]]$