Question-45

Consider the following relation schema pertaining to a students database:

• Students (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?

• 8,8
  
• 120,8
  
• 960,8
  
• 960,120

Answer

• 8,8
  
• 120,8
  
• 960,8
  
• 960,120