Understanding Relational Databases: Summary

Chapter Index

  1. Introduction
  2. Normalization
  3. Foreign Keys
  4. Denormalization
  5. Referential Integrity
  6. Summary

This is a free sample chapter from Beginning PHP 4 Databases published by Wrox Press.

Summary

In this chapter, we have discussed the principles behind relational database design. Let us skim through them here.

Data is stored in two-dimensional tables consisting of columns (fields) and rows (records). Multi-dimensional data is represented by a system of relationships among two-dimensional tables. This usually leads to data storage becoming redundant, and also difficult to maintain on account of addition and deletion anomalies. This is only the case if we do not normalize the data.

Normalization is a process by which redundancy and inconsistency are reduced or eliminated from a database’s schema. Denormalization is generally undesirable but sometimes necessary for performance reasons. Keys are fields or combinations of fields used to identify records. We also saw how entity relationship diagrams are used to map out the design of a database before it is built.

About MIS Web Design Services

Security
Graphic and web design
Client side development
Information architecture
Server side development
Content writing and editing
On-line and off-line marketing
Usability assesments and testing
Accessibility assesments and testing
+much more!

Looking for Web Design and Development?

We Are Here To Help You Stand Out.
Contact Us
Know More