Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 112 - CoreGPT(Podar)_Flipbook_C8
P. 112

    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        6565544320      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.

                    110     Premium Edition-VIII

| 107 108 109 110 111 112 113 114 115 116 117 |