For an ER diagram, I have to:
1. Produce a set of relations. Indicate all primary and foreign keys.
2. For each relation give the minimal basis for all FDs on the relation, and state whether the relation is in 3NF or BCNF and why.
I am fine with doing the first section, but am unsure how to do the second as i am not sure what FDs, 3NF and BCNF are. If someone could explain to me what they are and give an example of how i would answer the second part I would really appreciate it.
Thanks in advance.
PS. I have attached an ER diagram to reference for whatever purposes.