3a part 2

6 92% CO Sun 9:42 PM Go Tools Window Help D New Doc 2018-03-11.pdf (page 2 of 7) 3. a) i)Given a relation Re (A,B,C,D,E,H and having the following FDs: (1 Mark) find the key for relation R with FD F ii) Consider the instance of a relation and its functional dependency: Account Client Office oe Mary John Joe F-{Client, Office Client, Office, Account Is this schema in 3NF ? Justify your answer Is BCNF advisable? Justify your answer : Account Office) (1 +1-2 Marks) 3. b) Given R(AB,C,D) and F. { A,B CD; B->C; A,C-B). Decompose R using 3NF decomposition algorithm. (2 Marks)