Page 98 - iPrime_V2.2_class7
P. 98

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.








                  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     Touchpad iPRIME (Ver. 2.2)–VII
   93   94   95   96   97   98   99   100   101   102   103