Page 325 - TP_IT_V1.0_C10_flipbpookl
P. 325
• Many to Many: In this relationship, “Multiple records of Master table is related to multiple records of Transaction
table”. Generally, this type of relationship is set when certain records must be saved more than once in both the
related tables. It is represented as a n:n relationship.
In the above tables ONE TEACHER can teach MANY SUBJECTS. ONE SUBJECT is taught by MANY TEACHERS.
Similarly, a shopkeeper may sell multiple products to multiple customers. So Many-to-Many relationship exists
between a product and a customer.
Creating a Relationship
Steps to create a relationship between tables are as follows:
Step 1: Select the Tools → Relationships option from the Menu bar.
The Relation Design window opens with the Add Tables dialog box.
Step 2: Select the table that you want to add in the relationship as Subject.
Step 3: Click the Add button in the Add Tables dialog box.
Similarly, you can add more tables. In this case, we have added the Teacher table.
Database Management System using LibreOffice Base 323

