Consider the following relation schema pertaining to a students database:…
GATE · 2004 · CS
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 ?
- A.
8, 8
- B.
120, 8
- C.
960, 8
- D.
960, 120
Attempted by 241 students.
Sign up free to check your answer
Sign up freeLoading lesson…