$4\mathrm{.}2$ Most DBMS packages contain data definition, data manipulation, and data query languages.

Required

For each of the following, indicate which language would be used and why.

a$.$ The inventory serial number field is extended in the inventory records to allow for recognition of additional inventory items with serial numbers containing more than $10$ digits.

b$.$ A database administrator defines the logical structure of the database.

c$.$ The manager of inventory control requests a report of all inventory items whose Qu$$ntityOnHand is below the ReorderPoint.

d$.$ An accountant uses RPA to write a bot to update the fixed$-$assets records stored in the database.

e$.$ The human resources manager requests a report noting all employees who are retiring within five years.

f$.$ A user develops a program to print out all purchases made during the past two weeks.

g$.$ An additional field is added to the fixed$-$asset records to record the estimated salvage value of each asset.