NVQ Electronic Database

A database is a structural set of related data that is organized in such a way that the information can be easily managed, accessed, and updated. The purpose of a database is to replace paper documents, files, and filing cabinets. The data collected in databases is an efficient way to store, retrieve, and analyze the information.

It is usually presented in the form of a report in tables, charts, statistics, and graphs or on spread sheets etc. This data may be used to arrive at important decisions within the organisation or with external organisations. So the data report has to be produced in such a way that it meets the aims and

The different information systems are filing cabinets where hard copies are stores or electronically which can be saved changes can

Two computer systems that will be considered are McKesson and Epic. In this scenario the facility is using paper charting for documentation. I have worked at a facility with this type of charting. While we had paper charting, we had a computer system for lab results and radiology reports. This computer system was McKesson. Therefore I will use this example for my project.

Although, I found Boolean’s commands confusing I used it once I went over “Construct your search using Boolean commands.

Filing systems are used to easily identify where documents and certain pieces of information have been stored, this makes it easier to retrieve for future use as it will limit the amount of time spent retrieving this information.

The main purpose of storing information is for easy retrieval in the future when it is required. Storing certain information may be part of company policy. There will be procedures in place in order to make sure files are stored correctly and in line with data protection. Depending on the type of information, information can be stored in either filing cabinets or electronically. Depending on the nature of the business, different types of information will have to be stored, for example a legal practice needs information such as court

will hold attendance data for all students registered on all courses but it will be possible to

If you feel uncomfortable with Excel, you can find many helpful references on Excel by performing a Google search.

Data is very important thing in every business, especially in today’s dynamic world where optimal use of data leads to success in shorter span of time as lots of companies are struggling for truthful and accurate data. These data must be analyzed in exact time and in a proper way so that the decision is more effective, but the data we receive are very redundant and carry lot of space in our system. This creates a challenge for the Analytics people to remove the redundancy and bring out only those relevant data that aids in decision making process. Master Data Management is a solution for such Analyst who wants to eliminate the redundant and inconsistent data of the organization (Vinculum, 2016).

I have been using the Excel spread sheet to store, edit and update the collected data. These data can be transferred to the required charts, tables by using the relevant formula and Boolean factors.

Computer Information Systems (CIS) have forever altered the way in which organizations conduct business. No longer is commerce managed through clunky and expensive paper-based transactions. The advantage of this archaic process, though, was that it allowed corporations to store their documents in secure locations under tight lock & key. Today however, these cabinets have been replaced with database systems. Database systems are the modern version of filing cabinets, which house the vast data transacted by corporations.

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

In business word wide the use of information technology systems is what keeps a business functioning properly. Every business holds a substantial amount of information that they must learn to sort, utilize and store efficiently. Everything a business does in their day to day operations requires the use of both information and technology. Payments, employee information, records, client information, all of this must be processed, stored, organized and analyzed for later use in the business. For example, at the end of a year businesses will need to pull old records and reports so that they can make predictions for future profit and pay their taxes to

Table –this is where data is stored for processing and output .The table is defined as a collection of correlating data consisting of rows and columns. For example, the CUSTOMER or PURCHASES table may entail the customer first name, last name, address and the product that the customer purchased or wishes to purchase.