Java

TCI-DB Project 1. Create a classes for Author and Book as shown below 2. Book ID and Author ID must be unique and automatic (you just enter O when you insert the data) 3. Your Project should work as Simple Query interpreter and contains the following queries (insert, update, select, delete) for both book and author (use scanner ) 4. Queries are Case-Insensitive 5. Syntax of the queries should be as the following a. Insert Author (0,AutherName) (Note: ID is because it is auto increment) b. Insert Book (0, BookName, AuthorID) (Note: Author must exist before inserting book) C. Select Book (Note: it must return "Book ID, Book Name, Author Name") d. Select Author (Note: it must return "Author ID, Author Name) e. Update Author ( AuthorName ) id=AuthorID f. Update Book ( BookName, AuthorID ) id=BookID g. Delete Author id=AuthorID h. Delete book id=BookID Author Book -ID :int -AuthorName: Auther -ID: int -BookName: String -Author: Auther