A schedule of three database transactions T1, T2, and T3 is shown. Ri(A) and Wi(A) denote read and write of data item A by transac…
Consider two relations describing teams and players in a sports league: - teams(tid,tname): tid, tname are team-id and team-name, …
Consider a relational schema team(name, city, owner), with functional dependencies {name → city, name → owner}. The relation team …
Consider the following database tables of a sports league. player(pid,pname,age) coach(cid,cname) team(tid,tname,city,cid) memb…
An audit of a banking transactions system has found that on an earlier occasion, two joint holders of account A attempted simultan…
Consider the following relational schema along with all the functional dependencies that hold on them. R1(A,B,C,D,E): {D → E, EA →…
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.