Relational database design theory is an enormous topic, but you can learn a few principles that can get help you design an efficient travel database for your website. Jot down your database's purpose.

A classic example of relational database design, this would be nearly impossible to do in a spreadsheet but was easy to put together in Airtable.