Given two tables R1(x,y) and R2(y,z) with 50 and 30 numbers of tuples respectively. Find the maximum number of tuples in the output of natural join between tables R1 and R2 i.e. R1 * R2. (* - Natural Join)
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. 1500
Explanation
If every tuple has the same y value, every R1 tuple matches every R2 tuple: 50 × 30 = 1500.
More Database Management Systems questions
- Given two tables EMPLOYEE (EID, ENAME, DEPTNO) DEPARTMENT (DEPTNO, DEPTNAME) Find the most appropriate statement of the given query : Selec…
- Find the minimum number of tables required for converting the following entity relationship diagram into a relational database.
- Two concurrent executing transactions 1 and T 2 are allowed to update same stock item say ' A ' in an uncontrolled manner. In such scenario…
- Minimal cover of functional F dependency set is
- Identify primary key of table with F functional dependency set
- Identify the normal form in which relation R belong to