Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2001 Robin Dewson
About this chapter
Cite this chapter
Dewson, R. (2001). Building Relationships. In: Beginning SQL Server 2000 Programming. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0804-4_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0804-4_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-252-6
Online ISBN: 978-1-4302-0804-4
eBook Packages: Springer Book Archive