1

I am an ICS student and I have been given two questions.

1.) List all the Functional Dependencies that hold for the database.

2.) For each relation in your relational schema write down whether the relation is in BCNF or 3NF and if not give a violating FD.

I'm just having problems understanding the relationship between functional dependencies and the ER Diagram. I've watched a few videos online but I'm still getting stuck on how to answer the two above questions and would appreciate some help in finding the right direction.

Below is an ER diagram and I was hoping someone could give some examples on how to start from here.

enter image description here

philipxy
  • 14,867
  • 6
  • 39
  • 83
Jarrod Lofy
  • 195
  • 2
  • 3
  • 11

1 Answers1

1

  • For each entity set (e.g. Department), each attribute is an FD (e.g. Department Name -> Location).

  • For each relationship set (e.g. Offers), there's an FD from the combination of keys of "many" entities to each of the keys of "one" entities (e.g. Course_ID -> Department Name)

reaanb
  • 9,806
  • 2
  • 23
  • 37
  • Thank you, that makes FD's much clearer, however I still don't get the differences between BCNF and 3NF – Jarrod Lofy Apr 21 '16 at 16:37
  • See http://stackoverflow.com/questions/8437957/difference-between-3nf-and-bcnf-in-simple-terms-must-be-able-to-explain-to-an-8 – reaanb Apr 22 '16 at 05:21