상황
A fuel logistics company needs to track fuel consumption per vehicle, driver, and fuel card across trips and fuel station transactions for cost control and fleet efficiency reporting.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Modeled both Trip and FuelTransaction to separate planned or actual distance from fuel purchases.
02
Linked fuel cards to vehicles to capture card-based purchases per asset.
03
Used a transaction fact table with foreign keys to all reference dimensions to enforce referential integrity.
Reuse when building fleet fuel management databases that must reconcile odometer readings, fuel volumes, and costs across vehicles, drivers, and stations.