MCQOPTIONS
Saved Bookmarks
| 1. |
Consider the following relation schema pertaining to a students database:Student (rollno, name, address)Enroll (rollno, courseno, coursename)where the primary keys are rollno,courseno. 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, 0 |
| B. | 120, 8 |
| C. | 960, 8 |
| D. | 960, 120 |
| Answer» B. 120, 8 | |