Consider the relations and with primary keys underlined. The relation R contains 1000 tuples and S contains 1500 tuples. The minimum and maximum size of R*S is (where * indicates the natural join):
0 and 500
0 and 1500
1000 and 1500
1000 and 1000
Introduction to DBMS
ER Model
Relationship Model
Constraints
Normalization
SQL
Relational Algebra
Transaction
Serializability
Concurrency Control Techniques
File Organization & Indexing
Index Structure
B+ Tree
Boost your performance with adaptive practice tests
Practice every concept in the syllabus
Compare your speed and accuracy with your peers
Download the app and practice on the go