I personally regard the design of the database as the most important design step in software development. Here are some database design concepts that we follow, and an outline of why they are so important.
We re-built the Friendlies Pharmacy website using the Sitecore platform. This was done according to Sitecore's Helix principles, modelled on the Habitat solution. Features were developed in a modular and generic way so that they may be re-used for future requirements.
We built a layer on top of their existing job management software by interfacing with the existing SQL Server database. First this provided basic reporting, but the solution has grown into a web application performing key functions across the business.
We worked with their existing systems by deciphering the archaic Rocket U2 database platform. By understanding our client thoroughly we were able to engineer solutions to provide seamless integrations and insightful reports.
We managed the SharePoint implementation for Workpower, providing a combination of out-of-the-box and custom development to meet requirements around document management, corporate news, staff interaction and standard forms.
We discovered a way to work with HubSpot's HubL language to provide for much more than simple templating. We were able to cater for dynamic calculations and complex vehicle searching while staying completely within the HubSpot platform.