DataBase for this problem : https://pastebin.com/CqCbeWxn Please answer ONLY wit

Question

DataBase for this problem : https://pastebin.com/CqCbeWxn

Please answer ONLY with at least 5 different queries! Thank you

Each completely correct, and fairly acceptable (with a different execution/explain plan) query 10 point:s Preparatory steps: a. Given a QITEM table, from the QSALE DB, copy its content into NEWITEM table. b. Make three unrelated but elementary changes (one record update, one new record insert, and one old record delete) making sure you do not leave any duplicates Provide as many different ways (queries) using only plain SQL (no triggers, no Transact or PL/SQL etc.) to accomplish the following task: -compare the tables QITEM and NEWITEM to assess if they are now exactly the same or not.

Explanation / Answer

INSERT INTO NEWITEM SELECT * FROM QITEM;

INSERT INTO qitem VALUES('tiger claws', 'd', 'brown');

UPDATE qitem SET itemcolor='yellow' WHERE itemname = 'compass';

DELETE FROM qitem WHERE itemname = 'camel saddle';

SELECT * FROM qemp;

SELECT * FROM qitem;

SELECT * FROM qdel;

SELECT * FROM qdept;

SELECT * FROM qspl;

SELECT * FROM qitem;

SELECT * FROM NEWITEM;

both are tables have same data.

Let me know if you have any clarifications. Thank you

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.