Question

Write command and queries to create and manipulate records in a table named ‘Products’ with following fields: Product Id |Name of Product| Price |Units Sold
10101| Mouse| 546 |765
10703 |Keyboard |756| 801
10314 |Pen drive |1543 |0
10355| UPS |1897| 109
10434 |Printer| 2200 |75
a. Write SQL commands to create the above table. Set appropriate datatypes for the fields. b. Write a query to insert a new record with the following values.

Answer 1

Answer:

Queries:

a. create table "Products" ("Product Id"Integer,"Name of Product"Varchar,"Price"Integer,"Units Sold"Integer);

b. insert into "Products" ("Product Id","Name of Product","Price",Units Sold") values ('1073','Keyboard',756','801');

insert the details with the command "insert into table name".

Explanation: