Recent questions tagged 3nf / GATE Overflow for GATE CSE

0 votes

0 answers

1

Self-doubt [Foreign keys and Third Normal Form]
I've some elementary doubts regarding Foreign keys (referential integrity) : Can a foreign key consist of a collection of attributes - ie. can two or more columns collectively form a foreign key? If foreign key ... Multiple candidate keys Composite candidate keys Overlapping candidate keys If possible, please provide an example. Thank You.!

I've some elementary doubts regarding Foreign keys (referential integrity) :Can a foreign key consist of a collection of attributes - ie. can two or more columns collecti...

Harsh Kumar

1.0k views

Harsh Kumar asked Nov 19, 2018

0 votes

2 answers

2

Normalization - 3NF doubt
A relation has the attributes R(ABCDEPG). The set of Functional Dependencies are : $F: { AB \to CD, DE \to P, C\to E, P\to C, B \to G }$ ... A LOSSLESS AND DEPENDENCY PRESERVING PROPERTY IN 3NF - But I am not getting the Dependency Preservation property. Is something wrong with the decomposition ?

A relation has the attributes R(ABCDEPG). The set of Functional Dependencies are :$F: { AB \to CD, DE \to P, C\to E, P\to C, B \to G }$After normalising this relation til...

Harsh Kumar

1.1k views

Harsh Kumar asked Jul 4, 2018

2 votes

2 answers

3

3NF-property
A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R Here, what is the actual meaning of word key ? Does it mean prime attribute or super key or non-prime attribute ? plzz explain...

A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of RHere, what is the actual meaning of word key ? Does it mean prim...

rishu_darkshadow

539 views

rishu_darkshadow asked Sep 20, 2017

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