Comprehensive questions and detailed answers for Unit 3: Relational Database Model (4Hrs.). Perfect for exam preparation and concept clarity.
Define union compatibility. Given following relations, show the resulting relation of Director ∩ Actor and Actor ∪ Director?
Director
| First Name | Last Name |
|---|---|
| Deepak | Giri |
| Bhuwan | KC |
| Dipendra | Khanel |
Actor
| First Name | Last Name |
|---|---|
| Deepak | Giri |
| Rajesh | Hamal |
| Dipendra | Khanel |
What is relational algebra? Explain different RA operations.
How candidate key is different from primary key? Also explain foreign key in detail.