Hello!
This is a Medium Rare template, check out more here.

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!

Clients

Take a Look At Some Recent Clients
National Title Group is located in Texas and specializes in title management.
The Good News Christian Clothing Store has been providing Christian apparel for over 10 years.
Cooler Air Today is one of the Nation’s top AC repair companies with headquarters in Scottsdale & Phoenix.
Teserra Pool Builders specializes in custom pools in Orange County and surrounding areas.
Occasio specializes in property management in Phoenix and Scottdale.
An Oasis of Healing is a leader in holistic cancer treatment and is world renowned.
Express Movers has been moving the US for over 40 years. Main office in Phoenix and operate in all 50 states.
Bicycle Law Guardians have been protecting riders for over 30 years. They are bicycle law experts in the Chandler & Phoenix area.
ServGrow Software is a leading field service software for HVAC, Handyman, Window Cleaning and other home service companies.
Dealer Auto Glass is the Southwest’s largest windshield replacement company in Phoenix for over 30 years after starting Mesa & Scottsdale.
On Track Garage Door Repair in Mesa is Arizona’s largest garage door repair company and headquartered in Phoenix, Arizona.
PS Movers Seattle moves the country forward including their premier movers in Bellevue and surrounding areas.

Looking for Web Design and Development?

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