Relational Database Schema

Consider the LIBRARY relational database schema in Figure 4.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 and C or any programming language of your choice or even a pseudo-code