Register

Recent questions tagged goclasses-da-dpp-day-284

1 1 vote
1 1 answer
143
143 views
GO Classes DPP | GATE CS, DA | DBMS | TRC
Consider$\mathrm{STUDENT}(\mathrm{name},\mathrm{regno},\mathrm{gpa},\mathrm{level},\mathrm{dept})$$\mathrm{COURSE}(\mathrm{cno},\mathrm{cname},\mathrm{dept})$$\mathrm{TAK...
User Avatar
1 1 vote
1 1 answer
96
96 views
GO Classes DPP | GATE CS, DA | DBMS | SQL to TRC
Consider$\mathrm{Product}(\mathrm{pid},\mathrm{name},\mathrm{brand},\mathrm{price},\mathrm{color})$.The SQL query is:SELECT DISTINCT name FROM Product p WHERE color = 'gr...
User Avatar
1 1 vote
1 1 answer
55
55 views
GO Classes DPP | GATE CS, DA | DBMS | Multi-Relation TRC
Consider$\mathrm{Store}(\mathrm{sid},\mathrm{store\_name},\mathrm{parent\_company})$$\mathrm{Branch}(\mathrm{sid},\mathrm{city},\mathrm{open24})$$\mathrm{Has\_Fruit}(\mat...
User Avatar
0 0 votes
1 1 answer
59
59 views
GO Classes DPP | GATE CS, DA | DBMS | Joining Relations in TRC
Consider$\mathrm{Breeders}(\mathrm{brdr\_id},\mathrm{brdr\_name},\mathrm{age})$$\mathrm{Breeds}(\mathrm{br\_id},\mathrm{br\_name},\mathrm{friendliness})$$\mathrm{Pedigree...
User Avatar
1 1 vote
1 1 answer
58
58 views
GO Classes DPP | GATE CS, DA | DBMS | TRC
Consider $\mathrm{Pets}(\mathrm{pid},\mathrm{pname},\mathrm{weight})$.Which TRC expression returns only the weights of all pets whose name is $\mathrm{Tiny}$?$\{t\mid \ex...
User Avatar
To see more, click for the full list of questions or popular tags.