Recent questions tagged functional-dependency / GATE Overflow for GATE CSE

0 votes

2 answers

31

When is a group of attributes prime?
Given the candidate keys CD and DE and the functional dependency AB->CDE. Is CDE considered prime because all attributes (C, D and E) are prime? Or is it non-prime because CDE is not found in a candidate key as a whole? Therefore, my question is if a group of prime attributes is also prime due to its attributes or it has to be part of a candidate key as well.

Given the candidate keys CD and DE and the functional dependency AB->CDE. Is CDE considered prime because all attributes (C, D and E) are prime? Or is it non-prime becaus...

Mira67

721 views

Mira67 asked Feb 20, 2023

0 votes

1 answer

32

Database | BCNF
Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }. Consider the following statements Statement I: The following relation is in BCNF, as A,B and C are key. Statement II: A prime attribute cannot be ... I and II both are correct. None of statement I and II is correct Only statement II is correct. Only statement I is correct.

Consider the following relation, R(A,B,C) and the following functional dependencies FD={ A→B, B→C, C→A }.Consider the following statementsStatement I: The following...

Souvik33

526 views

Souvik33 asked Dec 10, 2022

1 votes

1 answer

33

Gate@Zeal 2023
Please Explain ans is 8

Please Explainans is 8

SKMAKM

371 views

SKMAKM asked Sep 24, 2022

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