Consider the following relation schema pertaining to a students database:…

PYQ GATE 2004

Consider the following relation schema pertaining to a students database:

  • Student (rollno, name, address)

  • Enroll (rollno, courseno, coursename)

where the primary keys are shown underlined. The number of tuples in the Student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where '*' denotes natural join ?

  1. A.

    8, 8

  2. B.

    120, 8

  3. C.

    960, 8

  4. D.

    960, 120

Attempted by 305 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…