Share
Explore BrainMass

Fundamentals of Database Characteristics and Structure

For this case assignment, you will be assuming the role of a lead person on a technology review committee at a multi-facility regional hospital. Your committee has been tasked with evaluating the plausibility and possible selection of a new health information system that will enable the hospital to electronically collect and share patient medical history information among its various hospital centers and departments.

Currently, each hospital center maintains paper copies and files of patient records, which are separately managed and stored at each facility. Very few of the electronically based information system are integrated between the various centers and locations.

To add to the challenge, the CIO informs you that most of the members on the committee have very limited experience with information systems and databases. However, the CIO is aware that you are studying health informatics, so she has asked you to help familiarize the committee with fundamental concepts related to databases systems and relevant health information standards. Specifically, the CIO (and your professor) request that you prepare a two (full) page paper for presentation to the committee that provides a good overview of the following:

Fundamentals of database characteristics and structure.
Various types of medical data and information records relevant to this project.
The importance of uniform terminology, coding and standardization of the data.
Various information standards and organizations that may be applicable, and possibly required, for this project.
Remember, your committee is mostly comprised of clinicians and other healthcare practitioners. Accordingly, they do not have a great deal of technical knowledge related to information systems.

Solution Preview

This is an original work and has not been previously published or shared with any other source. This work is to be treated as a guideline to assist you with this assignment. At no time is it intended to be a final submission work and I discourage you from using it as such. Points made and topics discussed in this work should be researched further and validated by the student prior to utilizing it in their own work which will be complied for final submission to their schools.
_________________________________________________________________________________________________

Database characteristics and structure:

The purpose of a database is to provide an organized model of maintaining (storing), managing and retrieving information. The concept is largely based on the use of tables to hold information much like that of a spreadsheet. These tables are arranged in columns and rows where each row pertains to a specific dataset or record and each column represents a specific attribute of the data set. For example, if we were to set up a database of names and addresses, we would set up columns names, "First Name". Last Name, and "Address". The in the rows beneath these headers we would begin filling in the specific data consisting of peoples names and addresses. If we had 25 ...

Solution Summary

Provide an over view Fundamentals of database characteristics and structure. 2. Various types of medical data and information records relevant to this project. 3. Remember, your committee is mostly comprised of clinicians and other healthcare practitioners.

$2.19