I need a solution to (revised Exercise 24-2) in Deitel\'s JAVA How to Program 10

Question

I need a solution to (revised Exercise 24-2) in Deitel's JAVA How to Program 10th Ed. I do NOT require the JComboBox as stated in text.

Define a complete query application for the books database. Provide the following queries:

a. Select all authors from the Authors table.

b. Select a specific author and list all books for that author. Include each book's title, year and ISBN. Order the information alphabetically by the author's last name then by first name.

c. Select a specific title and list all authors for that that title. Order the authors alphabetically by last name then by first name.

Explanation / Answer

The below query is oracle specific. Since, the structure of table is not given, I have taken Book_ID as primary key for table book and author_Id as primary key for author table, Both are foreign key in the opposite.

Please find the query below:

a> select author_first_name, author_last_name from author;

b>select b.author_last_name, b.author_first_name, a.book_title, a.book_year,a.ISBN
from book a, author b
where a.author_id=b.author_id(+)
order by b.author_last_name, b.author_first_name;

c>select a.book_title, b.author_last_name, b.author_first_name from from book a, author b
where a.book_id(+)=b.book_id
order by b.author_last_name, b.author_first_name;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.