1. Which SQL statement inserts data into a table called Projects? a) INSERT Projects ('Content Development', 'Website content development project') b) SAVE INTO Projects (Project Name, Project Description) VALUES ('Content Development', 'Website content development project') c) INSERT INTO Projects (ProjectName, Project Description) VALUES ('Content Development', 'Website content development project') d) INSERT Projects VALUES ('Content Development', 'Website content development project')

Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table in the Ch07_ConstructCo database. (See Figure P7.1.) Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS.

Write the SQL code that will restore the data to its original status: that is, the table should contain the data that existed before you made the changes in Problems 5 and 6.

Perform the following tasks: a. Create an index named ITEM_INDEX1 on the ITEM_NUM column in the ORDER_LINEtable. b. Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEMtable. c. Create an index named ITEM_INDEX3 on the CATEGORY and STOREHOUSE columnsin the ITEM table. d. Create an index named ITEM_INDEX4 on the CATEGORY and STOREHOUSEcolumns in the ITEM table. List categories in descending order.