Page 34 - TechPluse_C8_Flipbook
P. 34

B.    Find six terms related to LibreOffice Base in the following grid.
                                                                                                      Critical Thinking
                                            P   A    B   E   A   U    T   B   D    E   Z   L

                                            R   S   N    L   S   O   M    E   M   N    D   O
                                            I   M   O    O   Z   N    L   A   D    F   A   R

                                            M   T   Q    U   E   R    Y   L   M    L   T   Q
                                            A   L   M    S   F    E   T   O   M   Q    A   B

                                            R   Z    Y   U   L   P   M    T   A   Q    B   F
                                            Y   X    L   N   M   O    S   A   L    A   A   M

                                            K   S   U    V   P   R    T   B   M    R   S   Z
                                            E   L    L   O   P   T    S   L   N    F   E   A
                                            Y   M   N    F   O   R   M    E   L    Z   Y   B



                    Lab Session                                                                        Subject Enrichment



                       Create a table using the ‘Table Data 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 grades.

                       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 by using the wizard.






               32       Premium Edition-VIII
   29   30   31   32   33   34   35   36   37   38   39