If I have relation schema R(A, B, C, D, E) with functional dependencies: AB->C, CD->E, C->A, E->D, then what are the keys for R and what is the normal form of R? How can I achieve a higher normal form?
Asked
Active
Viewed 929 times
-1
-
[This SO answer](http://stackoverflow.com/a/14659070/562459) should help you identify all the keys. – Mike Sherrill 'Cat Recall' Feb 04 '13 at 23:20
1 Answers
0
A possible set of keys would be (A, B, D).
A normal form would consist of the tables (A, B, C, D) and (C, D, E).
There is no general rule to achieve a higher normal form. It depends on which normal form you currently have and which normal form you want to achieve. You will have to do whatever is necessary to meet the requirements of the normal form you want to achieve.
Patrick Kostjens
- 5,065
- 6
- 29
- 46