Thanks a lot for your kind reply!!!
Ok now just tell me that, Is it possible to create the whole database design at a first time itself? I mean without starting application development...
First, let's make a distinction between "design" and "implementation". I'll call "design" the act of translating a conceptual model of some enterprise into a logical model. Being a SQL Server website, we assume that we will apply the relational model of data to perform this translation. There are multiple possible "correct" logical models for a given conceptual model.
Implementation, then, is the act of realizing that logical model in some specific DBMS. Again, we can assume SQL Server. And again, there are multiple possible "correct" physical models that implement a given logical model.
The initial application you intend may inform some of the design decisions that go into the conceptual-to-logical translation, but my experience is that a high-quality logical model can be produced absent this consideration. In fact, some would argue that introducing application bias at this level is likely to lead to suboptimal design choices, and I can't disagree.
But when implementing the physical manifestation of the logical design, you are much more likely to find yourself relying on the intended application to guide your decisions on physical implementation details. This is where knowing how the data will be used (access patterns, reports, etc.) will inform implementation decisions such as indexing, physical filegroups, etc.
Another thing by the term "database design" i feel its to create the data storage in terms of tables, creating access layers in terms of views stored procedures, and developing relation between these different objects. - Am i correct ? Please something if u feel.
see above. Also, shameless plug: http://www.sqlservercentral.com/articles/Data+Modeling/61817/
You may have gathered from my first post that I try to refrain from giving specific design advice. I would much rather try and point someone in a direction where they can learn the underlying principles, and then apply them. You've probably heard the saying (roughly): "Give a person a fish and they will eat for a day. Teach a person to fish and they will eat the rest of their life."