- Essaymusk

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Critical Aspects of Database Design, Development, and Application

Given the fact that various types of databases are being used in healthcare, it is relatively difficult to make universal conclusions. Also, the databases that are meant, for example, for patient data and human resource one are likely to be different. Similarly, the database scope can define the specific needs and issues related to it (national data warehouse and a local electronic medical records database are likely to be very different). Still, the typical concerns of data design, development, and application include logical organization (which includes the choice of the database model), cost-efficiency, equipment adequacy, and maintenance activities (Collen, 2012; Wiederhold, 2012).

In particular, it is important that the people who will be involved in the maintenance and modification of the databases are educated on how to carry out their duties. For example, the possible negative consequences of copy-pasting patient data are well-known (American Health Information Management Association, 2014). Also, the confidentiality of the data and backups development are a recurring concern for database development and use (Abdelhak & Hanken, 2014, p. 269).

Database Models

There are several types of database models that are used in healthcare; the most popular one is called relational, and it presupposes the existence of multiple tables with relationships between them (Abdelhak & Hanken, 2014, p. 268). It allows storing data once and retrieving it when necessary from numerous lookup tables (Collen, 2012). Also, it provides the opportunity of removing the patient name from the records and substituting it with the identifier, which is a confidentiality opportunity.

The hierarchical model is built as a treelike structure that consists of parent (or root) and child segments, which defines its typical application: one-to-many relationships (Abdelhak & Hanken, 2014, p. 269). This kind of database is less popular, and its use requires some understanding of the logic of its organization, which makes it useful for advanced users with predetermined queries.

The proposed database from the previous task had three tables, which is why it needed revision for this assignment. Also, when designing the model, I had decided to leave out the specific attributes of entities, and for this task, I had to choose several attributes. I did it using existing databases as examples. In particular, I paid attention to the interactive map on fatal injury data that was created by Centers for Disease Control and Preventions (2013) as one of the WISQARS (Web-based Injury Statistics Query and Reporting System) tools.

Click Here To Order Now!

Do you need this or any other assignment done for you from scratch?

We have qualified writers to help you.

We assure you a quality paper that is 100% free from plagiarism and AI.

You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)