Member Avatar for ozlem.a17

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.

  • 4 Contributors
  • 3 Replies
  • 92 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Anonymous01

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

Is that a task for me ?

Member Avatar for harry010

Is that a task for me ?

yes, i believe it is meant to be.

Member Avatar for Anonymous01

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.