Question: An examination of the UCL's Inventory Management module reporting requirements uncovered the following problems: The Inventory module generates three reports, once of which is
An examination of the UCL's Inventory Management module reporting requirements uncovered the following problems:
• The Inventory module generates three reports, once of which is an Inventory Movement Report. But the inventory movements are spread across two different entities (CHECK_OUT and WITHDRAW). That spread makes it difficult to generate the output and reduces the system's performance.
• An item's quantity on hand is updated with an inventory movement that can represent a purchase, a withdrawal, a check-out, a check-in, or an inventory adjustment. Yet only the withdrawals and check-outs are represented in the system.
What solution was proposed for that set of problems? How would such a solution be useful in other types of inventory environments?
Step by Step Solution
3.33 Rating (168 Votes )
There are 3 Steps involved in it
The proposed solution was to create a common entry point for all inventory movements This common entry point is represented by a new entity named INVTRANS The INVTRANS entity is used to record an entr... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help