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
Aggregate Functions in relational algebra
aditi19
asked
in
GATE
Nov 3, 2018
1,268
views
0
votes
0
votes
is aggregate functions in relational algebra important with GATE's perspective or can I skip it?
relational-algebra
databases
aditi19
asked
in
GATE
Nov 3, 2018
by
aditi19
1.3k
views
answer
comment
Follow
share this
share
3 Comments
by
Shaik Masthan
commented
Nov 3, 2018
reply
Follow
share this
you can't skip those
0
0
by
aditi19
commented
Nov 4, 2018
reply
Follow
share this
ok... thank u
0
0
by
Deepak Poonia
commented
Sep 22, 2019
reply
Follow
share this
From Relational algebra point of view, Yes, You can safely skip.
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
no yes its important for gate u can do just few
sum
min
max
avg
count
Rackson
answered
Nov 14, 2018
by
Rackson
comment
Follow
share this
1 comment
by
aditi19
commented
Nov 14, 2018
reply
Follow
share this
u mean in relational algebra or SQL?
0
0
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
2
votes
2
votes
4
answers
1
Keith Kr
asked
in
Databases
Jan 31, 2015
2,287
views
True or False: Relational algebra cannot perform aggregate function
True or False: Relational algebra cannot perform aggregate function
Keith Kr
asked
in
Databases
Jan 31, 2015
by
Keith Kr
2.3k
views
relational-algebra
normal
0
votes
0
votes
0
answers
2
ayushrathore111
asked
in
Databases
Nov 28, 2022
814
views
a) Following relational schema is given: Doctor (DName, Reg_no,D_City), Patient (Pname, Disease, P_City) and Assigned To (Pname, Dname) Give expression in Relational Algebra for each of the queries: i) Get the names of patients who are assigned to more than one doctor. ii) Get the names of doctors who are treating patients with 'Polio’. iii) Get the details of doctors who are treating to the patient belongs to the same city. iv) Count the number of patients treated by each doctor
ayushrathore111
asked
in
Databases
Nov 28, 2022
by
ayushrathore111
814
views
databases
relational-algebra
0
votes
0
votes
1
answer
3
Fida
asked
in
Databases
Oct 18, 2018
597
views
How to know which type of join shall I apply in dbms relational algebra?
I'm confused when to you which join and cross product. Please help me
Fida
asked
in
Databases
Oct 18, 2018
by
Fida
597
views
databases
relational-algebra
4
votes
4
votes
2
answers
4
Parshu gate
asked
in
Databases
Nov 11, 2017
1,283
views
projection in relational algebra
For the relation instances A and B, A/B is the largest relation instance Q such that Q B ⊆ A. Consider A has exactly two fields x and y and B has just one field y with the same domain as in A. Division operation A/B is defined as the set of all x values (in the form of unary tuples) such ... A) - B) (C) πx(A) - πx((πx(A) B) - A) (D) πx(A) - πx((πx(B) A) - A)
Parshu gate
asked
in
Databases
Nov 11, 2017
by
Parshu gate
1.3k
views
relational-algebra
databases
relations
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
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
GATE
(531)
CBSE/UGC NET
(15)
CSIR NET
(2)
TIFR
(273)
CMI
(1)
ISI
(3)
ISRO
(36)
BARC
(7)
IIITH-PGEE
(12)
BITS-HD
(0)
Others
(697)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy