Database Mangement and Retrieval System

A Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. The system does not require many assumptions about how data is related t or how it is to be extracted from the database. The database can be viewed in several forms.

Data is a group of information that are used for various purposes like analysis, evaluations and to arrive at certain results or conclusions. Data reporting is a process where data is extracted form a source or many sources and then converted into a format that can be used for a purpose.

Data is facts and numbers that hasn’t been modified or analysed for example times and numbers. When data is by itself it has no meaning to it however information by itself does have a meaning.

The Database Management System of a healthcare organization is an application to perform administrative tasks on a database and interacts with the data stored in the databases. Years ago information was managed by a hands-on method such as files in the file cabinet. Now, databases are utilized by technology to drive and manage information. These “databases are an organized collection of data typically stored in an electronic format. Databases allow input, manage, organize, and retrieve data quickly” (Cornell, and Morris, 2015). Then Technology takes the data collected and transforms it into information which becomes knowledge to the users. The purpose of the study is to examine the use of the database system in nursing and to determine the benefits and challenges of the healthcare organization to use database systems and data.

- Information: is a knowledge which can be transferred or received concerning a particular fact or situation. And is a sequence of symbols that can be explained as a message. Information can be recorded as signs, or transmitted as signals.

Data is the form of input, which can be produced into information. For example, 5000 could be the value of a piece of data that a business has. By adding context to this, for example if an organisation sold 1000 sandwiches in a week; this becomes information, which will influence important decisions

Information is data that has been processed so that it has meaning and value to a recipient,

Data comprises of factual information. Data are the facts from which information is derived. Data is not necessarily informative on its own but needs to be structured, interpreted, analysed and contextualised. Once data undergoes this process, it transforms in to information. Information should be accessible and understood by the reader without needing to be interpreted or manipulated in any way.

Information: It is interpreted data which has been given meaning. It answers questions such as “who”, “what” and “where”. It is data which is organized and structured.

Information is data which is accurate and timely specific and organized for a purpose presented within a context that gives it meaning and relevance. Information can lead to an increase in understanding and decrease in uncertainty.

Data is a collection of facts that can be measured or translated. Data may consist of words, numbers, observations, descriptions of things, and measurements. Data may be qualitative or quantitative. “Qualitative data is descriptive information that describes something. Quantitative data is continuous measurements of numerical information” (Lind, Marchal, & Wathen, 2011, p. 9). Data can be collected in many ways but the simplest way is direct observation. Understanding data analysis helps people to make an informed decision.

Metadata present a more complete picture of the data in the database than the data itself.

On the other hand, in computer file-based system, the structure of data items are built into the individual application programs. Thus the data is dependent on the data file and vice versa.

What is database management system? Database Management System is a database program. The DBMS manage incoming data, organize it, and provided ways for the data to be modified or extract by users or other programs. This cause, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand. Some DBMS examples include PostgreSQL, MySQL, SQL Server, Microsoft Access, Oracle, FileMaker, RDBMS, dBASE, Clipper, and FoxPro. It is a software system that uses a standard method of retrieving, and running queries on data.

To explore the concepts of Data, Information, and Knowledge independently is to attempt building a large and complex puzzle with only a few pieces from the box. While the relationships between these concepts can be as elusive as finding their universal definitions, it is within these relationships that data, information, and knowledge are most meaningful. In the broadest sense, data exists in the form of unorganized and raw facts about the environment that are collected and stored. When this stored data is transformed and processed into something more meaningful and organized, it becomes information. Perhaps most importantly, is knowledge: the collective information stored in the minds of