Page 118 - Viva ICSE Computer Studies 7 : E-book

LEARNING IS FUN

A Unscrambling the Letters

Unscramble the letters to fi nd the correct words. Defi ne each word in your notebook.
1. NOAERLTISIHP ________________________

2. SDHAET EAT ________________________
3. RIRCTEIA ________________________

4. YUEQR ________________________
5. IERFEZNG ________________________

B Defi ning Purpose

Write the purpose of the given design grid of the Query window.

C Framing a Query
Frame a query for the given table.
Student table

Roll No. Name Address Phone No. Result
4 Nida Delhi 12345 Pass
3 Priya Haryana 56789 Fail
6 Sheena Uttar Pradesh 4567 Pass
7 Shaurya Goa 5678 Fail

Emplyeetable
Roll No. Name Department
2 Shayra Computer Science
3 Kiran Computer Science
4 Veena Electrical

5 Reena Mechanical

Now perform the following tasks.
1. Which table will you select to display result as ‘Pass’?
2. Make a query to retrieve the records having Address of ‘Delhi’.
3. Make a query to retrieve the records belonging to Department ‘Computer Science.’

106