A database is a datastore. They are used to hold all tables related to a particular application. Each table then contains specific information per design. For example: A database named Shipping, will contain tables named Customer Info, Inventory, Order Info, Customer Shipping Info. Each Table will contain specific data related to its purpose. For example Customer Info table will contain fields of data for First Name, Last Name, Middle Init, Home Address, Home State, Home City, Home Zip, Home Phone, Customer ID. Customer Shipping table Info would contain Customer ID, Shipping First Name, Shipping Last name, Shipping Middle Init, Shipping Address, Shipping City, Shipping State, Shipping Zip, Shipping Phone. The tables in the above example are joined by the key field Customer ID. As I can see from the answers given so far, people are making the mistake of confusing the Database with the Table. They are different.
2007-03-27 02:47:07
·
answer #1
·
answered by Sane 6
·
0⤊
1⤋
The term or expression database originated within the computer industry. Although its meaning has been broadened by popular use, even to include non-electronic databases, this article takes a more technical perspective towards the topic. Database like records have been in existence since well before the industrial revolution in the form of ledgers, sales receipts and other business related collections of data. A possible definition is that a database is a structured collection of records or data which is stored in a computer so that a program can consult it to answer queries. The records retrieved in answer to queries become information that can be used to make decisions. The computer program used to manage and query a database is known as a database management system (DBMS). The properties and design of database systems are included in the study of information science.
The central concept of a database is that of a collection of records, or pieces of knowledge. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. There are a number of different ways of organizing a schema, that is, of modelling the database structure: these are known as database models (or data models). The model in most common use today is the relational model, which in layman's terms represents all information in the form of multiple related tables each consisting of rows and columns (the true definition uses mathematical terminology). This model represents relationships by the use of values common to more than one table. Other models such as the hierarchical model and the network model use a more explicit representation of relationships.
The term database refers to the collection of related records, and the software should be referred to as the database management system or DBMS. When the context is unambiguous, however, many database administrators and programmers use the term database to cover both meanings.
Many professionals would consider a collection of data to constitute a database only if it has certain properties: for example, if the data is managed to ensure its integrity and quality, if it allows shared access by a community of users, if it has a schema, or if it supports a query language. However, there is no agreed definition of these properties.
Database management systems are usually categorized according to the data model that they support: relational, object-relational, network, and so on. The data model will tend to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
2007-03-27 11:04:13
·
answer #2
·
answered by Anonymous
·
0⤊
1⤋
Database like records have been in existence since well before the industrial revolution in the form of ledgers, sales receipts and other business related collections of data. A possible definition is that a database is a structured collection of records or data which is stored in a computer so that a program can consult it to answer queries. The records retrieved in answer to queries become information that can be used to make decisions. The computer program used to manage and query a database is known as a database management system (DBMS). The properties and design of database systems are included in the study of information science.
more:
http://en.wikipedia.org/wiki/Database
2007-03-27 09:39:25
·
answer #3
·
answered by $Sun King$ 7
·
2⤊
2⤋
Lots of things like inventory, survey data, all kinds of analysis of information.
2007-03-27 09:38:43
·
answer #4
·
answered by Anonymous
·
0⤊
1⤋
to store data
2007-03-27 09:42:40
·
answer #5
·
answered by kissybertha 6
·
0⤊
1⤋
are you serious ?! everything in short !!!!!!!!!!!!
2007-03-27 09:38:18
·
answer #6
·
answered by Anonymous
·
0⤊
1⤋