Solution

📘 SET – 1 — ANSWER KEY Context: Library / Books Q1 — Python Functions (4 × 2 = 8 marks) a) COUNT_VOWELS() def COUNT_VOWELS(s: str) -> dict: vowels = "aeiouAEIOU" d = {} for ch in s: if ch in vowels: key = ch.lower() # treat uppercase and lowercase as same d[key] = d.get(key, 0) + 1 return d # Example: print(COUNT_VOWELS("Education")) # Expected: # {'e':1, 'u':1, 'a':1, 'i':1, 'o':1} b) SAVE_VOWEL_DATA() import pickle def SAVE_VOWEL_DATA(s: str, filename="VOWELS.dat"): data = COUNT_VOWELS(s) with open(filename, "wb") as f: pickle.dump(data, f) print("Vowel data saved to", filename) # Example call: SAVE_VOWEL_DATA("Education") # Expected output message: # Vowel data saved to VOWELS.dat Q2 — SQL (4 marks) Database: LIBRARY 1. Display title and total fees collected for each book SELECT B.Title, COALESCE(SUM(I.Fees), 0) AS TotalFees FROM BookDetails B LEFT JOIN BookIssue I ON B.BookId = I.BookId GROUP BY B.Title; Expected result: Time Machine 20 Invisible Man 20 Brief History 70 Hamlet 25 2. IssueDate of all Science books SELECT I.IssueDate, B.Title FROM BookIssue I JOIN BookDetails B ON I.BookId = B.BookId WHERE B.Genre = 'Science'; Expected result: 2025-01-05 Brief History 2025-01-20 Brief History 3. Delete all Drama books not issued DELETE FROM BookDetails WHERE Genre = 'Drama' AND BookId NOT IN (SELECT BookId FROM BookIssue); (Hamlet is issued, so it will NOT be deleted.) 4. Update author of "Time Machine" UPDATE BookDetails SET Author = 'Herbert Wells' WHERE Title = 'Time Machine';

CAR RACE

Participate in car race and try to win

By Amit Meena
PGT CS
KV  NTPC ANTA

SPELL FILL GAME

SPELL FILL GAME improves your vocabulary.

About the Game

1. Spelling of a word will be displayed with some missing letters displayed as ?

2. You should identify and select the missing letters from balloons falling down.

3. There is an aircraft which releases bombs, on click to shoot the balloons.

4. If the bomb shoots correct lettered balloon, that letter will be substituted in missing letter.

5. On filling all missing letters you get score of 10 points and next spelling will be displayed.

6. Duration of Game and Number of bombs is fixed, the total score and no. of spellings solved will be displayed on completion of time or number of bombs.

Play it and have fun of Learning. Good Luck

Developed by

Aruna Padma

PGT CS
KV No.2 Uppal

Hyderabad

Greenfoot - Memory Game

Instructions to play the game:

Here is a game where you need to use your memory: you have to find and match the identical fruits cards. Click on the first card and then, click on the others to find the fruit card that is identical to the first one, and so on. memorize quickly all the turning cards! This way, you'll be able to find them much easier and faster!

Note:

1.  Game has 10 levels and it has to be completed in  given stipulated time.
2.  As level increases the no of cards for pairing increases.
3.  Time Span increases as Levels of the game increases  and extra bonus points will be   secured if the task is completed in less amount of time.
4.  You need to complete the task before the time is lapsed otherwise you will lose the   game. 

By 
Ch.Kirankumari 
PGT(Comp.Sci)
Kendriya Vidyalaya No.1 Uppal
Hyderabad-39

Memory Game--- By Suma PGT Computers KV No.1 Golconda Hyderabad

Your browser is ignoring the <APPLET> tag.

LOST AND FOUND GAME

Your browser is ignoring the <APPLET> tag.

Tank Battle Game- A Greenfoot Project