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
   320   321   322   323   324   325   326   327   328   329   330