DATABASE NORMALIZATION AND DESIGN.

Running head: DATABASE NORMALIZATION AND DESIGN
Database normalization and Design
Name of the Student
Name of the University
Authors note

DATABASE NORMALIZATION AND DESIGN
1
1. Dependency diagram for the given table
The following functional dependency in determining the association among two
attributes in table of relational database. As depicted below one attribute is called the
determinant and another which is pointed by the previous attribute is known as
determined.
Here, as depicted in the above diagram, the Meeting ID is capable of determining the
meeting date and meeting date, time and venue. In addition to that, the userID attribute itself
is capable of determining the user availability stored in the database.
In the above diagram there is a multivalued dependency, which is the MeetingID,
MeetingDate are capable of determining the Meeting Venue.
2. Decomposition in 3NF
1 NF
According to the rules of normalization, in a first normal form an attribute or column
in a table should not hold multiple values, thus it should have atomic values.