Productivity Software: DatabasesThis is a featured page

Databases are most commonly used when you have a lot of data that needs to be organized and recorded. A database is essentially a computerized record keeping system. It stores a collection of logically related material in one place.

Sometimes, organizations will develop databases so that they don't have multiple copies of a document tracking the same thing. Instead, they will create a database and allow users to update the one universal document. When using a database you can also track the versions created by different users. In other words, you can see who updated what.

Databases are all around us and you wouldn't even know it. Schools, libraries, law enforcement agencies, all track huge amounts of information and putting it into a database is the only way of organizing it.

Online organizations such as amazon.com or grocerygateway.com must process online purchase requests and requests for product information from multiple clients simultaneously. These companies must maintain giant databases containing all of the information on the thousands of products that they carry.
What is a database?

A database contains a collection of related items or facts, arranged in a specific structure.

Examples:
§ Telephone directory – names, addresses, and telephone numbers organized in alphabetical order by last name.
§ Airline databases – flights and prices
§ Bank databases – customer names, account numbers





A database doesn’t just hold information—it helps you organize and analyze the information in different ways.

Database Terms

File A group of records that have been saved together.
Record The complete set of information available about an individual
person or object. A record is made up of a group of fields.
Field A field is a specific category of information.


A database program is a software tool that allows many users to access, store, and process data or facts into useful information.

Although you can perform many tasks with a database, including creating and designing the database itself, data-management tasks fall into one of three general categories:

§ Entering data into the database
§ Sorting the data; that is, arranging or reordering the databases’s records .Eg. Arranging a list of customers by first name, last name, etc.
§ Obtaining subsets of the data

What makes a database a better tool for managing information than a word processor?

A database can temporarily hide information you don’t need.
With a word processor, you can’t hide part of the information.

What makes a database a better tool for managing information than a spreadsheet?

With a database, you can display information in many ways.
With a spreadsheet you see information in rows and columns only.



No user avatar
jimfisher72
Latest page update: made by jimfisher72 , Nov 1 2009, 9:11 PM EST (about this update About This Update jimfisher72 Edited by jimfisher72


view changes

- complete history)
Keyword tags: None
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.