Database Design

Running head: DATABASE DESIGN
Database Design
Name of the Student
Name of the University
Author’s name:

1DATABASE DESIGN
Table of Contents
1. Dependency Diagram:............................................................................................................2
2. Normal Form:.........................................................................................................................2
3. Normalization:........................................................................................................................2
4. Relational Database Model:...................................................................................................4
Bibliography:..............................................................................................................................5

2DATABASE DESIGN
1. Dependency Diagram:
Figure 1: Dependency Diagram of Patient Report Table
(Source: Created by Author)
2. Normal Form:
The proposed table is in the first normal form. The proposed table has a primary key
which fulfils the first condition of the first normal form. Another condition of the first normal
for is that every attribute must have only atomic values. The proposed table has only atomic
values therefore it is in the first normal form. Now, the second normal form states that the
non-key attributes must be dependent on only the key attributes. However, as shown in the
dependency diagram of proposed database, the non-key attributes are dependent on other
non-key attributes. This is why the table is not in the second normal form. If the table is not
in second normal form, it cannot be in third normal form.
3. Normalization:
First Normal Form: As shown in the figure 1 dependency diagram, the table is in the
first normal form.
Second Normal Form: The proposed table has partial dependency. As shown in the
table, the Triage_Category, Clinician_name, Clinician_location, Departing_status are