Student ID: Student Name: Date:.

Student ID:
Student Name:
Date:

Dependency Diagram
Transitive Dependency
ClinicianLocation  ClinicianName
3rd Normal Form Dependency Diagram
(Guru99 2016)
(Brombarg P. n.d.)

ER Diagram

References
Guru99 (2016). Learn Database Normalization with the help of a case study. Retrieved from:
http://www.guru99.com/database-normalization.html
Brombarg P. (n.d.). SQL SERVER Database Normalization Basics for Developers. Retrieved
from: http://www.nullskull.com/a/1629/sql-server-database-normalization-basics-for-
developers.aspx