4th Normalization form

Here is an example of first 3 normal form...What will be 4th Normal form in this.


Unnormalized data :

Table : Meeting_history_table  :
Meeting_no    
meeting_date
meeting_attendees1
meeting_attendees2
meeting_attendes3
meeting_outcome1
meeting_outcome2
meeting_outcome3
meeting_conference_number
meeting_conf_key

In this way we are restricting the outcomes and attendees of the meeting

First Normal Form => Eliminate repeating groups in individual tables
Create a separate table for each set of related data.
Identify each set of related data with a primary key.

Tables should have only two dimensions. Since one meeting has several outcomes, these outcomes should be listed in a separate table. Fields outcomes 1, outcomes 2, & outcomes 3 in the above record are indications of design trouble.

Table : Meeting_history_table  
Meeting_no    
meeting_date
meeting_attendess
meeting_outcome
meeting_conference_number
meeting_conf_key

Second normal Form : ELIMINATE REDUNDANT DATA

Meet_no    meet_date  meeting_attend meeting_outcome conf_no conf_key
_____________________________________________________________
1            10 jan              jolly            abc                  123            12
1            10 Jan              jolly                xyz                  123            12

Make the separate table of attendee , to eliminate the redundant data.
Table : Meeting_history_table  
Meeting_no    
meeting_date
meeting_conference_number
meeting_conf_key


Table : Meeting_attendees
Meeting_no
Meeting_attendee

Table : Meeting_outcome
Meeting_no
Meeting_outcome

Third Normal Form : ELIMINATE DATA NOT DEPENDENT ON KEY
Since conference details are not depend on primary key ( Meeting No), make the separate table of conference details.

Table : Meeting_history_table  
Meeting_no    
meeting_date
Conf_id


Table : Meeting_attendees
Meeting_no
Meeting_attendee

Table : Meeting_outcome
Meeting_no
Meeting_outcome

Table : Conference_master
Conf_id
Conf_no
Conf_key