CBSE Guess > Papers > Important Questions > Class XII > 2013 > Computer Science > Computer Science - by Mr. Sandip Kumar Srivastava

CBSE CLASS XII

Computer Science (C++ and Data Structure)

58.

a) Define

1. Cardinality
2. Candidate Key

b) Consider the following tables GAMES- storing the details of games  and PLAYER –storing the details of players who have enrolled their names for the scheduled games. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (vi)

Table: GAMES

Table: PLAYER

1. To display name of those games whose  PrizeMoney is in the range 10000 to 30000 and No_Players above
2. To display the details of games whose GameName starts with ‘C’  in ascending order of ScheduleDate.
3. To display count  of players enrolled for each game.

4. Display each PCode, PlayerName and the GameName for which they have enrolled.
5. SELECT SUM(PrizeMoney) FROM GAMES;
6. SELECT COUNT(DISTINCT GCode) FROM PLAYER;

59.

1. What do you mean by Candidate Key and Foreign Key?
2. Consider the following tables STORE and SUPPLIERS a. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii).

Table: STORES

Table: SUPPLIERS

Submitted By : Mr. Sandip Kumar Srivastava
Email : [email protected]