Reviewing about designing SQL database… instead of a tutorial, I think its faster to relearn it by this list of Ten Common Database Design Mistakes which are:
- Poor design/planning
- Ignoring normalization
- Poor naming standards
- Lack of documentation
- One table to hold all domain values
- Using identity/guid columns as your only key
- Not using SQL facilities to protect data integrity
- Not using stored procedures to access data
- Trying to build generic objects
- Lack of testing
Tutorial on MySQL is here.
