Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
Normalization:Different forms ,need help in understanding them
Savita Joshi
Apr 20 2011 12:04 AM
3.5k
Reply
Hi,
I have read articles on this but did not understand much. Can someone elaborate the following:
1NF: Eliminate Repeating Groups
Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
2NF: Eliminate Redundant Data
If an attribute depends on only part of a multi-valued key, remove it to a separate table.
3NF: Eliminate Columns Not Dependent On Key
If attributes do not contribute to a description of the key, remove them to a separate table. All attributes must be directly dependent on the primary key..
Need to understand it in detail.. ..
Thanks
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
disadvantages of using an ERD instead of a class diagram when using Object Oriented Programing
how cani create an event or job in mysql to merge the content in the files