Database Design Project: Patient Report System Normalization and ERD

Desklib provides past papers and solved assignments for students. This project focuses on database design for patient reports.

Contents
Part-A Dependency Diagram:....................................................................................................2
Part-B Normalization.................................................................................................................2
1NF.........................................................................................................................................2
2 NF........................................................................................................................................2
3 NF........................................................................................................................................3
Part-C ERD................................................................................................................................4
References..................................................................................................................................5
List Of Figures
Figure 1 Functional Dependency Diagram................................................................................2
Figure 2 first Normal Form for Patient_report...........................................................................2
Figure 3 Patient_description......................................................................................................2
Figure 4 Problem Description....................................................................................................2
Figure 5 Relation of Patient_report............................................................................................3
Figure 6 Patient_description......................................................................................................3
Figure 7 Problem_description....................................................................................................3
Figure 8 TriAge_measures relations..........................................................................................3
Figure 9 Clinic_Info Relation....................................................................................................3
Figure 10 Relation of Patient_Report........................................................................................4
Figure 11 Patient_report Entity Relationship Diagram..............................................................4

Part-A Dependency Diagram:
Figure 1 Functional Dependency Diagram
Functional Dependency can be defined as a relationship in between two attributes. In simple
words, the relationship between PK and other attributes can be defined by functional
dependency.
Part-B Normalization
1NF
Figure 2 first Normal Form for Patient_report
2 NF
Figure 3 Patient_description
Figure 4 Problem Description

Figure 5 Relation of Patient_report
3 NF
Figure 6 Patient_description
Figure 7 Problem_description
Figure 8 TriAge_measures relations
Figure 9 Clinic_Info Relation

Figure 10 Relation of Patient_Report
Part-C ERD
Figure 11 Patient_report Entity Relationship Diagram

References
Rao, J. (2017, November). Design of Bilingual Course Teaching of Database Principles. In
International Conference on Education Innovation and Social Science (ICEISS 2017).
Atlantis Press.
Tomoda, A., Isoda, Y., & Ushijima, K. (2016). U.S. Patent Application No. 14/894,042.