Well, that is quite a lot to mention in one forum thread 🙂

I think it is best that you search this site and the net for interesting articles on the subject.

And maybe grab a book on database design and principles. (You can start with Codd and CJ Date).

If you have specific questions, you can always ask them here.