Question: Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema shown below. BOOK begin{tabular}{|l|l|l|} hline Book_id & Title & Publisher_name hline end{tabular}

Write appropriate SQL DDL statements for

Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema shown below. BOOK \begin{tabular}{|l|l|l|} \hline Book_id & Title & Publisher_name \\ \hline \end{tabular} BOOK_AUTHORS \begin{tabular}{|l|l|} Book_id & Author_name \\ \hline \end{tabular} PUBLISHER \begin{tabular}{|c|c|c|} \hline Name & Address & Phone \\ \hline \end{tabular} BOOK_COPIES \begin{tabular}{|l|l|l|} \hline Book_id & Branch_id & No_of_copies \\ \hline \end{tabular} BOOK_LOANS \begin{tabular}{|l|l|l|l|l|} \hline Book_id & Branch_id & Card_no & Date_out & Due_date \\ \hline \end{tabular} LIBRARY_BRANCH \begin{tabular}{|c|c|c|} \hline Branch_id & Branch_name & Address \\ \hline \end{tabular} BORROWER \begin{tabular}{|c|l|l|l|} \hline Card_no & Name & Address & Phone \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!