WRITE A QUERY TO DISPLAY THE AUTHOR LAST NAME, FIRST NAME, BOOK TITLE, AND YEAR

Question

WRITE A QUERY TO DISPLAY THE AUTHOR LAST NAME, FIRST NAME, BOOK TITLE, AND YEAR FOR EACH BOOK Question is from Database systems 12th edition, chp_08 Question_50P. I need a query in correct MySQL syntax. Thanks

Ch FIGURE P CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check Out Date Check Due Date Check In Date Pat FName Pat LName Pat Type BOOK AUTHOR PK Book Num PK Au ID Book Title O Book Year Book Cost Book Subject Au_FName Au LName Au BirthYear FK1 Pat ID WRITES PK,FK1 Book Num in the PATRON table.

Explanation / Answer

Three tables AUTHOR, WRITES and BOOK are to joined using concept of primary and foreign key

Below mysql query

select Au_FName as AU_FNAME, Au_LName as AU_LNAME, Book_Title as BOOK_TITLE ,

Book_Year as BOOK_YEAR from AUTHOR as a , WRITES as w , BOOK as b where

a.AU_ID = w. AU_ID and b.Book_Num = w.Book_Num;

Above mysql queries can solved using inner join approach also.

Solution 51.

select Pat_ID , Book_Num, Pat_FNam , Pat_LNam from PATRON inner join CHECKOUT on

PATRON.Pat_ID = CHECKOUT.Pat_ID ;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.