Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Supporter
Impact
~689 people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Oct
6
comment Representing N:N relation as a functional dependency in a database design
If I were to implement this in a real-world system I would use surrogate keys and a third table with two foreign key columns. I'm going to ask him on Monday about this and accept your answer if there really is no solution.
Oct
6
comment Representing N:N relation as a functional dependency in a database design
I think you're right but my teacher is a natural key zealot and he wouldn't accept any other solution.
Oct
6
comment Representing N:N relation as a functional dependency in a database design
Category is a primary attribute in your example, which must be unique.