Page 38 - Touchpad_Plus_V3.2_Class 8
P. 38

Lab Session                                                               Century   #Technology Literacy
                                                                                                 21 st
                                                                                                Skills

                       Create a table using the Table Design View.
                                                                 Date of            Marks
                             Reg No.            Name                                                  Grade
                                                               Submission         Obtained
                         T/121/15          Anshu Verma           11/07/15             18                A

                         T/137/15          Anjali Kumari         12/07/15             20                A+
                         T/145/15          Deepak Kohli          14/07/15             17                B+

                        •  Name the table as ‘Marks Distribution’.
                        •  Enter at least 3 records.
                        •  Sort the data on the basis of marks obtained.
                       Create a table using the Table Design View.

                             Roll No.           Name          Date of Birth       Phone No.           Place
                               A001        Manan Gupta          12/09/1987       2354667667            Delhi

                               A002        Ryansh Sharma        09/05/1986       3435555555        Chhattisgarh
                               A003        Rahul John           02/05/1990        656554432          Mumbai

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





                  Teacher's Note

                    1.  Discuss about different relational database management systems such as LibreOffice Base and Oracle.
                    2.  Discuss the procedure to create a table.





























               36       Plus (Ver. 3.2)-VIII
   33   34   35   36   37   38   39   40   41   42   43