ok
TABLE BOOK CREATE TABLE books ( bookid INT PRIMARY KEY, author_name VARCHAR(255), book_name VARCHAR(255), price DECIMAL(10, 2), quantity INT ); USER CREATE TABLE users ( user_id INT PRIMARY KEY, username VARCHAR(255), useremail VARCHAR(255), userpassword VARCHAR(255), usernick_name VARCHAR(255) ); BOOK_TRANSECTION CREATE TABLE book_transactions ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, book_id INT, user_id INT, transaction_type ENUM('issue', 'return', 'renew'), transaction_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, expiry_date TIMESTAMP, FOREIGN KEY (book_id) REFERENCES books(bookid), FOREIGN KEY (user_id) REFERENCES users(user_id) ); ISSUED BOOK import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQL...