Exercise 1

Using the techniques shown in the Reading & Study materials, 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 books 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).