Page 271 - IT 402 v2.0 class 10
P. 271

  Therefore, it reduces data-entry errors.

              Summarise data from related and associated tables.

            Creating and Editing Relationships between Tables

            Consider a database of your class in which the student details and their marks details are stored in two
            separate  ables namely  S    N   and  S    N M   S .  stablish a relationship between two tables and
            add a few records in both the tables.  elete a record from the  S    N    able and see if the same gets
            deleted from the  S    N M   S  table or not.

              relationship refers to an association or connection between fields of two or more tables.  hen you relate
            or connect two tables, there is a need to enter the same data in separate tables.
             o establish a   elationship  between two tables  open the  able window. Select the   elationships  option
            from   ools  menu.  ssuming that there are two tables  namely   S    N   and  S    N M   S .  lick on
                      S  icon from the Standard  oolbar.

             O

            Select the           S  option from the  INS     menu from the menu bar.  he           S  window opens
            with the list of the available tables in the database file from which the user can select the tables to set
            relationship.
            Step 1:  Click here to set relationship.

            Step 2:   dd  ables  window opened after clicking on   dd  ables  icon.





              1
















                                                              2










            Step 3:  Select the table  S    N   from the   dd  ables  window and then click on   dd  button.  he table
                    namely  S    N   gets displayed with all fields.
            Step 4:  Follow the above steps to add the  S    N M   S  table to set the relationship between them.







                                                                                  Database Management          269
   266   267   268   269   270   271   272   273   274   275   276