engineering recuitment NIC NIELIT Scientist B 2023 Mock Test DBMS Query Language Relational Calculus

Find the customers having account all branches located in Hyderabad. Use the above relations and find which of the following query is not giving the same.

1

{t | ∀ S ϵ Branch (s[city] = “Hyd” ⇒ 4ϵ deposit

(4[Bname] = S [Bname] ^ t[cname] = 4 [cname]))}
2

{| ∀m,t,e (7C<(n,t,c) ϵ Branch ∀ t = ‘Hyd’)

V → a,b,n ( ϵ Deposit)}
3

Step 1 : R1 ← πbname (TMcity=Hyd’ (branch))

Step 2 : R2      \({\pi _{\begin{array}{*{20}{c}} {cname}\\ {bname} \end{array}}}\left( {T{M_{city{ = '}Hyd'}}\left( {Deposit⋈Branch} \right)} \right)\)

Step 3 : R2/R1
4
all the above are giving the same result
Share: WhatsApp Telegram X

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Other Tools: chatwiz.hivanix.in mmspace.hivanix.in unogame.hivanix.in

Quick Navigation

Home

Subjects

Chapters