Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged relational-algebra
4
votes
1
answer
1
GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 13
Division operator in relational algebra is appropriate to handle which of the following query types? employees work on at most one of the critical projects employees work on any one of the critical projects employees work on at least one of the critical projects employees work on all the critical projects
GO Classes
asked
in
Databases
Feb 5
by
GO Classes
314
views
goclasses2024-mockgate-14
databases
relational-algebra
1-mark
0
votes
0
answers
2
Memory Based GATE DA 2024 | Question: 47
You are given three tables: `team`, `table1`, and `table2`. To find the names of all players in the team who are either present in `table1` or `table2`, consider the following relational algebra queries: \(\Pi_{\text{{PlayerName}}}(\text{{team}}) \,/\, \ ... text{{Name}}}(\text{{table1}} \cap \text{{table2}}) \,/\, \Pi_{\text{{PlayerName}}}(\text{{team}})\)
GO Classes
asked
in
Databases
Feb 5
by
GO Classes
96
views
gate2024-da-memory-based
goclasses
databases
relational-algebra
3
votes
1
answer
3
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 31
Let $\text{R}_1, \text{R}_2, \ldots,\text{ }R_n$ be a decomposition of schema $\text{U}$. Let $u(\text{U})$ be a relation, and let $r_i=\Pi_{\text{R}_i}(u)$ ... $u=r_1 \bowtie r_2 \bowtie r_3 \bowtie r_4 \bowtie . . r_n$ None of the above
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
346
views
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
1-mark
3
votes
2
answers
4
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 65
Let $r(X, Y)$ and $s(Y)$ be two relations. What is returned by the following relational algebra query? Values of $r.X$ which are related to every value of $s.Y$. Values of $r.Y$ which are related to every value of $s.Y$. ... which are not related to some value of $s.Y$. Values of $r.X$ which are not related to any value of $s.Y$.
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
418
views
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
2-marks
0
votes
0
answers
5
testbook
Can you help me understand the last 2 options
Rohit Chakraborty
asked
in
Databases
Jan 4
by
Rohit Chakraborty
117
views
testbook-test-series
rdbms
relational-algebra
0
votes
0
answers
6
Hamburg University Exercise 4.1 Sizes of Relations
Given two relations R1 and R2 where R1 contains N1 tuples and R2 contains N2 tuples, give the minimum and maximum possible sizes (in tuples) for the relation produced by each of the following relational algebra expressions. Try to be as accurate as possible (i.e., formulate ... - (πB(R1) - πB(R2))| ≤ N1 (10): 0 ≤ |σA>B(R1) ∪ σA<B(R1)| ≤ N1
beginner
asked
in
Databases
Nov 1, 2023
by
beginner
192
views
databases
relational-algebra
0
votes
1
answer
7
Database
Considering the following schema, create the appropriate tables and insert at least 5 records: AUTHOR(author-id,name, city,country) PUBLISHER (publisher-id, name,city, country) CATALOG (book-id, title, author-id, publisher-id, category-id, year, price) CATEGORY ( ... in the catalog. (g) Obtain the author and publisher who have published books in more than or 14 equal to 2 categories.
gateexplore
asked
in
Databases
Jun 30, 2023
by
gateexplore
885
views
sql
relational-algebra
databases
self-doubt
Page:
1
2
3
4
5
6
...
11
next »
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(24)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(682)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
243k
comments
79.6k
users
Recent questions tagged relational-algebra
Recent Blog Comments
Hlo I'm Rupesh I got AIR 3485 in gate CS and AIR...
@Ajay Sasank here is the direct link...
Thank you for the post didi My GATE 2023 & 2024...
I Hope it helps 😊
Today's best post I seen thank you for motivation