introduction to database systems

Given relation schemas in a database, use SQL queries to solve the following questions. Tables: 1. Authors-stores information about authors - Columns: - author_id (Primary Key) - first_name - last_name - country - birth_date 2. Books - stores information about books - Columns: - book_id (Primary Key) - title - ISBN - publication_date - publisher_id (Foreign Key) 3. Publishers - stores information about publishers - Columns: - publisher_id (Primary Key) - name - country - website 4. Book_Authors - stores the relationship between books and authors - Columns: - book_id (Foreign Key) - author_id (Foreign Key) 5. Members - stores information about members - Columns: - member_id (Primary Key) - first_name - last_name - email - address 6. Loans-stores information about loans - Columns: - loan_id (Primary Key) - book_id (Foreign Key) - member_id (Foreign Key) - loan_date - return_date Questions (must be answered in SQL queries) 1) list all publisher's names and websites. 2) List all book's book_id published by publisher Pearson, where Pearson is the publisher's name, and assume there is only one publisher named Pearson. 3) find the author_id of author Jane Smith, where Jane is the author's first name and Smith is her last name. 4) find all books' book_id authored by Jane Smith