Dark Mode

Recent questions tagged 3nf

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.!

Harsh Kumar asked in Databases Nov 19, 2018

959 views

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 ?

Harsh Kumar asked in Databases Jul 4, 2018

1.1k views

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...

rishu_darkshadow asked in Databases Sep 20, 2017

by rishu_darkshadow

515 views

To see more, click for the full list of questions or popular tags.

Recent questions tagged 3nf