Page 98 - iPlus_Ver_2.0_class_7
P. 98

#Problem Solving & Logical Reasoning
                           Crack The Code                                             #Digital Literacy


                   Find six terms related to database in the grid.
                                                 W    R  A   P   T   A   B   L   E   F

                                                  P   R   I  M   A   R   Y   K   E   Y
                                                  R  H    T  G   Q   F   D   R   M   R
                                                  E  N    X  C   U   L   U   M N     M

                                                  P   B   F  R   E   W   F   O   R   M
                                                 O    E  R   G   R   N   G   C   E   L
                                                  R  O   U   M   Y   L   H   E   K   A
                                                  T   C   E   L   L  N    I   I  B   S





                                                                                      #Experiential Learning
                     Let’s Explore



                            Surf the Internet and find out about the steps to delete a table in Access.





                                                                                      #Digital Literacy
                                                                                      #Creativity & Innovativeness


                         Practical Time

                    Create a table using the ‘Design View’.

                            Roll No.           Name          Date of Birth       Phone No.           Place

                              A001        Naman Gupta         15/04/1986        9789451842          Mumbai
                              A002        Riya Sharma         10/01/1987        4489351649           Jaipur
                              A003        Sayyam Dhingra      06/08/1989        2354666677         Faridabad

                        •  Sort the Place in decreasing order.        •  Set Roll No. as the primary key.
                        •  Delete the record no. A002.                •   Add another record.





                      Teacher’s Corner

                  1.  Discuss the different relational database management systems such as MS SQL Server and Oracle.
                  2.  Explain the concept of different types of keys, such as composite key and foreign key.
                  3.  Discuss the procedure to create a database by using the built-in templates.





                    96
                         iPlus (Ver. 2.0)-VII
   93   94   95   96   97   98   99   100   101   102   103