Page 239 - IT_V1.0_Class10
P. 239

Notes

                          If the Add Tables dialog box not opens in the Relation Design window, then, you can open it by clicking
                          the Add Tables button in the Standard toolbar or clicking the Insert → Add Tables option from the
                          Menu bar.



                 Step 3:  Select the Student table from the Add Tables dialog box.
                 Step 4:  Click on the Add button. The table namely Student gets displayed with all fields.

                          Similarly, you can add the Student_Marks table to set the relationship between them.







                   3












                                                     4



                 Step 5:  Click on the Close button in the Add Tables dialog box.

                 Step 6:  Click  on  ROLL_NO  field,  i.e.,  primary  key  field  of  the  Student table. Keep the mouse  button
                          pressed and drag it over the ROLL_NO of second table, i.e., foreign key of another table namely
                          Student_Marks and then release the mouse button. The relationship between the Student and
                          Student_Marks table is established.
                 Step 7:   Right-click on the Relationship Set line.

                 Step 8:  Select the Edit option from the context menu. To open the Relations box for advanced relationship
                          settings.










                                                                            7

                                                        Relationship set    8
                                                          between two
                                                            tables.
                          The Relations dialog box appears.

                 Step 9:  Click on the Update cascade radio button to activate the update option and Delete cascade radio
                          button to activate delete option.


                                                                                      Working with Multiple Tables   237
   234   235   236   237   238   239   240   241   242   243   244