Q1. Transform the solution for problem 3 into a logical model

NOTE: These problems are the same from lab 1 as found on the PPT Practicing Data Modeling Answers.

In the context specified above in problem 1 and problem 2, better information is needed regarding the relationship between a book and its authors. Specifically, it is important to record the percentage of the royalties that belong to a specific author, whether or not a specific author is a lead author of the book, and each authors position in the sequence of the books authors.

\begin{tabular}{|c|c|c|} \hline & & \multirow{2}{*}{\begin{tabular}{|c|c|} AUTHOR \\ Author Number \\ \end{tabular}} \\ \hline & & \\ \hline & & Name \\ \hline & & Date of Birth \\ \hline & & \\ \hline & RoyaltyPctLeadAuthor?SequenceNumber & \\ \hline \end{tabular} Problem 3: Solution