Prime/Secondary/Foreign keys, inner/outer joins, views/functions, T-Sql, normalization, relational db design concept