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.

Is that a task for me ?

Is that a task for me ?

yes, i believe it is meant to be.

Just a question dude, by any chance do you go to RMIT and are you in Database Concepts Semester 2? This looks like assignment 2........lol

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.