1. Normalization:
http://raider.mountunion.edu/csc/csc100/spring2015/database/normalizationexample.html
http://salinaitmind.blogspot.com/2012/10/data-warehouse-data-normalization.html
2. Design from scratch
ERD COLONIAL (PNG)
Solmaris ERD (PNG)
TAL ERD (PNG)