Question: This is the backbone for your database. Start a transaction. Write SQL statements to insert ONE (1) new item. Then, write SQL statement to remove

This is the backbone for your database. Start a transaction.
Write SQL statements to insert ONE (1) new item. Then, write SQL statement to remove item ID = 1;
create database vx.SORRR. create table ITEM(id int NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(35)); create table PURCHASE_id int NOT NULL AUTO_INCREMENT PRIMARY KEYitenir int, quantity int, FOREIGN KEY(item.R REFERENCES ITEM(id)); INSERT INTO ITEM (name) VALUES ("]]' 2 'ANGEL'), ("GARY'); ALTER TABLE ITEM ADD quantitylostock INI: SELECT * FROM ITEM: UPDATE ITEM SET guantityInstask=5 WHERE item.18-15 SELECT * FROM ITEM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
