Alternatives to NULL for missing data
Your alternatives are:


use 6th normal form and don't include a row if something doesn't exist.
use nulls
use some other value that will screw up all of your calculations.


My recommendation would be to use nulls. Why don't you want to use nulls?