4,704 views
3 votes
3 votes

Consider the following functional dependencies on the relation $R(A,B,C,D,E)$

$\begin{align*} A\rightarrow BC \\BC\rightarrow AD \\D\rightarrow E \end{align*}$

Question 1

  What is the heighest Normal Form  the above Relation Satisfies

Question 2

What are different  the Non-Prime attributes in the relation ?

Question 3

Justify the statement

 "If a relation to be in 3NF then Non-Prime Attributes MUST NOT determine non-prime attributes"

1 Answer

Best answer
6 votes
6 votes

first find out the candidate keys in...
A→BC
BC→AD
D→E 
candidate keys are={A,BC} now B and C are prime attributes here and D and E are non prime attributes..
so D->E is a transitive dependency(means non prime attribute deriving non prime attribute)..so highest normal form is 2NF only..
 

selected by

Related questions

5 votes
5 votes
4 answers
1
learncp asked Dec 17, 2015
5,306 views
Given R(ABCD) andAB → C ;ABD → C ;ABC → D ;AC → Dwhich the highest possible normal form for the above relation ?
3 votes
3 votes
3 answers
2
learncp asked Dec 16, 2015
9,985 views
Given a relation R (ABCD), and the following FDs- A->BCDBC->ADD->B.which is the highest normal form the table is in.a) 1NFb) 2NFc)3NFd) BCNF
2 votes
2 votes
4 answers
3
Dulqar asked Feb 1, 2017
939 views
Consider the relation R(Name,courseNO,rolNO,grade)name,courseno ->graderollno,courseno->gradename->rollnorollno->name Given answer as it is 3NF . But Im getting 1NF. is ...
2 votes
2 votes
2 answers
4