Exercise 1
create a Java application that performs the following queries on the books database:
Select all authors from the Authors table.
Select a specific author and list all books for that author. Include each book's title, year, and ISBN. Order the information chronologically.
Select a specific title and list all authors for that title. Order the authors alphabetically by last name and then by first name.
Provide 2 additional queries of your own choosing that you feel would be appropriate for the books database.
Exercise 2
Create a Java GUI application that allows the user to perform the tasks below on the books database. The user must be able to enter new data and edit existing data using a graphical user interface.
Add a new author.
Edit the existing information for an author.
Add a new title for an author. (Remember that the book must have an entry in the AuthorISBN table).