Q. 32 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
Answer: (A)
Explanation:
