1
vote
0answers
27 views

Identifying functional dependencies

I'm having trouble understanding the logic in use for identifying functional dependancies. Looking at the sample relation below, I understand fd1 - fd3. But when I look at fd4 and fd5, its logic ...
0
votes
0answers
12 views

Functional Dependencies Query

I am having a confusion in Functional Dependencies I have a relation R(A,B,C,D,E,F) Where {A, B} is the key And the FD set I have is {A->FC, C->D, B->E} What Normal Form is it in? Basically I want ...
1
vote
2answers
109 views

Relations, dependencies and normal form

I have some issues in understanding about relations and dependencies. I will show two examples and what I want to know: Assume the relation GTX {G,T,X} with the following dependencies: G,X -> T ...
2
votes
2answers
556 views

Why is this relation in 3NF?

I have a relation: R4 = {{T,U,V}, {T → U, U → T, T → V}} I know from looking at the answer key that this relation is in BCNF. I'm going through the process of rigorously determining what normal ...