Represent three way database functional dependency in 5th normal form
00:40 08 May 2009

How could one represent a composite key functional dependency of a non key column in 5NF (Fifth Normal Form)?

users
----------
id
name

events
----------
id
name

events_users
---------------------------
id
user_id
event_id
participation_type (ENUM)

5NF needs each table to be represented in its own small entity.

What is the reason having participation_type in events_users is in or not in 5NF?

What is a better solution?

I've been using the DataMapper library of CodeIgniter, where each table needs to exist independently, i.e be in 5NF.

database-design relational-database database-normalization functional-dependencies