Question $1$

$[50$ marks$]$

You are an intern at Boston City Campus and have been tasked to create a class called Book with four attributes: title, author, price, and quantity in stock. The class should have set title, author, and price attribute methods. In the set method for the price, you should calculate the sales tax as $5\%$ of the price. Additionally, you must include a display method showing the book's details.

After creating the Book class, you have to write a program that asks the user to input values for five Book objects, which are saved in a MySQL database. The program should prompt the user to enter valid title, author, and price values for each book object before creating it$.$ Once all five book objects have been created, the program should display all their values.

Required

a$.$ Create a MySQL database and create a table for the database based on the scenario above. Add at least five $(5)$ made$-$up records.

$(15$ marks$)$

Rubric

$\backslash$table$[[$Criteria$,$Marks$],[\backslash$table$[[$Appropriate database design based on the scenario $($table$],[$name$,$ attributes, primary key, data types and descriptions$)]],10],[$Five records in the database table,$5]]$

Export your database for submission on Colcampus as your Question $1.$ a$.$

b$.$ Use NetBeans IDE to create a Java Swing application $($GUI$)$ to interact with the database. The application should allow users to enter$/$insert$,$ and view book stocks.

NB Records must be entered into the MySQL table using a graphical user interface $($GUI$)$ desktop application.