Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Consider a database that has the relation sch... Start Learning for Free
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below.
 
Q. The following query is made on the database. T1 ← πCourseNameStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.
Note: This questions appeared as Numerical Answer Type.
  • a)
    2
  • b)
    3
  • c)
    4
  • d)
    5
Correct answer is option 'C'. Can you explain this answer?
Verified Answer
Consider a database that has the relation schemaCR(StudentName, Course...
Result of T1: CA CB CC Result of T2 = CR/T1 SA SC SD SF Total = 4 Therefore, option C is correct 

Alternate Solution :
The output of query T1 will be the courses enrolled by student SA i.e CA , CB, CC
The output of query T2 will be the names of the students who enrol all the courses that are the output of query T1 (division operator) i.e CA, CB, CC
From the table we can see that SA, SC, SD, SF have enrolled all the courses so the output of T2 will have 4 rows. 
 
View all questions of this test
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer?
Question Description
Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer?.
Solutions for Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer?, a detailed solution for Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? has been provided alongside types of Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Consider a database that has the relation schemaCR(StudentName, CourseName). An instance of the schema CR is as given below.Q.The following query is made on the database. T1 ← πCourseName(σStudentName=’SA’(CR)) T2 ← CR ÷ T1 The number of rows in T2 is ________.Note:This questions appeared as Numerical Answer Type.a)2b)3c)4d)5Correct answer is option 'C'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev