If all variables are a subset of the superkey, is the database design 5NF? [migrated]
- by Lukazoid
I have a table called LogMessages, which has the following columns:
Level
A numeric value which represents Trace, Debug, Info, Warning, Error or Fatal
Time
A UTC time
Message
Foreign key to a Messages table
Source
Foreign key to a Sources table
User
Foreign key to a Users table
From what I can see, all of these columns are a part of the super key; if any single value differs to an existing row, a new row can be created.
My question is, does this design comply to fifth normal form? I am unsure as some groups of data will be repeating, however I don't believe this violates 5NF? (correct me if I'm wrong)