Q. In a Database School there are two tables Member and Division as shown below.
Table: Member
|
Empld |
Name |
Pay |
Divno |
|
1001 |
Shankhya |
34000 |
10 |
|
1003 |
Ridhima |
32000 |
50 |
|
1002 |
Sunish |
45000 |
20 |
Table: Division
|
Divno |
Divname |
Location |
|
10 |
Media |
TF02 |
|
20 |
Dance |
FF02 |
|
30 |
Production |
SF01 |
(i) Identify the foreign key in the table Member.
(ii) What output, you will get, when an equi-join query is executed to get the NAME from Table and corresponding from Division table?
Answer :-
i = Divno
ii =
|
Name |
Divname |
|
Shankhya |
Media |
|
Sunish |
Dance |
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )