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 superkeys
0
votes
2
answers
1
DBMS
The correct answer is a and d. I just wanted to know that why not b and c. It is possible that it may be speed and color is also a candidate key. If you have any clarification on this let me know!!!
gateexplore
asked
in
Databases
Sep 22, 2023
by
gateexplore
439
views
self-doubt
candidate-key
superkeys
rdbms
0
votes
6
answers
2
made easy test series
Consider a relation $R(ABCDEFGH)$. How many superkeys will be there in relation $R$ if the candidate keys for relation are ${A, BC, CDE, EF}$?
kaustubh7
asked
in
Databases
Sep 20, 2023
by
kaustubh7
794
views
databases
superkeys
database-normalization
made-easy-test-series
2
votes
1
answer
3
Made Easy Test Series:Database-Super-Keys
Consider the relation $R\left ( A,B,C,D,E \right )$ $A\rightarrow BC$ $C\rightarrow E$ $B\rightarrow D$ $E\rightarrow A$ Total number of superkeys present in relation will be ____________________
srestha
asked
in
Databases
May 9, 2019
by
srestha
1.8k
views
databases
superkeys
made-easy-test-series
3
votes
2
answers
4
Made easy mock test 1 DBMS super keys
Consider the following relation R(A1, A2,...A15) with (A1,A2, ... A6) of relation R are simple candidate key. The number of possible superkey in relation R is_
Ram Swaroop
asked
in
Databases
Jan 30, 2019
by
Ram Swaroop
1.2k
views
databases
superkeys
candidate-key
0
votes
1
answer
5
Self Doubt
Consider the following relation: R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many super keys are there in R?
kumar.dilip
asked
in
Databases
Jan 21, 2019
by
kumar.dilip
1.8k
views
databases
superkeys
1
vote
3
answers
6
NIELIT 2018-55
Maximum number of superkeys for the relation schema $R(X,Y,Z,W)$ with $X$ as the key is $6$ $8$ $9$ $12$
Arjun
asked
in
Databases
Dec 7, 2018
by
Arjun
3.3k
views
nielit-2018
databases
superkeys
4
votes
1
answer
7
MadeEasy Test Series: Databases - Functional Dependencies
Consider the relation R(A,B,C,D,E) with the functional dependencies : A → B, B → C, C → A, D → E, and E → D The Maximum possible super-keys of R is ______________?
naveen bhatt
asked
in
Databases
Dec 7, 2018
by
naveen bhatt
1.4k
views
made-easy-test-series
databases
database-normalization
superkeys
0
votes
1
answer
8
Super Keys
How many Super keys Possible for R(A,B,C,D,E) with 1. {A,BC,DE} as the keys ? 2. {A,BC,CDE} as the keys ?
Na462
asked
in
Databases
Oct 13, 2018
by
Na462
796
views
databases
superkeys
candidate-key
2
votes
1
answer
9
MadeEasy Test Series: Databases - Candidate Keys
Relation R(A1, A2, A3 ..... An) n attributes. On this relation m simple candidate key (m ≤ n). How many super keys possible in this relation? A. 2m – 1 B. (2n – 1) ⋅ 2n-m C. 2n – 1 D. (2m – 1) 2n-m One way is by taking instances and solve it, but plz without it what's the logic behind the answer?
Na462
asked
in
Databases
May 17, 2018
by
Na462
3.3k
views
databases
superkeys
candidate-key
made-easy-test-series
0
votes
3
answers
10
Super Key 1
Consider the following relational schema R(ABCDE). The number of super keys in relation R if every two attributes of relation R is candidate keys are __________. Please explain a general method to solve
Na462
asked
in
Databases
May 12, 2018
by
Na462
1.4k
views
superkeys
databases
0
votes
0
answers
11
Databases - Superkeys
How to calculate super key of any relation? Pls explain with example.
Dhoomketu
asked
in
Databases
Apr 8, 2018
by
Dhoomketu
355
views
databases
superkeys
1
vote
1
answer
12
No of Super Key
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many super keys are there in R? a) $_{n-2}^{n}\textrm{C}$ b) $_{n-2}^{n}\textrm{C}$ * 4 c) $_{n-2}^{n}\textrm{C}$ * n d) $_{n-2}^{n}\textrm{C}$ + n +1
hacker16
asked
in
Databases
Jan 17, 2018
by
hacker16
2.6k
views
superkeys
databases
candidate-key
2
votes
0
answers
13
No. of Super keys
a relation R(A,B,C,D,E,F,G,H) and set of functional dependencies are {CH->G,A->BC,B->CFH,E->A,F->EG } then how many possible super keys are present ? https://gateoverflow.in/42238/to-calculate-how-many-no-of-super-keys Is my approach right? ... BDE,BDF, EDF,AED,ADEF,ABDE,AFBE,AFBD,ABDEF}= 15 ways total = 15* 8 = 120 ways ....Can someone plz confirm it.... thank u
Pawan Kumar 2
asked
in
Databases
Jan 11, 2018
by
Pawan Kumar 2
996
views
superkeys
3
votes
3
answers
14
functional dependency
Let the relation R(X, Y, Z, A, B) with given functional dependencies X -> YZ Z -> A A -> B AZ -> X The number of super keys possible__________ ? Please answer with an explanation.
Warlock lord
asked
in
Databases
Aug 29, 2017
by
Warlock lord
1.2k
views
database-normalization
databases
superkeys
5
votes
2
answers
15
MadeEasy Test Series: Databases - Super Keys
Consider a relation $R$ with $2n$ attributes. Assume any $2n/2$ of the attributes constitutes key. Total number of super keys possible are: $^{2n}C_{2^{n-1}}\times \left(2\right)^{2^{n-1}}$ $^{2n}C_{2^{n-1}} + \left(2\right)^{2^{n-1}}$ $^{2n}C_{2^{n-1}} - \left(2\right)^{2^{n-1}}$ $^{2n}C_{2^{n-1}} \div \left(2\right)^{2^{n-1}}$
Tushar Shinde
asked
in
Databases
Jan 18, 2016
by
Tushar Shinde
1.1k
views
made-easy-test-series
databases
superkeys
4
votes
1
answer
16
TestBook Test Series: Databases - Super Keys
I think here even with Ph is removed from table we still get 12 Super keys. Because Salary & One of CK must be there.
Akash Kanase
asked
in
Databases
Jan 15, 2016
by
Akash Kanase
706
views
testbook-test-series
databases
database-normalization
superkeys
To see more, click for the
full list of questions
or
popular tags
.
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)
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 questions tagged superkeys
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:...