(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I,...

 

Transcribed Image Text:

(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F = { {A, B} {C}, {A} → {D,E}, {B}→{F}, {F}→{G,H}, {D} -> {I, J}}. 1. Derive the key for R. 2. Decompose R into 2NF, then 3NF relations. (b) Consider the universal relation R(A, B, C, D, E, F, G) and the set of functional dependencies A --> B, B --> {A, C, E, C --> {B, F, D}, F --> {D, G} Derive the key for R (c) Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F as follows; F = { AB → C, BD → EF, AD → GH, A →→I, H→J}. Find the key of relation R. (a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F = { {A, B} {C}, {A} → {D,E}, {B}→{F}, {F}→{G,H}, {D} -> {I, J}}. 1. Derive the key for R. 2. Decompose R into 2NF, then 3NF relations. (b) Consider the universal relation R(A, B, C, D, E, F, G) and the set of functional dependencies A --> B, B --> {A, C, E, C --> {B, F, D}, F --> {D, G} Derive the key for R (c) Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F as follows; F = { AB → C, BD → EF, AD → GH, A →→I, H→J}. Find the key of relation R.

Answer rating: 100% (QA)

a Key AB Explanation Let us find attribute closure of AB We add AB to attribute closure first Now fr... View the full answer