765 views
1 votes
1 votes
consider:

T1: {A11, A12, A13} - key is A11
T2: {A21, A22, A11} - key is A21
T3: {A21, A23} - key is {A21 A23}

T1, T2, T3 all are in which normal form?

a) 2nf

b) 3nf

c) BCNF

FUNCTIONAL DEPENDENCIES ARE NOT MENTIONED. SO, PLEASE EXPLAIN HOW TO CHECK NORMAL FORM FOR THE RELATION?

Please log in or register to answer this question.

Related questions

5 votes
5 votes
1 answer
1
Ankush Kundaliya asked Jan 17, 2017
794 views
Determine the highest normal for relation R(A,B,C,D)AB →CBC→D
2 votes
2 votes
2 answers
2
gatecrack asked Dec 10, 2018
601 views
Is minimal set of functional dependency for a functional dependency set is always unique???
3 votes
3 votes
2 answers
3
sanyam53 asked Jan 11, 2017
896 views
Consider a schema R(A, B, C, D) and functional dependencies {AB → C, C → D, D→ A}. Then the decomposition of R into R1 (CD), R2 (AC) and R3 (BC) is ina. 1NF but not...
3 votes
3 votes
4 answers
4