$$ Please reference the above E$-$R Modeling table structures in your textbook page $11$ Figure$1-5$ or the above Figure$1-5$ to briefly answer below questions$\mathrm{.}1.$ Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? $(20$ points$)$FIGURE $1-5$ JustLee Books's table structures after normalization

$2.$ How would you determine which orders have not yet been shipped to the customer? $(20$ points$)$

$3.$ If management needed to determine which book category generated the most sales in April $2009,$ which tables and fields would they consult to derive this information? $(20$ points$)$

$4.$ Explain how you would determine how much profit was generated from orders placed in April $2009.(20$ points$)$

$5.$ If a customer inquired about a book written in $2003$ by an author named Thompson, which access path $($tables and fields$)$ would you need to follow to find the list of books meeting the customer's request? $(20$ points$)$