There are bugs in our spreadsheet! Designing a database for scientific data

When designing a database it is necessary to have an intimate understanding of the data in order to provide accurate and versatile information over the long term. A case study is used to demonstrate the design process in setting up a database for a large and long-term scientific project.