Question: Introduction to Database Systems SQL DML Statements. Help please Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER , Type,
Introduction to Database Systems SQL DML Statements. Help please



Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER , Type, Firstname, Lastname, Address, City) INVENTORY (ID, ItemName, Type, MadeInStore, SupplierName ORDERS (ID, Customer_FK, Item FK, Quantity, DeliveryDate) 1. Add the following customers to table CUSTOMERS DailyAverageSold, Price) 150, Individual John, Doe, Main Street, Old City Create a duplicate of table CUSTOMER Populate the new table with all the customer (using a single SQL - 151, Restaurant, Jane Eod, Crossroads, Newtown 2. . Name the new table CUSTOMER BACKUP statement)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
