One of the key factors in determining the success of a database solution can be traced to before work even begins. The initial planning and data specifications can make or break a project. That’s why it’s worth investing time in thinking about what might happen in phase II of the project or what complications may arise. Building a good database solution starts with a solid foundation, allowing future versions to build and evolve over time. No matter what business the database is being created for, there are common pitfalls and opportunities in designing a fit-for-purpose database which becomes part of the toolkit of an experienced database architect. Imagining a solution is the first step, understanding the scope of a project requires careful analysis and a clear understanding of what is feasible.