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.

The end goal of database design is to be able to transform a logical data model into an actual physical database. ... For example, a character data type could be specified as CHAR(25), indicating that ...