Case Study Director's Request for Pcs- Part 2: Vendor Database (Ms Access)

Databases are the heart of the company. This is where all crucial company information is stored and can be accessed. Some databases are stored on site others in remote locations or using clouds. The information within a database can be manipulated in any way that the company needs it to be. Databases help to quickly search and retrieve information, it saves from data redundancy.

The term database was popularized with the growth of the computer industry and is typically thought of as software used to store, index, manipulate, and retrieve information (Vaughn). Database software has been in use since the Census Bureau used a punch card system to meet the requirements for the collection, sorting, and reporting of data for the 1890 census (National Research Council). These earliest databases were flat file databases. The flat-file style of database works well for small amounts of data that need to be organized to be read and edited by hand. Flat file databases are made up of tables that store a set number of characters in each field. The individual tables are

The reasons why various organisations use databases are because databases can be used to improve productivity. The term ‘productivity’ basically means the “average measure of the efficiency of production”. For example this can be done by “collaborative working”. The term “collaborative working” means “the act of two or more people or organizations working together for a particular purpose”, this definition I received off a website named ‘http://dictionary.cambridge.org/’. My own definition of “collaborative working” is when people work as partners for a fixed time to fulfil a specific purpose. Collaborative working improves productivity in databases, as by working as partners you are sharing and receiving different kinds of information, so this

Once data are collected and integrated, they are stored in effective formats to facilitate their efficient and easy retrieval. For such purposes, the concept of the database has been utilised. A database is referred to as “the collection of related data, which are organised so that useful information may be extracted” (Wiederhold, 1980). Databases provide a single and comprehensive place for storing data. A collection of various paper-based files and electronic spreadsheets or files containing similar types of information are also categorised as databases. However, databases are considered effective not only because relevant data can be stored in a comprehensive and single format but also because they can be linked in an effective way to

Since the beginning of the industrial revolution, people have been trying to make their life easier using machines. This has led to huge technological breakthroughs that brought about computers, cars, airplanes etc. Nowadays computers are widely used to perform various tasks on users’ behalf. Another people’s passion since ancient times is to store and preserve information for the generations to come (libraries, archives). During the 1960’s people’s desire to store and retrieve information was combined with the opportunities that computers offered to create the first computerized database. This turned out to be a milestone in the way people manage information. It offered many advantages: Data can be organised easy; it takes up very little physical space; users can search the data for specific information; The Database can be shared between different users; it can be accessed remotely etc. Due to these advantages, the new modern way of collecting data gradually replaced paper Databases. It became a much more cost-effective way for organisations and companies to store their data. Currently, computer databases are being used everywhere: Facebook, online stores such as Amazon and eBay, airports, hospitals, government institutions etc. Even the libraries that are considered to be old-fashioned have stored their information electronically.

Data: Data is processed through systems, this data is processed so that it can be useful; it can be used by organizations to base their decision making on it. This is very important to organizations, after analysing data, organizations can forecast the future, and make changes so that they become more successful. Organizations are able to react quickly to changing markets, so they don’t fall behind competitors. An example of this would be if a retail business sees that a product isn’t selling as well as it should, they can decide that they should buy more of that product, as it wouldn’t be cost-effective. When data is processed by computer system, it changes to become information, information is basically just data with added context so that it makes a much more clear purpose.

A Database is a collection of information that is organized so that it can be easily accessed, updated and managed. Databases can be classified in order to the type of the content: full-text, bibliographic, images and numeric.

In the context of meaning, data is something plain, raw, unorganized facts that need to process to be meaningful while information is a collection of many data that is meaningful to the user. For example, the score of science test, date of birthday,

Database: is a collection of data organized to service many applications at the same time by storing and managing data so that they appear in one location.

With the development of technology, information storage and management have been vital of importance. Information effectiveness and efficiency are determined by how well data is organised and processed. The term ‘data’ have been widely employed in different human activities, including science, business, education, law and the like. Here, data is a means for representation of facts, concepts, and instructions in order to communicate (Sumathi & Esakkirajan 2007). Nevertheless, if data management is ineffective, and relevant information cannot be found quickly, a large amount data will become a liability rather than an asset of an organisation; thus, tools used for data management give rise to the occurrence of database

A database is an organized collection of data. It is the collection of tables, queries, reports, viewings, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the structure of a major business such as Walmart, and all of its data including things like their inventory, customers, and their employees. A database management system is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general purpose database management system is designed to allow the definition, creation, querying, update, and administration of databases.The Database uses terms that are key for anyone to sift through the collection of data that any company or business collects. terminology consists of keywords that will help users select desired pieces of data.

Data is the most important component of the DBMS. The main purpose of DBMS is to process the data in efficient and convenient way for the users. In DBMS, databases are defined, constructed, modified , inserted and accessed from the database. There are two types of data in the DBMS. They are

Data is facts of the world. For example statistical facts on yourself – your height, weight, hair and eye colour. All of these facts are data. Data is perceived through our senses and then the brain can process it into knowledge.

A database is a collection of information sequenced and organized in such a way that the computer may be able to source and access it on demand by the operator. Like any other management system, a database management system is a collection of programs and protocols that enable the user to enter, sequence, organize, retrieve and select data on demand. Thus, a database management system (abbreviated as DBMS) can be defined as the cumulated system that helps the user to access and make effective use of a database on proper authentication.

1. Database – collection of data on computer: a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated. (Encarta Encyclopedia)