3NF question

I am still not sure about meaning of 3NF

Let's say I've got a table, named USERS:

Id Login Pass Description

Id was selected as a key, but login has to be unique, so it's also a key. There are dependencies:

Id -> Pass, Description
Login -> Pass, Description
Id -> Login
Login -> Id

is this 3NF or should it be decomposed to two tables like this:

Id Login
Login Pass Description

thanks in advance, Elves Received on Sat Jan 08 2005 - 14:35:44 CET