Page 370 - C++

CBSE AISSCE 2017-2018 Marking Scheme for Computer Science
(2018-2019 Sub Code: 083 Paper Code: 91)

OR Option (iv)

DEGREE = 5
CARDINALITY = 9
(1 Mark for writing CARTESIAN PRODUCT OR Option (iv))
(½ 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.

Table: ACCOUNT
ANO ANAME ADDRESS

101 Nirja Singh Bangalore

102 Rohan Gupta Chennai
103 Ali Reza Hyderabad

104 Rishabh Jain Chennai

105 Simran Kaur Chandigarh

Table: TRANSACT

TRNO ANO AMOUNT TYPE DOT
T001 101 2500 Withdraw 2017-12-21

T002 103 3000 Deposit 2017-06-01
T003 102 2000 Withdraw 2017-05-12

T004 103 1000 Deposit 2017-10-22
T005 101 12000 Deposit 2017-11-06

(i) To display details of all transactions of TYPE Deposit from Table TRANSACT.

Ans SELECT * FROM TRANSACT WHERE TYPE = ​'​Deposit​'​;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)

(ii) To display the ANO and AMOUNT of all Deposits and Withdrawals done in the
month of October 2017 from table TRANSACT.

Ans SELECT ANO,AMOUNT FROM TRANSACT
WHERE DOT >= ​'​2017-10-01​'​ AND DOT <= ​'​2017-10-31​'​;
OR
SELECT ANO,AMOUNT FROM TRANSACT
WHERE DOT BETWEEN ​'​2017-10-01​'​ AND ​'​2017-10-31​'​;

(½ Mark for correct SELECT statement)

Page #28/35