Understanding Relational Databases: Summary
Chapter Index
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.
Buy The Book
If you enjoyed this chapter then why not buy the book from either Amazon.co.uk or Amazon.com?
Support Our Work
If you found this article useful then please visit our advertisers at the top of this page or see other ways of supporting our work.
Comments
Please tell us if you found this article useful:
