# 3NF for table layout

normalization

Assuming a table with the following columns

UserID, UserName, Console, GameID,
GameTitle, GameVendor, VendorCountry, Game Genre, NumberOfPlayers


Is this the correct 3NF?

Users(UserID,UserName, Console)

Games(GameID,GameVendor,GameTitle,GameGenre,NumberOfPlayers)

Vendors(GameVendor, VendorCountry)


None column can depend of non-key columns and need depend exclusive of primary key. That is, The third normal form states that you should eliminate fields in a table that do not depend on the key.

To be in the third normal form the entity must be meeting 2FN and 1FN.

Obviously, if you want to get a better answer you need inform more details of scope to we understand of what is being designed and the purpose of each column.

However, based on the information what you put in your question, the console does not depend on the user ID in the USERS table. So, I Believe that there must have more tables to controls console information:

CONSOLE(id, type)

GAME_GENRE(id,type)

GAMES(id,gameVendor,gameTitle,gameGenreId,numberOfPlayer)

CONSOLE_GAME(id, consoleId, gameId)