Using the MI database, create an SQL script named MI-Insert-Data.sql to answer p
ID: 3718880 • Letter: U
Question
Using the MI database, create an SQL script named MI-Insert-Data.sql to answer part J J. Write INSERT statements to insert the data shown in Figures 7-60, 7-61, 7-62, 7-63,7-64, 7-65, and 7-66. Using the MI database, create an SQL script named MI-DML-CH07.sql to answer parts K and L K. Write an UPDATE statement to change values of STORE.City from New York City to NYC L. Create and INSERT new data records to record a SHIPMENT and the SHIPMENT_ITEMs for that SHIPMENT Then write a DELETE statement(s) to delete that SHIPMENT and all of the items on that SHIPMENT How many DELETE state- ments did you have to use? Why?Explanation / Answer
If you have any doubts, please give me comment...
J)
INSERT INTO EMPLOYEE VALUES(101, 'Morgan', 'James', 'Executive', '310-208-1401', '310-208-1499', 'James.Morgan@morganimporting.com');
INSERT INTO EMPLOYEE VALUES(102, 'Morgan', 'Jessica', 'Executive', '310-208-1402', '310-208-1499', 'Jessica.Morgan@morganimporting.com');
INSERT INTO EMPLOYEE VALUES(103, 'Williams', 'David', 'Purchasing', '310-208-1434', '310-208-1498', 'David.Williams@morganimporting.com');
INSERT INTO EMLOYEE VALUES(104, 'Gilberson', 'Teri', 'Purchasing', '310-208-1435', '310-208-1498', 'Teri.Gilberson@morganimporting.com');
INSERT INTO EMLOYEE VALUES(105, 'Wright', 'James', 'Receiving', '310-208-1456', '310-208-1497', 'James.Wright@morganimporting.com');
INSERT INTO EMLOYEE VALUES(106, 'Douglas', 'Tom', 'Receiving', '310-208-1457', '310-208-1497', 'Tom.Douglas@morganimporting.com');
INSERT INTO STORE VALUES(1000, 'Eastern Sales', 'Singapore', 'Singapore', '65-543-1233', '65-543-1239', 'Sales@EasternSales.com.sg', 'Jeremy');
INSERT INTO STORE VALUES(1050, 'Eastern Treasures', 'Manila', 'Philippines', '63-2-654-2344', '63-2-654-2349', 'Sales@EasternTreasures.com.ph', 'Gracielle');
INSERT INTO STORE VALUES(1100, 'Jade Antiques', 'Singapore', 'Singapore', '65-543-3455', '65-543-3459', 'Sales@JadeAntiques.com.sg', 'Swee Lai');
INSERT INTO STORE VALUES(1150, 'Andes Treasures', 'Lima', 'Peru', '51-14-765-4566', '51-14-765-4569', 'Sales@AndesTreasurs.com.pe', 'Juan Carlos');
INSERT INTO STORE VALUES(1200, 'Eastern Sales', 'Hong Kong', 'Peoples Republic of China', '852-876-5677', '852-876-5679', 'Sales@EasternSales.com.hk', 'Sam');
INSERT INTO STORE VALUES(1250, 'Eastern Treasures', 'New Delhi', 'India', '91-11-987-6788', '91-11-987-6789', 'Sales@EasternTreasures.com.in', 'Deppinder');
INSERT INTO STORE VALUES(1300, 'European Treasures', 'New York City', 'United States', '800-432-8766', '800-432-8769', 'Sales@EuropeanImports.com.sg', 'Marcello');
//You have to implement Other tables like that
K) UPDATE STORE SET City='NYC' WHERE City='New York City';
L) DELETE FROM SHIPMENT;
Just 1 Delete enough to remove all tuples in SHIPMENT table.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.