Marketing Forums                      

Important Announcement Regarding Sponsorship and Advertising

Go Back   Marketing Forums > Webmaster's Lounge > Database Discussion

Database Discussion Dedicated to database and SQL related topics (MySQL, PostgreSQL, Oracle, SQL Server, etc.).

Reply
Submit Tools Thread Tools Search this Thread Display Modes
Unread 10-28-2013, 05:38 AM   #1
MBATrainer
Member
 
Join Date: Oct 2013
iTrader: 0
Referrals: 0
Posts: 44
Reputation: 10
MBATrainer is on a distinguished road
Default Normalization Forms

I have read that there are five normalization forms but our all complex problems are solved up to third normal form. Please guide me about the use of other two normal forms.

MBATrainer is offline   Reply With Quote
Unread 09-24-2014, 06:41 AM   #2
kathleencollins
Member
 
Join Date: Aug 2014
iTrader: 0
Referrals: 0
Posts: 36
Reputation: 10
kathleencollins is on a distinguished road
Default

Under fourth normal form, a record type should not contain two or more independent multi-valued facts about an entity. In addition, the record must satisfy third normal form. The main problem with violating fourth normal form is that it leads to uncertainties in the maintenance policies.



Fifth normal form deals with cases where information can be reconstructed from smaller pieces of information that can be maintained with less redundancy. Second, third, and fourth normal forms also serve this purpose, but fifth normal form generalizes to cases not covered by the others.

Fourth and fifth normal forms both deal with combinations of multivalued facts.
kathleencollins is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:09 AM.


Navigation
Marketing Forums Homepage
Forum Home
Marketing Forums News
iTrader
Calendar
Forum Rules
Forum Statistics

FREE Link Directory
Link Directory Home
Link Exchange Programs
Affiliate Networks
Business Opps
CPM Ad Networks
Contextual Ad Networks
Domain Parking
Paid To Click
Paid To Read
Paid For Action
Paid To Promote
Shopping Rewards
Pay Per Click Programs
PPC Search Engines
Pay Per Sale
Work At Home Opps
Advertisements

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Marketing Forums | This is a Metabin Ltd. Website