Normalization 1. A table should have an identifier. A table should store only data for a single type of entity. A table should not have repeating values or columns 4. A table should avoid nullable columns Choosing a SQL Server Monitoring Tool SQL Profiler Enables you to monitor server and database activity (for example, number of deadlocks, fatal errors, tracing stored procedures and Transact-SQL statements, or login activity). You can capture SQL Profiler data to a SQL Server table or a file for ......

Encapsulation – Only nececesary portions of class fields and methods should be publicly accessible. Hide inner workings of an object. Inheritance – ability of derived class to inherit the properties & methods from base class. The derived class can add to and override base class behavior. Polymorphism – the ability for related classes to have the methods or functions with the same name and signatures but different implementations. Aggregation/Composition - groups of objects being used to make ......