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

