The scenario
A gas station needs to track fuel deliveries from suppliers, storage tank readings, pump/nozzle assignments, and retail sales with line items to manage inventory and POS operations.
What is in this drawing
Read the decisions behind it.
01
Separate Delivery and DeliveryLine for multi-product fuel orders
02
Optional customer relation on Sale for walk-in vs fleet accounts
03
TankReading table records dip readings for reconciliation
Use when designing a database for fuel stations or similar bulk inventory with metered dispensing and point-of-sale.
More like this