Part A: Database Records l
- The patient residing in Carlifornia is Sofia Yakaria Pallares and 10259 is her patient number.
- Ruth Ann Raymond is the provider for Sofia and her credentials proffered as MD
- The patient seen on 5th November, 2010 is John Peter. The date of birth for John peter is 25th, May 1965
- The name of the patient is Lucy Ann Johnson and was born on 6th December, 1975. The doctor saw her on 06/04/2011
- John peter is the patient living on 1704. This is the Atlantic Avenue allied to the Ontorio, AZ. The encounter number is 111218
Part B: Database Records ll
- Database components
The use of a database is to retrieve and store data. The database is housed in database servers. It is the role of database management system to ensure that the server is controlled. Firms make use of data management system to assist them in managing data effectively as well as retrieve data and information from it (Coronel & Morris, 2016). It is also worth mentioning that the data management systems supports management of data in an organization by defining, managing, and manipulating data contained in the database.
The main components of a database include the table and querry language among others. Note that a simple database has one table that has columns for defining the data elements and rows for the data. The table column has data elements such as address, name, state, and city as well as phone number (Coronel & Morris, 2016). On the other hand, a record or a table row has the data meant for each individual. The query language offer a way of finding particular data types in every record. It returns the outcome or results matching the defined criteria.
- Use of relational data based on Part A above
Relational data as seen in part one use multiple tables to define associations and relationship between the tables by use of schema. The schema works with the data elements to define relationships (Coronel & Morris, 2016). The data elements and records from every table merge depending on the query and the results are displayed on the form. It is worth mentioning that queries that are used routinely forms reports.
- Importance of databases in health care
A database enables easy and effective retrieval of data. With database, health care professionals can retrieve information regarding their patient and use it or share it to their colleague without wasting much time (Coronel & Morris, 2016). More so, data bases help create a list of the health care providers based on their specialty, names, gender etc.
In addition, a database can create a targeted list of health care providers by location, gender, specialty and more. The database also enables the health care providers retrieve data regarding a certain patient without necessarily consulting or contacting anyone (Coronel & Morris, 2016). This makes work easier within the healthcare facilities. In furtherance to this, the health care providers can easily search for any information via the databases without much effort.
|Information systems||Is a collection of software, hardware, trained personnel, and infrastructure combined to facilitate and enhance control, planning, decision making and coordination in an organization||To assists the user to analyze and organize data|
|hardware||All the physical parts in an information or a computer system (Coronel & Morris, 2016)||Enables the user to interact with the information system/computer|
|CPU||It is the processor of the computer. It acts as the brain of the computer||Most of the calculation takes place in the CPU|
|Memory and storage||This is where information is stored||Storage of data and information|
|Output and input devices||Output devices are used to send data out of the computer to another system or user. Input device on the other hand , moves data from other sources to the computer||Ensure effective transfer and use of data and information (Coronel & Morris, 2016)|
|software||Programs used by computers (Coronel & Morris, 2016)||Offers basic functions required by software and users and proffers platform needed to run application|
|Operating systems||It refers to system software, which manages computer software and hardware resources. It offers services for the programs used in a computer.||Enables the functionality of all computer programs|
- Difference between computer software and computer hardware
Computer hardware refers to the physical devices used in computers. On the other hand, computer software refers to a collection of codes that has been installed in the hard drive of a computer system. A good example of computer hardware is the mouse and monitor (Coronel & Morris, 2016). Conversely, the browser and the operating system that allows the browser to run is software.
- Importance of information systems in healthcare
Information systems are useful in the health care systems because they improve the medical care. With the use of information systems, the work involved in the health care is made easy because systems handle much of the data analysis fasters. More so, it is easier to retrieve data and information using computer systems (Coronel & Morris, 2016). Additionally, information systems lower the costs of medication because they reduce much of the manual works in a healthcare facility. For instance, a data base system, which is a component of information systems, reduces the time and effort required to obtain patient data.
Information systems also store much of the data used by health care professionals. Storing such data would be very exhausting without information system. In furtherance to this, information systems increase efficiency in the healthcare sector. It also reduces chances of an error occurring and improves the satisfaction of patients (Coronel & Morris, 2016). In addition, data analytics and data visualization, which are part of information systems enable interpretation of data, notably big data. With data visualization, health care providers are able to identify some of the areas that require attention or rather some of the diseases that need attention and perhaps research.
Furthermore, information system in the healthcare is critical in enhancing communication. The management has to distribute and gather information. Therefore, the information system available makes the process easier and efficient by allowing the parties involved communicate rapidly. For instance, the management can use an email to communicate. However, the management can make the communication more efficient by storing the information in folders where all the employees can access as need arises. More so, the employees can edit the information whenever necessary or rather share it to patient when necessary.
Information systems are also imperative in assisting the management of health care facilities make decisions. When the management has accurate and updated information, they have the capacity to make decisions with more confidence. Information systems can also be used to run different scenarios if the data or output obtained is not appealing. The different possibilities, the systems can be used to check the cost of proffering certain medication, the data associated with particular patients and the profits made in the health care facility.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
Galliers, R. D., & Leidner, D. E. (2014). Strategic information management: challenges and strategies in managing information systems. Routledge.
Wirtz, A., Kron, W., Löw, P., & Steuer, M. (2014). The need for data: natural disasters and the challenges of database management. Natural Hazards, 70(1), 135-157.