Sunday, February 12, 2012

DATABASE DEFINITIONS.

Field: A field is an item of information which is stored for all records in a database.
An example is featured below.

RECORD: These are complete sets of information. They are composed of fields, each of which contain one item of information.

FILE: A file that contains any type of definition except record instances.

QUERY: A request for information from a database. This can be done by choosing parameters from a menu, query by example and query language.

DATABASE: A database is a structured collection of data stored on a computer and/or server allowing you to organize data records which can be sorted, searched and reconfigured in your preferences.

REPORT: A database report presents information retrieved from a table or query in a preformatted, attractive manner.

DBMS: Stands for Database Management System. A software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Examples included MySQL and many more.

DATA DICTIONARY: A data dictionary defines the structure of the database itself and is used in control and maintenance of large databases.\

DATA TYPE: A particular kind of data item, as defined by the values it can take, the programming language used, or the operations that can be performed on it.

2) EXAMPLES OF FILE, RECORD, AND FIELD IN A TABLE.

3) COMMONLY USED DATABASES.
Five examples include; Google, Phonebooks,

No comments:

Post a Comment