ALL GATE QUESTIONS SUBJECTWISE
×

ER Diagrams

1 Mark Questions 2 Marks Questions

Functional Dependencies and Normalization

1 Mark Questions 2 Marks Questions

SQL 

1 Mark Questions 2 Marks Questions

Relational Algebra and Relational Calculus

1 Mark Questions 2 Marks Questions

Transactions and Concurrency Control

1 Mark Questions 2 Marks Questions

File Structures  and Indexing

1 Mark Questions 2 Marks Questions


GATE 2004 Question - Mark 1


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?

(a) 8,8
(b) 120,8
(c) 960,8
(d) 960,120


Total 4 Questions



Share: