Page 312 - C++

CBSE AISSCE 2016-2017 Marking Scheme for Computer Science
(Sub Code: 083 Paper Code 91 Outside Delhi)

(½ Mark for correct loop)
(½ Mark for correct load( ))
(½ Mark for correct checking of FCTID)
(½ Mark for displaying the record)

SECTION C - (For all the candidates)

5 (a) Observe the following table MEMBER carefully and write the name of the RDBMS 2
operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN
PRODUCT, which has been used to produce the output as shown in RESULT. Also,
find the Degree and Cardinality of the RESULT.
MEMBER
NO MNAME STREAM
M001 JAYA SCIENCE
M002 ADIYTA HUMANITIES
M003 HANSRAJ SCIENCE
M004 SHIVAK COMMERCE

RESULT
NO MNAME STREAM
M002 ADITYA HUMANITIES

Ans (i) SELECTION

Degree=3
Cardinality=1

(1 Mark for writing the correct name of RDBMS operation)
(½ Mark for writing correct degree)
(½ Mark for writing correct cardinality)

(b) Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which 6
are based on the tables
DVD
DCODE DTITLE DTYPE
F101 Henry Martin Folk
C102 Dhrupad Classical
C101 The Planets Classical

F102 Universal Soldier Folk
R102 A day in life Rock

MEMBER
MID NAME DCODE ISSUEDATE
101 AGAM SINGH R102 2017-11-30
103 ARTH JOSEPH F102 2016-12-13
102 NISHA HANS C101 2017-07-24

(i) To display all details from the table MEMBER in descending order of ISSUEDATE.

Page #22 of 28