Page 98 - iPlus_Ver_2.0_class_7
P. 98
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Find six terms related to database in the grid.
W R A P T A B L E F
P R I M A R Y K E Y
R H T G Q F D R M R
E N X C U L U M N M
P B F R E W F O R M
O E R G R N G C E L
R O U M Y L H E K A
T C E L L N I I B S
#Experiential Learning
Let’s Explore
Surf the Internet and find out about the steps to delete a table in Access.
#Digital Literacy
#Creativity & Innovativeness
Practical Time
Create a table using the ‘Design View’.
Roll No. Name Date of Birth Phone No. Place
A001 Naman Gupta 15/04/1986 9789451842 Mumbai
A002 Riya Sharma 10/01/1987 4489351649 Jaipur
A003 Sayyam Dhingra 06/08/1989 2354666677 Faridabad
• Sort the Place in decreasing order. • Set Roll No. as the primary key.
• Delete the record no. A002. • Add another record.
Teacher’s Corner
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 composite key and foreign key.
3. Discuss the procedure to create a database by using the built-in templates.
96
iPlus (Ver. 2.0)-VII

