Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started