Consider a database that has the relation schema CR(StudentName. CourseName). An instance of the schema CR is as given below. CR Student Name Course Name SA CA SA CB SA CC SB CB SB CC SC CA SC CB SC CC SD CA SD CB SD CC SD CD SE CD SE CA SE CB SF CA SF CB SF CC The following query is made on the database. T1 ← π CourseNane (σ StudentName=’SA’ (CR)) T2 ← CR ÷ T1 The number of rows in T2 is _______.

GATE Computer Science (CS) 2017 Shift 1 Solved Paper

Question : 56 of 65

Marks: +1, -0

Consider a database that has the relation schema CR(StudentName. CourseName). An instance of the schema CR is as given below.

The following query is made on the database.
T1 ← π_CourseNane(σ_{StudentName=’SA’}(CR))
T2 ← CR ÷ T1
The number of rows in T2 is _______.

Go to Question:

Prev Question

Next Question