Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 100 - CoreGPT(Podar)_Flipbook_C8
P. 100

    B.  Find five terms related to LibreOffice Base in this grid.                    21 st
                                                                                                    Century   #Critical Thinking
                                                                                                      Skills
                                                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

                                                                                                       21 st
                        Lab Session                                                                  Century   #Technology Literacy
                                                                                                      Skills

                           Visit the lab and perform the following steps:

                            Step 1    Open LibreOffice Base.
                            Step 2    Create a new database.

                            Step 3    Name the database and save it in your desired location.
                            Step 4      Create a new table within the database with fields such as Reg No., Name, Father’s
                                      Name, Date of Birth and Class.
                            Step 5    Populate the table with a few records (e.g., student information).

                            Step 6    Save the database.
                           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.

                      Teacher's Note

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

                     98     Premium Edition-VIII

| 95 96 97 98 99 100 101 102 103 104 105 |