Database Normalization and Design.

Running head: DATABASE NORMALIZATION AND DESIGN
Database Normalization and Design
Name of the Student
Name of the University
Author’s Note:

DATABASE NORMALIZATION AND DESIGN1
Table of Contents
Dependency Diagram:.....................................................................................................................2
Multivalued Dependency:................................................................................................................2
Normalization:.................................................................................................................................2
Entity Relational Diagram:..............................................................................................................4
Bibliography:...................................................................................................................................5

DATABASE NORMALIZATION AND DESIGN2
Dependency Diagram:
Figure 1: Dependency Diagram
(Source: Created by Author)
Multivalued Dependency:
The multivalued dependency states that two or more attributes are independent of each
other but dependent on another attribute. In this case, the advisee, committee code and journal
code are independent of each other but dependent on the employee number.
The representation of the multivalued dependency is as following.
EMP_NUM   ADVISEE
EMP_NUM   COMMITTEE_CODE
EMP_NUM   JOURNAL_CODE
Normalization:
The advisee, committee_code and journal_code are multivalued attributes in the table. If
these attributes are converted into atomic values then following table is create for a single row
instance. Then for each atomic value an instance of the employee has to be created.