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

