Attempt to insert the following two records into the view We

Attempt to insert the following two records into the view. Were you successful, why or why not?

Solution

CREATE VIEW information
AS
SELECT Supplier_id, product_code, menu_item,description,price,price_increase
FROM Supplier

INSERT INTO information (Supplier_id, product_code, menu_item,description,price,price_increase) values (\'ASP\',\'CD\',22,\'GRILLED GARDEN\',6,7);

INSERT INTO information (Supplier_id, product_code, menu_item,description,price,price_increase) values (\'CBC\',\'GS\',23,\'GRILLED SALAD\',6,7);

Here i have assumed Supplier is the table name with Supplier_id as varchar, product_code as varchar, menu_item as int,description as varchar,price as int,price_increase as int
and in case you have some other definition of the colum type please insert value accordingly
I have created view with name information.