Page 98 - Trackpad_ipro 4.1_Class7
P. 98

#Digital Literacy
                                                                                   #Creativity & Innovativeness




                        Create a table using the ‘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 decreasing order.
                         •    Set Roll No. as the primary key.
                         •    Delete the record no. A002.
                         •    Add another record.

                        Create a table using the ‘Datasheet 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.









                  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 primary key and composite key.
                  3.  Discuss the procedure to create a database by using the built-in templates.





























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