CBSE Class 12 Computer Science 2022 — Set 91/4

Write the output of SQL queries (a) to (d) based on the table VACCINATIONDATA given below: Table: VACCINATIONDATA VID Name Age Dose1 Dose2 City 101 Jenny 27 2021-12-25 2022-01-31 Delhi 102 Harjot 55 2021-07-14 2021-10-14 Mumbai 103 Srikanth 43 2021-04-18 2021-07-20 Delhi 104 Gazala 75 2021-07-31 NULL Kolkata 105 Shiksha 32 2022-01-01 NULL Mumbai (a) SELECT Name, Age FROM VACCINATIONDATA WHERE Dose2 IS NOT NULL AND Age > 40; (b) SELECT City, COUNT(*) FROM VACCINATIONDATA GROUP BY City; (c) SELECT DISTINCT City FROM VACCINATIONDATA; (d) SELECT MAX(Dose1), MIN(Dose2) FROM VACCINATIONDATA;

Write the output of SQL queries (a) and (b) based on the following two tables DOCTOR and PATIENT belonging to the same database: Table: DOCTOR DNO DNAME FEES D1 AMITABH 1500 D2 ANIKET 1000 D3 NIKHIL 1500 D4 ANJANA 1500 Table: PATIENT PNO PNAME ADMDATE DNO P1 NOOR 2021-12-25 D1 P2 ANNIE 2021-11-20 D2 P3 PRAKASH 2020-12-10 NULL P4 HARMEET 2019-12-20 D1 (a) SELECT DNAME, PNAME FROM DOCTOR NATURAL JOIN PATIENT; (b) SELECT PNAME, ADMDATE, FEES FROM PATIENT P, DOCTOR D WHERE D.DNO = P.DNO AND FEES > 1000;

Differentiate between Candidate Key and Primary Key in the context of Relational Database Model. OR Consider the following table PLAYER: Table: PLAYER PNO NAME SCORE P1 RISHABH 52 P2 HUSSAIN 45 P3 ARNOLD 23 P4 ARNAV 18 P5 GURSHARAN 42 (a) Identify and write the name of the most appropriate column from the given table PLAYER that can be used as a Primary key. (b) Define the term Degree in relational data model. What is the Degree of the given table PLAYER?

Write the definition of a user defined function PushNV(N) which accepts a list of strings in the parameter N and pushes all strings which have no vowels present in it, into a list named NoVowel. Write a program in Python to input 5 words and push them one by one into a list named All. The program should then use the function PushNV() to create a stack of words in the list NoVowel so that it stores only those words which do not have any vowel present in it, from the list All. Thereafter, pop each word from the list NoVowel and display the popped word. When the stack is empty display the message "EmptyStack". For example: If the Words accepted and pushed into the list All are ['DRY', 'LIKE', 'RHYTHM', 'WORK', 'GYM'] Then the stack NoVowel should store ['DRY', 'RHYTHM', 'GYM'] And the output should be displayed as GYM RHYTHM DRY EmptyStack OR Write the definition of a user defined function Push3₅(N) which accepts a list of integers in a parameter N and pushes all those integers which are divisible by 3 or divisible by 5 from the list N into a list named Only3₅. Write a program in Python to input 5 integers into a list named NUM. The program should then use the function Push3₅() to create the stack of the list Only3₅. Thereafter pop each integer from the list Only3₅ and display the popped value. When the list is empty, display the message "StackEmpty". For example: If the integers input into the list NUM are: [10, 6, 14, 18, 30] Then the stack Only3₅ should store [10, 6, 18, 30] And the output should be displayed as 30 18 6 10 StackEmpty

(i) A SQL table ITEMS contains the following columns: INO, INAME, QUANTITY, PRICE, DISCOUNT Write the SQL command to remove the column DISCOUNT from the table. (ii) Categorize the following SQL commands into DDL and DML: CREATE, UPDATE, INSERT, DROP

Rohan is learning to work upon Relational Database Management System (RDBMS) application. Help him to perform the following tasks: (a) To open the database named "LIBRARY". (b) To display the names of all the tables stored in the opened database. (c) To display the structure of the table "BOOKS" existing in the already opened database "LIBRARY".

Write SQL queries for (a) to (d) based on the tables PASSENGER and FLIGHT given below: Table: PASSENGER PNO NAME GENDER FNO 1001 Suresh Male F101 1002 Anita Female F104 1003 Harjas Male F102 1004 Nita Female F103 Table: FLIGHT FNO START END FDATE FARE F101 MUMBAI CHENNAI 2021-12-25 4500 F102 MUMBAI BENGALURU 2021-11-20 4000 F103 DELHI CHENNAI 2021-12-10 5500 F104 KOLKATA MUMBAI 2021-12-20 4500 F105 DELHI BENGALURU 2021-01-15 5000 (a) Write a query to change the fare to 6000 of the flight whose FNO is F104. (b) Write a query to display the total number of MALE and FEMALE PASSENGERS. (c) Write a query to display the NAME, corresponding FARE and FDATE of all PASSENGERS who have a flight to START from DELHI. (d) Write a query to delete the records of flights which end at Mumbai.

(i) Differentiate between Bus Topology and Tree Topology. Also, write one advantage of each of them. OR Write two points of difference between XML and HTML. (ii) What is a Web Browser? Write the names of any two commonly used Web Browsers.

Galaxy Provider Ltd. is planning to connect its office in Texas, USA with its branch at Mumbai. The Mumbai branch has 3 Offices in three blocks located at some distance from each other for different operations - ADMIN, SALES and ACCOUNTS. As a network consultant, you have to suggest the best network related solutions for the issues/problems raised in (a) to (d), keeping in mind the distances between various locations and other given parameters. Shortest distances between various locations: ADMIN Block to SALES Block 300 m SALES Block to ACCOUNTS Block 175 m ADMIN Block to ACCOUNTS Block 350 m MUMBAI Branch to TEXAS Head Office 14000 km Number of Computers installed at various locations are as follows: ADMIN Block 255 ACCOUNTS Block 75 SALES Block 30 TEXAS Head Office 90 (a) It is observed that there is a huge data loss during the process of data transfer from one block to another. Suggest the most appropriate networking device out of the following, which needs to be placed along the path of the wire connecting one block office with another to refresh the signal and forward it ahead. (i) MODEM (ii) ETHERNET CARD (iii) REPEATER (iv) HUB (b) Which hardware networking device out of the following, will you suggest to connect all the computers within each block? (i) SWITCH (ii) MODEM (iii) REPEATER (iv) ROUTER (c) Which service/protocol out of the following will be most helpful to conduct live interactions of employees from Mumbai Branch and their counterparts in Texas? (i) FTP (ii) PPP (iii) SMTP (iv) VoIP (d) Draw the cable layout (block to block) to efficiently connect the three offices of the Mumbai branch.