Consider a table “STUDENT”-
|
ID |
Name |
Age |
B_id |
Branch |
HOD |
|
TB349 |
Mahesh |
28 |
101 |
CSE |
Rishi |
|
TB104 |
Ravi |
36 |
101 |
CSE |
Rishi |
|
TB129 |
Yashvi |
26 |
101 |
CSE |
Rishi |
|
TB350 |
Swati |
27 |
101 |
CSE |
Rishi |
|
TB130 |
Vaishnavi |
25 |
101 |
CSE |
Rishi |
When a given table is decomposed into two tables-
STUDENT-1 (ID, Name, Age, B_id)
STUDENT-2 (B_id, Branch, HOD)
Where the ‘X’ is the numbers of tuple in the table STUDENT-1 and ‘Y’ is the number of tuples in the table STUDENT-2.
Then what will be the value of X + Y?
Enter numerical value using the virtual keypad. Round off where necessary.