I'm having trouble with this quetion can anyone help me undestand how to come to come to the answer.
Add a field named Allocation to the Part table. The allocation is a number representing the number of units of each part that have been allocated to each customer. Set all values of allocation to zero. Calculate the number of units of part number KV29 currently on order. Change the value of allocation for part number KV29to this number. Display all the data in the Part table.
ALTER TABLE Part
ADD Allocation CHAR (0)
SET Allocation= some number
WHERE PartNum= some number