Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. create a table book_store with columns book_id var

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

Other questions asked by students

Q

A football receiver, Harvey Gladiator, is able to catch two thirds of the passes thrown to...

Basic Math
Q

angles are supplementary The first one is done for you Same Side Interior Angles 23...

Geometry
Q

Apply three different colors of data bars to lunch dinner and delivery sales in the...

Basic Math
Q

Which answer describes the transformation of the solid parabol to the dashed parabola Select one...

Algebra
Q

2 3 6 Let A 0 6 0 Given that A 0 0 A and...

Algebra
Q

Shade Company adopted a standard cost system several years ago. The standard costs for direct...

Accounting
Q

here are all the choices you can pick for 1-6 Tony and...

Accounting
Q

3. Company ABC is privately held and has a lot of debt outstanding from the...

Accounting
Q

Supreme Videos, Inc., produces short musical videos for sale to retail outlets. The companys balance...

Accounting
Q

The income statement and a partial balance sheet for Vespoint Company is presented below. Prepare...

Accounting
Q

Bank A pays 2% interest compounded annually on deposits, while Bank B pays 1.25% compounded...

Finance
Q

Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2....

Accounting