Consider a database that has the relation schema CR(StudentName, CourseName).…

GATE · 2017 · CS · Set 1 · Computer Science & IT

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

StudentNameCourseNameSACASACBSACCSBCBSBCCSCCASCCBSCCCSDCASDCBSDCCSDCDSECDSECASECBSFCASFCB SFCC\begin{array}{|c|c|} \hline \textbf{StudentName} & \textbf {CourseName} \\\hline \text {SA} & \text{CA} \\\hline \text{SA} & \text{CB}\\\hline \text{SA} & \text{CC} \\\hline \text{SB} & \text{CB} \\\hline \text{SB}& \text{CC} \\\hline \text{SC} & \text{CA}\\\hline \text{SC}&\text{CB} \\\hline \text{SC} & \text{CC} \\\hline \text {SD} & \text{CA} \\\hline \text{SD} & \text{CB}\\\hline \text{SD} & \text{CC} \\\hline \text{SD} & \text{CD} \\\hline \text{SE}& \text{CD} \\\hline \text{SE} & \text{CA}\\\hline \text{SE}&\text{CB} \\\hline \text{SF}& \text{CA} \\\hline \text{SF} & \text{CB }\\\hline\text{SF} & \text{CC} \\\hline \end{array}

The following query is made on the database.

T1←πCourseName(σStudentName=SA(CR))T1 \leftarrow \pi _{CourseName}\left ( \sigma _{StudentName=SA}\left ( CR \right ) \right )

T2←CR÷T1T2 \leftarrow CR\div T1

The number of rows in T2T2 is ______________ .

Attempted by 127 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…