One to Zero, One or Many in Data Models

Continuing the discussion from One to Zero, One or Many in Data Models : @aingold At first glance, a simple relationship seems straightforward. But once we start aggregating metrics, things can get tricky. Notice two important things: O101 has two invoices O104 has no invoice yet If we simply join Order and Invoice tables, It looks perfectly reasonable.