Font size:
Print
Question: Consider the following relational 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 the Enroll tables are 120 and 8 respectively. What are the maximum and the minimum number of tuples that can be present in (Student * Enroll), where * denotes natural join?
1. 120,8
2. 8,8
3. 960,8
4. 960,120
Check Answer
Student: (rollno, name, address)
Enroll: (rollno, courseno, coursename)
Where the primary keys are shown underlined. The number of tuples in the Student and the Enroll tables are 120 and 8 respectively. What are the maximum and the minimum number of tuples that can be present in (Student * Enroll), where * denotes natural join?
1. 120,8
2. 8,8
3. 960,8
4. 960,120
Check Answer
