Create a table book_store with columns Book_id VARCHAR(255) NOT NULL, Book_Name VARCHAR(255) NOT NULL, Book_genre VARCHAR(255) NOT NULL, Status...

80.2K

Verified Solution

Question

Programming

Create a table book_store with columns Book_idVARCHAR(255) NOT NULL,
Book_Name VARCHAR(255) NOT NULL,
Book_genre VARCHAR(255) NOT NULL,
Status VARCHAR(255) NOT NULL,
PRIMARY KEY (Book_id)
Create a table book with columns Book_idVARCHAR(255) NOT NULL,
Book_Name VARCHAR(255) NOT NULL,
Book_release integer,
Book_price integer ,
Publisher Varchar(10),
Book_genre VARCHAR(255) NOT NULL,
PRIMARY KEY (Book_id)
CREATE TABLE price_logs withcolumns id INT(11) NOT NULL AUTO_INCREMENT,
Book_id VARCHAR(255) NOT NULL,
Old_Book_price DOUBLE NOT NULL,
New_Book_price DOUBLE NOT NULL,
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ONUPDATE CURRENT_TIMESTAMP,
updated_by varchar(30) NOT NULL,
PRIMARY KEY (id),
KEY Book (Book_id),
CONSTRAINT price_logs_ibfk_1 FOREIGN KEY (Book_id) REFERENCESBook (Book_id) ON DELETE CASCADE ON UPDATE CASCADE
Update Trigger: Create a trigger torecord/insert the price in price_logs table before updating thebook table . Also record the user who updated the price.

Answer & Explanation Solved by verified expert

4.1 Ratings (563 Votes)

Hello Student below is your sql queries to your questions Please make sure to like my work it really motivates me 1 Create a table bookstore CREATE TABLE bookstore Bookid VARCHAR255 NOT NULL BookName VARCHAR255 NOT See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member