Like people, databases can be temperamental creatures and need a bit of loving and caring, and good relationships are the basis of this sustenance. At the moment, our tables could just be seen as single, unrelated items. Of course, there are columns that have the same name in different tables, however, there are no specifics tying them together. This is where defining relationships between the tables is crucial to the glue that binds the tables together. Binding the tables together will ensure that changes in one table do not cause data in another table to become invalid.
KeywordsBuilding Relationship Enterprise Manager Query Analyzer Child Table Referential Integrity
Unable to display preview. Download preview PDF.