Consider the following table schema and R (P, C, L, A, I, T) FD1: P {C,...

 

Transcribed Image Text:

Consider the following table schema and R (P, C, L, A, I, T) FD1: P {C, L, A, I, T} FD2: {C, L} {P, A, I, T} FD3: CT FD4: A P FD5: AC A) Find all candidate keys. B) Determine the above relation in what normal form? C) If not in BCNF; convert it to BCNF. Consider the following table schema and R (P, C, L, A, I, T) FD1: P {C, L, A, I, T} FD2: {C, L} {P, A, I, T} FD3: CT FD4: A P FD5: AC A) Find all candidate keys. B) Determine the above relation in what normal form? C) If not in BCNF; convert it to BCNF.