Database Design Guidelines

References :

1.Best practices SQL Server naming conventions
http://www.sqlservercentral.com/articles/Naming+Standards/2895/

2.Best practices SQL Server naming conventions
http://vyaskn.tripod.com/object_naming.htm

3)10+ common questions about SQL Server data types
http://www.techrepublic.com/blog/10things/10-common-questions-about-sql-server-data-types/355

4)Composite Primary Keys