Database Design and Development

Relational databases are important tools for storing data. They are also one of the most overlooked components during the design phase of most projects. Problems can appear after days, months, or even years after the final rollout of a new application that are caused by poor database design.

Lighthouse can work with you to help design your data model and the database tables that will be required to store it. We will make sure that all appropriate keys are defined to indicate links between data. We will also make sure that all appropriate rules are in place to correctly delete and update related data.

We will work with you to ensure that your database has the correct index coverage, both with initial database design and as your application is developed. We can also help you with development of stored procedures and database triggers.