Bsc CSIT Semester 4 – Database Management System – Unit 5: The Relational Algebra and Relational Calculus (5 Hrs.)

Question 1

Explain the difference between “Join” and “Natural Join” of algebriac operations with example.

Marks: 5

Year: 2078 Final TU

1. Join (θ-Join / Equi-Join) - A Join combines tuples from two relations based on a condition (θ). - The condition can use any comparison operator (=, <, >, etc.). - The result includes all attributes

Question 2

Retrieve the TName, and Noofpriod of teachers who teach in “ABC” school using Relational Algebra.\ TEACHER (TID, TName, TAddress, TQualification)\ SCHOOL (SID, SName, SAddress, SPhone)\ SCHOOLTEACHER

Marks: 5

Year: 2079 Final TU

Question Retrieve the TName and NoofPeriod of teachers who teach in “ABC” school. Given Relations: - TEACHER(TID, TName, TAddress, TQualification) - SCHOOL(SID, SName, SAddress, SPhone) - SCHOOL

Question 3

What is tuple relational calculus? Explain.

Marks: 5

Year: 2080 Final TU

1. Definition Tuple Relational Calculus (TRC) is a non-procedural query language used in the relational model. - In TRC, queries are expressed as formulas describing the desired information without

Question 4

Write short notes on:\ a. Natural join\ b. Shadow paging

Marks: 5

Year: 2080 Final TU

a. Natural Join Definition: - A Natural Join is a type of join operation in relational algebra and SQL that automatically combines tables based on columns with the same name and compatible data type

Question 5

What is tuple realtion calculus ? Given the following schema, write tuple relational calculus for selecting name and address of employee who are working in a company having Cid=E01 Employee(Eid, Ename

Marks: 5

Year: 2080 Final TU

Tuple Relational Calculus (TRC) and Example 1. Tuple Relational Calculus Definition: Tuple Relational Calculus (TRC) is a non-procedural query language in which queries are expressed by specifying

Question 6

Explain relational algebra natural join () operation with example.

Marks: 5

Year: 2081 Final TU

Natural Join () Operation in Relational Algebra A Natural Join is a relational algebra operation that combines two relations (tables) based on all common attributes between them. It automatically ma