Question 2 ( 40 points) Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema of Figure 4.6. Specify the keys and referential triggered actions, BOOK \begin{tabular}{|l|l|l|} \hline Book id & Title & Publisher_name \\ \hline BOOK AUTHORS \\ \hline Book_id & Author name \\ \hline \end{tabular} PUBLISHER \begin{tabular}{|l|l|l|} \hline Name & Address & Phone \\ \hline 1 \end{tabular} BOOK COPIES \begin{tabular}{|c|c|c|} \hline Book id Branch id & No_of_copies \\ \hline \end{tabular} BOOK LOANS \begin{tabular}{|c|c|c|c|c|} \hline Book id & Branch id & Card_no & Date_out & Due_date \\ \hlineL & & & \\ \hline & & \end{tabular} LIBRARY BRANCH \begin{tabular}{|c|c|c|} \hline Branch id & Branch_name & Address \\ \hline M4 & \end{tabular} Figure 4.6 BORROWER A relational database \begin{tabular}{|l|l|l|l|} \hline Card no & Name & Address & Phone \\ \hline \end{tabular} schema tor a LIBRARY database