954,597 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Need help in normalizing this database table

I am developing a project which is going to use this database table, but I am not getting the complete normalized form of this table. I am not practically strong with normalization so every time I try to make it I end up in no where. The table is attached with this post in a .doc file. Can someone dedicate some time for it, its not a big one.

Attachments dbtonormalize.doc (47.5KB)
warlord902
Junior Poster
120 posts since Dec 2010
Reputation Points: 19
Solved Threads: 0
 

Resolve the functional dependencies to get to 3NF.
Each user has exactly one password, but obviously can have several usernames on various protocols with single passwords.
So the only dependent value which should go in the primary table together with the user name is the password:
Table Users (id_user, username, password)
Table Users_and_Protocols (id_user, protocol, p_username, p_password)

If you want to have better control on the protocol names store them in a reference table: Table Users (id_user, username, password)
Table Users_and_Protocols (id_user, id_protocol, p_username, p_password)
Table Protocols (id_protocol, protocol)

smantscheff
Nearly a Posting Virtuoso
1,233 posts since Oct 2010
Reputation Points: 300
Solved Threads: 254
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: