Chapter 10 – Inventory Management Template
Exercise 1
While reviewing the Inventory table, we observed that the Assigned To and Requested On columns are being used to capture values that are inconsistent with the column names. The Assigned To column is updated to capture both the requester name and the name of the person to whom the inventory was assigned. Similarly, the Requested On column is used to capture the date of request and the date of assignment.
Now, let's consider the case where the device is a test device or a loaner device and has been assigned to someone. To record that, we need to update the assignment information in the previously mentioned columns. Now, another person in the organization would like to make use of the device whenever it is available and submits a request for the same. Where do you capture this? What if you want to make use of the number of people waiting for a device as an input to decide the quantity to purchase for that device...