Though this chapter focuses on the physical implementation of the logical design, there are several places where discussions could enhance student understanding.
After covering "Creating and Altering Databases," have students discuss different scenarios of why they might use file groups, and where and why they would want to place files depending on various requirements of the system.
Carefully review Table 3.1 with the students, reviewing Entity, Referential, and Domain Integrity again. It may be helpful to write brief definitions of each type of integrity on the board. Entity integrity ensures that a table has a unique way to identify each record. Domain integrity ensures that data values meet specific criteria. Referential integrity enforces relationships between two tables. Make sure that students understand these concepts thoroughly. Quiz them.
When covering "Troubleshooting SQL Server Objects" and defining the Server and Database configuration options, have students come up with situations where changing each option may be appropriate.