Register

Recent questions tagged superkeys

0 votes
1 answer
1
Number of Super Keys
R(A1, A2,A3,A4....AN). How many super keys possible in relation? If (A1 is candidate key, A2 is candidate key, A3 is candidate key)
R(A1, A2,A3,A4....AN). How many super keys possible in relation? If (A1 is candidate key, A2 is candidate key, A3 is candidate key)
User Avatar
0 votes
2 answers
2
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!!!
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 clarific...
User Avatar
0 votes
6 answers
3
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}$?
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}$?
User Avatar
2 votes
1 answer
4
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 ____________________
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 ...
User Avatar
3 votes
2 answers
5
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_
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_
User Avatar
0 votes
1 answer
6
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?
Consider the following relation:R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many superkeys are there in R?
User Avatar
1 votes
3 answers
7
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$
Maximum number of superkeys for the relation schema $R(X,Y,Z,W)$ with $X$ as the key is$6$$8$$9$$12$
User Avatar
4 votes
1 answer
8
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 ______________?
Consider the relation R(A,B,C,D,E) with the functional dependencies :A → B, B → C, C → A, D → E, and E → DThe Maximum possible super-keys of R is ______________...
User Avatar
0 votes
1 answer
9
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 ?
How many Super keys Possible for R(A,B,C,D,E) with1. {A,BC,DE} as the keys ?2. {A,BC,CDE} as the keys ?
User Avatar
0 votes
3 answers
11
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
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 ex...
User Avatar
0 votes
0 answers
12
Databases - Superkeys
How to calculate super key of any relation? Pls explain with example.
How to calculate super key of any relation?Pls explain with example.
User Avatar
1 votes
1 answer
13
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
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many superkeys are there in R?a) $_{n-2}^{n}\textrm{C}$b) $_{n-2}^{n}\textrm{C}$ * 4c) $_{n-...
User Avatar
3 votes
3 answers
15
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.
Let the relation R(X, Y, Z, A, B) with given functional dependenciesX - YZZ - AA - BAZ - XThe number of super keys possible__________ ?Please answer with an explanation.
User Avatar
4 votes
1 answer
17
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.
I think here even with Ph is removed from table we still get 12 Super keys. Because Salary & One of CK must be there.
User Avatar
To see more, click for the full list of questions or popular tags.