Please answer this question fully with every step. I will give a thumbs up if right. This is Database.

Problem 3 Consider the bookstore E-R in Fig 6.30 in the 7 th ed of textbook (Figure 7.29 in 6th edition) which is also attached here. Submit one E-R diagram with the following modifications: 1. Modify the E-R diagram to indicate that a book is published by at most one publisher. 2. Modify the E-R diagram to indicate every book has at least one author. 3. Modify the E-R diagram to indicate that a basket is owned by exactly one customer. (However a customer could have more than one basket.) \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ author } \\ \hline name \\ address \\ URL \\ \hline \end{tabular} \begin{tabular}{|l|} \hline publisher \\ \hline name \\ address \\ phone \\ URL \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline book \\ \hline ISBNtitleprice \\ \hline shopping_bask \\ basket id \\ \hline stocks \\ \hline codeaddressphone \\ \hline \end{tabular}