TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Savita Joshi
NA
129
132.7k
Normalization:Different forms ,need help in understanding them
Apr 20 2011 12:04 AM
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
Reply
Answers (
6
)
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