Consider the following relational schema pertaining to a

Home » Database » Database miscellaneous » Question

Consider the following relational schema pertaining to a student’s database:
Students (Rollno., name, address)
Enroll (Rollno., Courseno., coursename)
Where the primary keys are shown underlined. The numbers of tuples in the student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum numbers of tuples that can be present in (Student * Enroll), where * denotes natural join?

1. 8, 8
2. 120, 8
3. 960, 8
4. 960, 120

Correct Option: A

So, Max #tuples matches = 8.
Since SID is a foreign key in Enrolled table, so every value of Enrolled. SID matches with student. SID. Min #tuples matches is also 8 but not zero. So, if there is another option. Hence option (a) is correct.