What is relationship? What are its types? (MS-Access)

• The logical linkage between two or more than two tables with the help of unique key field is known as relationship.
• To prevent the duplication of information in a database by repeating fields in more than one table, table relationship can be established.

• The types of relationship are:
• One-to-one (view)
• One-to-many (view)
• Many-to-many (view)

Share :

Twitter