Modify Exercise 28 to define a complete database manipulation application for the books database….
Modify Exercise 28 to define a complete database manipulation application for the books database. In addition to the querying, the user should be able to edit existing data and add new data to the database (obeying referential and entity integrity constraints). Allow the user to edit the database in the following ways:
a) Add a new author.
b) Edit the existing information for an author.
c) Add a new title for an author. (Remember that the book must have an entry in the Author ISBN table.) Be sure to specify the publisher of the title.
d) Add a new publisher.
e) Edit the existing information for a publisher.
f) For each of the preceding database manipulations, design an appropriate GUI to allow the user to perform the data manipulation.