In the following two tables, find the union value of employee and emp. EMPLOYEE Emp. No. 1000 222 1002 1003 1004 Name Abishek Garg Prachi Goal Simran Dua Rishika Pal Mohit Batra
Advertisements
Advertisements
Question
In the following two tables, find the union value of employee and emp.
EMPLOYEE
| Emp. No. | Name | Salary |
|---|---|---|
| 1000 | Abishek Garg | 25000 |
| 222 | Prachi Goal | 30000 |
| 1002 | Simran Dua | 25000 |
| 1003 | Rishika Pal | 40000 |
| 1004 | Mohit Batra | 23000 |
EMP
| Emp. No. | Name | Salary |
|---|---|---|
| 1002 | Simran Dua | 25000 |
| 1004 | Mohit Batra | 23000 |
| 1007 | Sonal Gupta | 26000 |
| 1009 | Rohit Batia | 50000 |
Short Answer
Advertisements
Solution
The duplicate records (1002, Simran Dua, 25000) and (1004, Mohit Batra, 23000) are included only once.
| Emp. No. | Name | Salary |
|---|---|---|
| 1000 | Abishek Garg | 25000 |
| 222 | Prachi Goal | 30000 |
| 1002 | Simran Dua | 25000 |
| 1003 | Rishika Pal | 40000 |
| 1004 | Mohit Batra | 23000 |
| 1007 | Sonal Gupta | 26000 |
| 1009 | Rohit Batia | 50000 |
Result: The union has degree 3 and cardinality 7.
shaalaa.com
Is there an error in this question or solution?
