• The designer is nice, but limited. I recommend modeling every aspect of your project using a dedicated design tool (I use PowerDesigner) once you have generated the DB the Designer is really good at tuning things.