Design database schema in mysql

I am a rookie.I want to design database schema for web applications.Can any one give me the links开发者_开发知识库 for a good data base design and also start to design from scratch.

There are a large number of example database schemas that you can study here:

http://www.databaseanswers.org/data_models/

This is probably the best database designer book for a beginner:

http://www.amazon.com/Database-Design-Mere-Mortals-Hands/dp/0201694719

There is no single "database schema" that is suitable for all web applications. You need to have a good understanding of database design principles and apply that to the web application in question. I have found Database Systems to be a good book for learning database design principles.