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.
warlord902 9 Junior Poster
smantscheff 265 Veteran Poster
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) Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.