BCA Semester 4 – Database Management System – Unit 3: Relational Database Model (4Hrs.)

Question 1

Define union compatibility. Given following relations, show the resulting relation of Director ∩ Actor and Actor ∪ Director? Director | First Name | Last Name | |------------|------------| | Deepak

Marks: 5

Year: 2021 Final TU FOHSS

1. Definition of Union Compatibility Two relations R1 and R2 are union compatible if: 1. They have the same number of attributes. 2. The corresponding attributes have compatible data types. Import

Question 2

What is relational algebra? Explain different RA operations.

Marks: 5

Year: 2023 Final TU FOHSS

Unit: DBMS – Relational Algebra --- 1. Definition of Relational Algebra Relational Algebra (RA) is a procedural query language used in relational databases to retrieve data. - It consists of a se

Question 3

How candidate key is different from primary key? Also explain foreign key in detail.

Marks: 5

Year: 2023 Final TU FOHSS

Unit: DBMS – Keys in Relational Database --- 1. Candidate Key vs Primary Key | Feature | Candidate Key | Primary Key | |---------|---------------|------------| | Definition | A set of one or more a

First Name	Last Name
Deepak	Giri
Bhuwan	KC
Dipendra	Khanel

First Name	Last Name
Deepak	Giri
Rajesh	Hamal
Dipendra	Khanel