A database is used to collect and organize data. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as a personal phone and address book.Continue Reading
A database can simply be a list that is kept written or typed on paper, in a computer spreadsheet or word processing document. This type of database, called a flat file, consists of one table with rows and columns of data. For example, a simple database for a small business might contain only two columns, product name, or brand and price. If a customer calls to ask about pricing, the store employee scans down the first column to find the product and then looks at the associated price column to answer the customer's question.
Most computerized databases are considered relational databases and are created using structured query language generally referred to as SQL. This type of database uses multiple tables of data that are related and ties them together with keys - a common identifying code. For example, a department code might serve as a key that ties department information and product tables together. These types of databases prevent multiple entries of the same data, provide fast sorting and various reporting opportunities.Learn more about Software
A database is a collection of data that can be stored and retrieved, while a data warehouse is a collection of integrated information that can be analyzed quickly and efficiently. A data warehouse is a special type of database.Full Answer >
Data integrity testing refers to a manual or automated process used by database administrators to verify the accuracy, quality and functionality of data stored in databases or data warehouses. This test is regularly done by administrators to ensure that stored data has remained unaltered and to discover system design bugs that could compromise the files in a database.Full Answer >
In database design, a primary key is important because it serves as a unique identifier for a row of data in a database table. A primary key makes it convenient for a user to add, sort, modify or delete data in a database.Full Answer >
In a database, the field is the smallest source of input for users to enter data. For example, a field in a database may ask for a company's name, tax identification number or income. A group of many fields is called a record, and a field in a spreadsheet is known as a cell.Full Answer >