Summary

In this appendix, we discussed some of the basic concepts of relational databases. To learn more, you can access the following resources online:

• "Database Normalization Basics":

  http://support.microsoft.com/default.aspx?scid=KB;en-us;q209534

• "Database Normalization Tips" by Luke Chung:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_FMSNormalization.asp

• "Database Normalization and Design Techniques" by Barry Wise:

  www.devarticles.com/art/1/321

• Concurrency Control and Recovery in Database Systems by Philip A. Bernstein, Vassos Hadzilacos, and Nathan Goodman:

  http://research.microsoft.com/pubs/ccontrol/

• "Denormalization Guidelines" by Craig S. Mullins:

  www.tdan.com/i001fe02.htm

• "Getting Down to Data Basics" by Craig S. Mullins:

  www.dbazine.com/edba4.html

• "Transaction Isolation Levels" by Kalen Delaney:

  www.sqlmag.com/Articles/Index.cfm?ArticleID=5336

• "Responsible Denormalization" by Michelle A. Poolet:

  www.sqlmag.com/Articles/Index.cfm?ArticleID=9785

• SQLCourse: www.sqlcourse.com

• Free online version of Teach Yourself SQL in 21 Days, Second Edition:

  www8.silversand.net/techdoc/teachsql/index.htm

• Free PowerPoint tutorial on Transact-SQL by Michael R. Hotek:

  www.mssqlserver.com/tsql/