In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost exclusively on OLTP requirements. OLAP design is beyond the scope of this article.
This article is published on SSWUG.org.
Basit's SQL Server Tips 
these are some good basics on database design.it will be helpful for any beginner as well.
LikeLike