In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product, Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storage location...

In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,
Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storage
location and its capacity. Sometimes, a customer may need to come back to pickup their items after
checking out while most of the time they leave the store with their purchases. Which of the following is the
better design for manage transactions?
A) Add an attriute to transaction to indicate whether goods have been pickuped or not
B) Create two subtyeps of Transaction
C) Create a weak entity Pickup to link with Transaction
D) Add a relationship between Transaction and Product