Exercise 1

Create a Java application that performs the following queries on the books database:

1. Select all authors from the Authors table.
2. Select a specific author and list all books for that author. Include each books title, year, and ISBN. Order the information chronologically.
3. Select a specific title and list all authors for that title. Order the authors alphabetically by last name and then by first name.
4. 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.

1. Add a new author.
2. Edit the existing information for an author.
3. Add a new title for an author. (Remember that the book must have an entry in the AuthorISBN table).