engineering recuitment ISRO Scientist Computer Science Mock Test DBMS Integrity Constraints and Normal Form Normal Form
Consider the schem a a r(A, B, C, D, E) with the following functional dependencies:
A → BC
CD → E
B → D
E → A
The decomposition of the schema into r1(A, B, C) and r2(A, D, E) is _________.
1
Lossless and dependency preserving
2
Lossy and dependency preserving
3
Lossless and non dependency preserving
4
Lossy and non dependency preserving