Let the following two relational schemas be given With primary keys as…
Let the following two relational schemas be given
With primary keys as underlined. The relation employee contains 1500 tuples and the relation department contains 1000 tuples. What is the maximum number of tuples in (Employee ⨝ Department)?
Answer: 1500 — Here every tuple in Employee can join to at most one tuple in Department since Dno is primary key in Department table. So, the maximum number of tuples is 1500.
Attempted by 18 students.
Show answer & explanation
Correct answer: 1500
Here every tuple in Employee can join to at most one tuple in Department since Dno is primary key in Department table. So, the maximum number of tuples is 1500.
Loading lesson…