Databases - Transactions and concurrency control
- Option : B
- Explanation : empdt1 {empcode, name, street, city, state, pincode)
Given functional dependency
pincode -> (city) (state)
(street) (city) (state) -->pincode
This is in I NF and 2NF but not in 3NF because it contains transitive dependency.
Hence the correct answer is (b).
- Option : A
- Explanation : Primary key (candidates key) for this relation is [F1] [F2] because [F1, F2] column contains [F1, F2, F3, F4, F5]
So, there is, functional dependency F1 -> F3, F2
It also has partial dependency so it is not in 2nd, 3rd NF.
- Option : B
- Explanation : CD—>A {CD —>E;E —> A; E —>C}
CD —> C
BC —> CD
B—>D;
CD—>E;
E—>A;
A—>C
AC—>BC:
A—>B:
A—>C
