SQL 1. Inventory Control Management Database; variety of required products, inventory turnovers, increase and decrease in stock levels, raw material prices, storage information, insurance information, tax information, etc. It is a system of information. You are requested to design a Database (DB) schema that includes Inventory Control Management considerations: a. In the system in question, there are tables T_MATERIAL(MATERIAL_NU, MATERIAL_NAME, PURCHASE_PURCHASING_DATE, STOCK_QUANTITY, MATERIAL_DESCRIPTION), T_VEHICLES(VEHICLE_NU, VEHICLE_NAME, VEHICLE_TYPE) and T_MATERIAL_VEHICLE(VEHICLE_NU, MATERIAL_NU, DESCRIPTION). (ASSIGN PRIMARY AND FOREIGN KEYS.) b. Draw the entity-relationship (ER) diagram between the T_MATERIAL and T_VEHICLES entity sets. Determine the type of relationship between entity sets and indicate which properties in entity-relationship sets can be selected as keys. (20 points). c. Convert the ER diagram you created into tables. (15 points). D. Just write the SQL CREATE TABLE command, which will create the T_MATERIAL_VEHICLE entity set, taking into account the relationships between the tables. (15 points). to. Just write the Data Input (INSERT) SQL command that will enter the following three data into the T_MALZEME_ARAC entity set. (15 points). T_MATERIAL_VEHICLE VEHICLE_NU MATERIAL_NU DESCRIPTION 06ERT9999 - 1 - It will be mounted on the engine of the vehicle. 34 ERT9999 - 2 - This piece is local. 35ERT9999 - 1 - It will be mounted on the engine of the vehicle. f. Just write the SQL command that updates (UPDATE) the VEHICLE_NU of the 1st record in the T_MATERIAL_VEHICLE table to 01ERT999. (15 points). g. Just write 1 order by, 1 query containing =,<,> and 1 distinct SQL query command with the T_MATERIAL_VEHICLE diagram structure SELECT command. (20 points).