preview

Dbm 381 Week 1 Individual

Good Essays

Examination of the types of database systems that are available and how health care facilities utilize these different types of databases is the topic of this report. Giving more detail on the different types of architecture of databases and data structure will follow. Defining Health Care Database Systems A computerized clinical database consists of clinical data for storing, retrieving, analyzing, and reporting of information (McCartney, 2012). The data in these databases help in managing care plans, research projects, and creating reports for the different departments within a health care facility. The first type of database that a health care facility may use is Operational database. This database consists of data on …show more content…

UNIX systems use to use flat files for storing data. Word processors and spreadsheet software can create flat files. Health Care facilities might use this type of data file for posting employee phone lists. Hierarchical database have data in a tree like structure with a parent to child relationship (one-to-many). The parent could have many children but the children have only one parent. All the attributes of the data is in a list under one entity type. A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity. Conclusion The information about the different types of databases that are available helps to explain the type of health care facilities use. The presentation of details on the architecture of databases and how they differ was the main topic of this

Get Access