Having a solid information infrastructure is key to a running a well oiled website. This involves organizing data in a way that makes retrieval fast and reliable. In order to organize information efficiently, a process called database normalization must be used to keep data both separate and descriptive. Database normalization uses linking tables to connect related information together. Linking tables are used to avoid common pitfalls found with poor database design.
Here is a list of poor database design choices:
- Storing more than one value in a database table cell using a comma delimited list.
- Having too many column fields in a single table.
- Storing foreign keys inside a main table.
Recent Comments