Consider the library relational database schema in Figure 6.6. Write a program segment that retrieves the list of books that became overdue yesterday and that prints the book title and borrower name for each. Use embedded SQL with C as the host language.

Figure 6.6

Transcribed Image Text:

BOOK Book id Title Publisher_name ВОOK AUTHORS Book id Author_name PUBLISHER Name Address Phone ВОOK COPIES Book id Branch_id No_of_copies ВОOK LOANS Book id Branch id Card_no Date_out Due_date LIBRARY_BRANCH Branch_id Branch_name Address BORROWER Card no Name Address Phone