Microsoft Access is an example of relational database. In
relational data base we can join a table to more than one table which makes
relationship. With this capability our access database becomes more powerful
than non-relational data base category. Consistency of database become easy and
easily achieve by database on automatically. If you want to make relationship in access database
then you need at least two tables and one field must be common in both tables. For
example, we are going to make relationship between two tables’ student and canteen.
Student table store record of student and canteen stores what the products
students are having. So in this type of relationship student is master table
and canteen is related table. So student table need a primary key which uniquely
identified a record from student table. Canteen table must have a key which match
the data type of student table primary key which further known as foreign key.
