I have a table with 5 columns as A, B, C, D, and E. The functional dependencies are:
- AB -> C,D,E
- BCD -> A
- BCE -> A,D
- BD -> E
I think AB is the candidate key. I can't find any other candidates. Since I have a two-column key, BCE cannot be a candidate. Am I Right? What I am trying to do is to normalize this table to BCNF but I couldn't figure this table out. It looks like there is no repetitive data and also there is no transitive dependencies. This table looks like BCNF but I think I am missing something. I find it difficult to understand BCNF so can you please help?