It seems that database design problems are very common and do not depend on used database platform - every new generation of developers each 4-5 years repeats the same mistakes...
The presentation below is recommended for every database developer, regardless of the database being used.
My favourite slide is about "How many tables do you really need? - Four at most!" :-))
Oracle Database Worst Practices