Table Relationships (Visual Database Tools)
You can create relationships between your tables in a database diagram to show how the columns in one table are linked to columns in another table.
In a relational database, relationships enable you to prevent redundant data. For example, if you are designing a database that will track information about books, you might have a table called
titles that stores information about each book, such as the book's title, date of publication, and publisher. There is also information you might want to store about the publisher, such as the publisher's phone number, address, and zip code. If you were to store all of this information in the
titles table, the publisher's phone number would be duplicated for each title that the publisher prints.
A better solution is to store the publisher information only once in a separate table,
publishers. You would then put a pointer in the
titles table that references an entry in the publisher table.
To make sure your data is not out of sync, you can enforce referential integrity between the
publishers tables. Referential integrity relationships help ensure information in one table matches information in another. For example, each title in the
titles table must be associated with a specific publisher in the
publishers table. A title cannot be added to the database for a publisher that does not exist in the database.
For a better understanding of table relationships, see:
Types of Table Relationships (Visual Database Tools)
Overview of Referential Integrity (Visual Database Tools)