A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B) Use a view that creates anInStock field as part of an aggregate query.
C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.