Topic:  Flat File vs. Relational Databases Models

APA format. No Plagiarism. 250-300 words

(Watch YouTube video:  https://www.youtube.com/watch?v=z2kbsG8zsLM Links to an external site. )

2.3 minute video contrasting the difference between flat file and relational databases

AHIMA Competency/Learning Outcome:

lll.6  Describe the concepts of managing data

Assignment:

In your role as an IT specialist at your hospital, you have been approached by the chair of the pediatric department to assist in the creation of a database for collection of information on a variety of childhood communicable diseases and vaccination status.  You propose using a data warehouse, which would pull information from the hospital’s clinical repository.  The chairperson is unfamiliar with these terms and asks for clarification.

1.  Explain the concept of a data warehouse and differentiate it from clinical repository.

2.  The chairperson states he is familiar with flat file databases and inquires about their use for this project.  You state that a relational database may be the better choice.  Support your position regarding a relational database being a better choice than a flat file database.

youtube.com/watc Links to an external site. h?v Links to an external site. =B-13vQuxYrs Links to an external site. –if necessary, just cut and paste and put in browser; or find your own youtube video on the two kinds of databases to review to complete this assignment..