Prevent data anomalies using contraints. Why are primary keys, defaults, checks, unqiues, and foreign keys required? Use views to hide and secure your underlying tables using projection, filtering, schemabinding, check option, encryption, and indexes.