Smooth sailing with Microsoft® Table Relationships!

Remove repetition with Table Relationships.

Aren't you fed-up already? Listen up! Create a good database design and do away with duplicate data. Here is a brief introduction to the world of Table Relationship.

Start off by breaking down your data and information into many different subjects so as to avoid repetition. After you have divided all your data into different tables, you have to create a path to all your newly clubbed data by linking them through different table relationships.

Don’t you worry! Creating a relationships is as easy and interesting as explained above. Start by clicking on the Database Tools tab and then click on the Relationships button. From here on you can simply create, add or delete relationships accordingly. To simplify things further, a table consists of information while a database consists of many tables. So collect the data that you want to relate to each other from your database. Keep in mind that the two tables must have shared fields to make the relationship binding. All your information and data on the related tables should be valid and in tune with each other. However do ensure that your data is in sync with each other. So, it is crucial to apply referential integrity relationships.

While creating a relationship data, it is important to understand the types of tables and the manner in which they are defined. To understand the different types of relationship tables, let us assume that there are two set of tables, Table A and Table B. There are 3 types of relationships:

1. One-to-many relationship: In this type of relationship, a row in table A can have many matching rows in table B. but every row in table B can have only one match in table A. This is the most common type of relationship tables.

2. A many-to-many relationship: A row in table A can have many matching rows in table B and vice versa.

3. A one-to-one relationship: In a one-to-one relationship, a row in table A can have just one match in table B and vice versa.

Get busy and start building your very own relationship tables for various data on your database. You will immediately reap its benefit as it removes duplicate data. Get cracking!