How to Prevent Duplicate POS Sales from Skewing Inventory with Python and SQLite

A point-of-sale register sells two pairs of boots. The inventory worker deducts two units and commits...