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

Records added in STUDENT table







            Step 4:   ouble-click on  S    N   table from the  able  indow  ane to delete records from the table.  he
                    table opens in   ata  iew  mode.



















            In the above example, to delete record  number 4 from the table,  click on the 4th record  and then
            right-click to open the menu list.
              Select the option   elete  ows  from the menu to delete the selected record.
              Select   es  to delete the record  otherwise select  No .

            On selecting   es  option  the selected record gets deleted from the  S    N   table and the similar record
            number will be automatically deleted from the  S    N M   S  table also.








                 Record deleted
                from STUDENT
                     table


                Record deleted
                    from
              STUDENTMARKS
               table automatically











                                                                                  Database Management          273
   270   271   272   273   274   275   276   277   278   279   280