Functional Dependencies and Normalization Forms in Database Design

Functional Dependencies
Functional dependencies in a schema are defined by when a single attribute represents a group of
attributes completely. These dependencies can be of many types that are a full functional
dependency, partial dependency, and transitive dependency. To represent and remove data
redundancy in the schema, normalization forms are used. These normalization forms are
represented as follows:
1NF – First Normal Form
This normal form represents all types of dependency present in the schema.
1NF (Meeting_id, User_id, Meeting_Date, Meeting_Time, Meeting_Venue, Event_ID, Rating,
Person_ID, Status)
Partial dependencies of the given schema:
Table 1: Meeting (Meeting_id, Meeting_Date, Meeting_Time, Meeting_Venue, Event_ID)
Table 2: Person (Person_ID, Status)
Table 3: Event (Event_ID, User_ID, Rating)

2 NF – Second Normal Form
In this normal form, all the partial dependencies are converted into full functional dependencies.
Table 1: Meeting (Meeting_id, Meeting_Date, Meeting_Time, Meeting_Venue, Event_ID)
Table 2: Person (Person_ID, Status)
Table 3: Event (Event_ID, User_ID, Rating)

3 NF – Third Normal Form
After removing the partial dependency from the schema, a transitive dependency is removed in
the third normal form. And since this table does not have any transitive dependencies hence; 2NF
is 3NF.
Table 1: Meeting (Meeting_id, Meeting_Date, Meeting_Time, Meeting_Venue, Event_ID)
Table 2: Person (Person_ID, Status)
Table 3: Event (Event_ID, User_ID, Rating)