There is no right way to design a database—each one is different.
- Give each record in a table a unique identifier (primary key).
- Put each group of associated data in a table of its own.
- Cross-reference related information by using the primary key from one table as the
- foreign key in other tables.
- Store only one item of information in each field.
- Stay DRY (don’t repeat yourself).