How to avoid null values?

Answer 1

Provid your values to avoid it or use update with where statements to replace every single null in your tables

Answer 2

specify the not null constraint while creating the table