Database Development

Running head: DATABASE DEVELOPMENT
Database Development
Name of the Student
Name of the University
Author’s note

1DATABASE DEVELOPMENT
Table of Contents
1) Approval of Project Topic:..........................................................................................................2
2) Abstract:......................................................................................................................................2
3) Design Method:...........................................................................................................................2
4) Description of Entities and Attributes:........................................................................................3
5) Functional Dependency:..............................................................................................................4
6) Relationships:..............................................................................................................................5
7) Normalization:.............................................................................................................................5
a) First Normal Form:..................................................................................................................5
b) Second Normal Form:.............................................................................................................6
c) Third Normal Form:....................................................................................................................6
Bibliography:...................................................................................................................................8

2DATABASE DEVELOPMENT
1) Approval of Project Topic:
Yes
2) Abstract:
The database is created for supporting a healthcare organization to record the diseases
and patient database. The database is supposed to be storing the data of the diseases, patients and
which patient has diagnosed with which diseases. The spread sheets are very error prone and
time consuming. Finding results from a spread sheet is a complex work that everyone does not
understand. For this reason, the database is implemented. It will provide the doctors and other
staff of the organization a simple interface to interact and easy communication medium. The
database is developed also with the purpose of allowing the doctors to find the treatment related
information very easily. As the RDBMS is based on establishing relationships among the
entities, the developed database in Microsoft Access will be extremely useful for the
organization.
The database will run the query of identification of the patient and diseases name based
on the most frequent diseases from a certain date to year end. This query combines both the
patient and diseases entities. These entities together provide the details of the diseases frequency
information. This query is based on the referential integrity between patient and diseases. If the
referential integrity is correctly formed, then finding the result would be possible otherwise the
database cannot support the basic need of the query.