Database and Application Design
Often following on from conducting business analysis, I’ve been required to produce technical designs for both relational and object oriented systems, operating within both Waterfall and Agile projects. Key to this is understanding how a system will be used. Being able to predict processing bottlenecks, developing index strategies that work with frequently used reporting paths, knowing when to normalise and denormalise data, these are all skills that I’ve used in the past. Here are some of the techniques I’ve used to do this:
- Normalisation to 3rd Normal Form
- Selective Denormalisation
- Indexing Strategies
- Audit Functionality
- Avoiding Design Traps
- Identifying Data Domains
- Prototyping
- Design Patterns
- Templating
- CSS